Exporting Backups and Archives
Overview
OverviewThe Export to CSV feature in the Backup & Archive app lets you export data from backups or archives to CSV files for external analysis or reporting. You can export full or filtered datasets and download the results as a .zip file.
Creating an Export
If Email Notifications are enabled for this org, emails will be sent at the start and end of the export job.
Add Objects
Click the Add object menu button to select the Salesforce Objects to include in the export.
Search or browse for objects from the menu.
When searching for an object, enter the Salesforce Object Label, not the Salesforce API Name. For example, enter Content Version, not ContentVersion.
Check the objects you want to add.
Click Add to add all of the selected objects.
(Optional) Add Filters
For Export jobs, declarative filters are limited to Object Name or Object ID, and the operator is limited to equals or in. Use of the in operator greatly expands your filtering options.
Using Filters is recommended to speed up the Export job execution.
Click Filter to add a filter to the object.
Click Add Filter to add a filter. You can add more filters by clicking Add Filter.
Click Apply to save the filter.
Finish Export
Click the Export from menu in the Export Settings section.
Select the export source: Backups or Archives. Configuring each is explained in the following two expandable sections.
Export from: Backups
The As of date lets you choose which version of the records to export based on that date. The records will be exported from the backup that was created closest to, but before, the selected date. For instance, if you have a daily backup at 4 AM and you want to export data from the first of the month, select the first of the month as your date and pick a time that is after the 4 AM backup but before any other backups that day.
Select the As of date.
Export from: Archives
The From date and To date fields enable you to select a range of archived records for export. The records will be exported from the archives created between the selected dates. For example, if you select dates from July 1st to July 15th and there are three archives within this period, the records for the chosen objects will be exported from all three archives.
Archives: Select the From date and To date.
Click Run Export.
You can view the status of the export job in the History table on the Export page.
Downloading Exports
You can download exports marked with Ready for download from the Export page. Exports are marked as Ready for download when they are completed, and records are available to export.
Exports can be downloaded within 7 days after the job finishes; after that, the download option will be removed. Additionally, if no records match the export criteria, no export will be available for download.
Export files are in a zip archive with the following file naming: download-OrgName-DateTime.zip
Click a completed export that is Ready for download.
Click Download to initiate the download process in your browser.
File Structure of an Export
The exported file will have a different structure depending on the export type, Backup or Archive. Each is explained below.
Backup Export File Structure
The .zip file contains a folder for each exported object, and each folder includes one or more CSV files with record data. Each CSV file contains up to 10,000 records. If there are more than 10,000 records, multiple files are created. In the screenshot below, the export includes the FieldPermissions, ApexClass, Report, and User objects. The FieldPermissions object has more than 10,000 records, so it is split into multiple files.
Archive Export File Structure
The .zip file contains a folder for each archive job, named Archive Job ID. Each Archive Job folder contains a subfolder for each object, and each subfolder contains one or more CSV files containing record data. Each CSV file contains up to 10,000 records. If there are more than 10,000 records, multiple files are created. The screenshot below shows an export with two archives, each containing the Account object.
Last updated
Was this helpful?