Full data export - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Philippe CochetPhilippe Cochet 

Full data export

Could you please indicate the procedure to follow to get the full data exported and sent to me.
Steve MolisSteve Molis

Exporting Backup Data

Weekly export available in: Enterprise and Unlimited Editions

Monthly export available in: All editions, except for Database.com

User Permissions Needed
To export data: “Data Export”

Your organization can generate backup files of your data on a weekly or monthly basis depending on your edition. You can export all of your organization's data into a set of comma-separated values (CSV) files.

Users with the “Data Export” permission can view all exported data and all custom objects and fields in the Export Service page. This permission is granted by default only to the System Administrator profile because it enables wide visibility.

You can generate backup files manually once every six days (for weekly export) or 28 days (for monthly export). You can also schedule backup files to generate automatically at weekly or monthly intervals.

  1. Click Your Name | Setup | Data Management | Data Export and Export Now or Schedule Export. The Export Now option prepares your files for export immediately. This option is only available if enough time has passed since your last export. The Schedule Export option allows you to schedule the export process for weekly or monthly intervals.
  2. Select the desired encoding for your export file.
  3. Select Include in export to include attachments in your export data.
  4. Select Replace carriage returns with spaces to have spaces instead of carriage returns or line breaks in your export files. This may be useful if you plan to use your export files for importing or other integrations.
  5. If you're scheduling your export, select the frequency (only available for organizations with monthly exports), start and end dates, and time of day for your scheduled export.
  6. Select the types of data to include in your export. We recommend that you include all data if you are not familiar with the terminology used for some of the types of data. Note the following:
    • Formula and roll-up summary fields are always excluded from exports.
    • If your organization uses divisions, data from all divisions is included in the export.
    • If your organization uses person accounts and you are exporting accounts, all account fields are included in the account data. For more information on account fields, see Account Fields.
    • If your organization uses person accounts and you are exporting contacts, person account records are included in the contact data. However, the contact data only includes the fields shared by contacts and person accounts.
    • For information on field limitations, see the Salesforce Field Reference Guide.
  7. Click Start Export or Save.

    Salesforce creates a zip archive of CSV files and emails you when it's ready. Exports typically finish within 48 hours of submission, and large exports are broken up into multiple files. Follow the link in the email or click Data Export to download the zip file. Zip files are deleted 48 hours after the email is sent. The 48-hour time limit doesn't include weekends, which means if your download file is ready on Thursday at 4 p.m., that file isn't deleted until Monday at 4 p.m.

    For security purposes, Salesforce may require users to pass a user verification test to export data from their organization. This simple, text-entry test helps prevent malicious programs from accessing your organization's data.

    To pass the test, users must type the two words displayed on the overlay into the overlay's text box field, and click the Submit button. Note that the words entered into the text box field must be separated by a space.

    Salesforce uses CAPTCHA technology provided by reCaptcha to verify that a person, as opposed to an automated program, has correctly entered the text into the overlay. CAPTCHA is an acronym that stands for “Completely Automated Public Turing Test To Tell Computers and Humans Apart”.

Any automated processes that process the export files should rely on the column headings in the CSV files, rather than the position of the columns.

Depending on the encoding selected, you may have to make adjustments to the export file before viewing it. Use the following instructions that apply to the character encoding you selected.

Viewing Unicode (UTF-8) Encoded Export Files

If you have Microsoft Excel 2003:

  1. Open Microsoft Excel.
  2. Click File | New.
  3. Click Data | Import External Data | Import Data.
  4. Select the CSV file to open and Microsoft Excel will launch the text import wizard.
  5. Select “Delimited” and choose the “Unicode (UTF-8)” option for File origin.
  6. Click Next.
  7. Select “Comma” in the Delimiters section and click Finish. You may be prompted to select a range of cells. Note
    If commas are not appropriate for your locale, use a tab or other delimiter.
  8. Repeat these steps for each file.

If you have an earlier version of Microsoft Excel (pre 2003):

  1. Open the file in Microsoft Excel.
  2. Select File | Save As.
  3. Save the file as type Web Page.
  4. Select Tools | Options | General tab and click the Web Options button.
  5. Select the Encoding tab, and then choose the “Unicode (UTF-8)” option.
  6. Click OK to close the dialog boxes.
  7. Select File | Save to save the file with selected encoding.
  8. Repeat these steps for each file.

Viewing Unicode (UTF-16, Big Endian) Encoded Export Files

Open the export files in a text editor that supports this character set. Microsoft Excel does not support this character set.

Viewing Unicode (Little Endian) Encoded Export Files

  1. Open the file in Microsoft Excel.
  2. Click on column A to highlight the entire first column.
  3. Open the Data menu and choose Text to Columns.
  4. Select the “Delimited” radio button and click Next.
  5. Select “Comma” in the Delimiters section and click Finish.Note
    If commas are not appropriate for your locale, use a tab or other delimiter.
  6. Repeat these steps for each file.