function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Difference between exporting a report and exporting via data loader?

Rounak SharmaRounak Sharma
Hello Nyshaa,
Exporting a Report
When exporting a report in Salesforce Classic or in Lightning Experience as Details Only, you can export an unlimited number of report rows and columns. Most spreadsheet tools have a per-file row and column limit. Common tool-imposed limits are 1,048,576 rows by 16,384 columns, or 65,536 rows by 256 columns.
When exporting a report in Lightning Experience as Formatted Report, you can export up to 100,000 rows and 100 columns.
Sometimes reports with lots of rows and columns can take a few minutes to export. If a report takes 10 minutes to export, then the reports export times out and fails. If a report export times out, create a copy of the report. Filter both reports so that they each return half the data of the original. Then export each report.
When exporting reports in the comma-separated values (.csv) format, the locale settings on your user detail page determine the field separator (delimiter) included in the exported file. For example, if your locale setting is English (United States), then the decimal separator is a period (“.”), If your locale setting is French (France), then the decimal separator is a comma (“,”). You can override the default separator for your locale by choosing Comma Delimited (non-locale) .csv from the Format dropdown list.
Excel does not display the field separator in .csv format. If you want to work with .csv files in Excel, we recommend that your locale setting in Salesforce match your Regional Options setting in Windows.
Joined reports always export as Formatted Report.

Exporting via data loader
Create a SOQL query for the data export. For example, select Id and Name in the query fields, and click Finish. As you follow the next steps, the CSV viewer displays all the Account names and their IDs. SOQL is the Salesforce Object Query Language. Similar to the SELECT command in SQL, with SOQL, you can specify the source object, a list of fields to retrieve, and conditions for selecting rows in the source object.
Choose the fields you want to export.
Optionally, select conditions to filter your dataset. If you do not select any conditions, all the data to which you have read access is returned.
Review the generated query and edit if necessary.
Data Loader currently does not support exporting attachments. As a workaround, use the weekly export feature in the online application to export attachments.
If you select compound fields for export in the Data Loader, they cause error messages. To export values, use individual field components
Please Let me know if it helps you.