Importing and Exporting Data with Excel

What Will You Learn?

• Create a New Sheet by Importing
• Import Data to Your Existing Sheet
• Import Policy
• Importing Data to Your Existing Subtables
• Save Import Configuration as Template
• Exporting Your Data

Key Concepts

Ragic provides import and export features, allowing you to quickly import existing Excel data into a database and export data as needed.

Importing Data: You can import data to create a new sheet or update an existing one, with the system automatically determining whether to add new records or update existing ones based on the Import Policy, ensuring data consistency and accuracy.

Importing Data into Subtables: Ragic also supports importing multiple detailed records at once and correctly mapping them to a single main record's subtable.

Import Templates: For repeated imports, you can save field mappings and settings as import templates to improve efficiency and reduce errors.

Exporting Data: When exporting data, you can choose the format and apply filters to output a specific range, making it easy to analyze or use the data elsewhere.