Export data as files
You can export your data in various file formats which includes CSV, TSV, JSON, XLS, XLSX and XML formats.
To export data click the Export now option from the top bar in the Operations page.
Select Files from the options in the side pane.
If your data contains columns with personal data, you can choose which columns need to be exported from the PII columns section.
- You can choose to save the exported data as a local file in any of the supported file formats: CSV, TSV, JSON, XLS, XLSX and XML formats.
- Use the Compress file option to save your export as a .zip file.
- You can encode the file using character encoding methods like UTF-8.
- You can also encrypt the file and protect it with a password.
Once you input the required values, click Export.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
New to Zoho DataPrep?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
Related Articles
Export options
DataPrep offers a wide range of export options. Your data can be exported to BI tools, cloud storage services, cloud databases. They can also be downloaded as files in different formats. To export your dataset 1. Click on the Export icon in the top ...Export data to cloud databases
You can export data to the following cloud databases. Amazon RDS - MySQL Amazon RDS - MS SQL Server Amazon RDS - Oracle Amazon RDS - PostgreSQL Amazon RDS - Maria DB Amazon RDS - Amazon Aurora MySQL Amazon RDS - Amazon Aurora PostgreSQL Amazon ...Scheduling data export
You can schedule data export using different export configurations in DataPrep. To schedule data export: Click Export from the top bar in the Operations page and select Schedule export. 2. Click the New schedule button to create a new schedule ...Export data to Zoho Analytics
You can export the refined data to data analytics tools such as Zoho Analytics. To export data to Zoho Analytics 1. Click the Export button from the top bar in the Studio page. 2. Select Zoho Analytics from the export menu in the side pane. 3. You ...Prepared data
Whenever a dataset export is done, a copy of the exported data is stored in DataPrep as prepared data for audit purposes. You can export prepared data as files. To access prepared data in DataPrep 1. Click the numbered link against the Prepared ...