How to export Salesforce to Excel (and sync changes back safely)

The built-in ways to export Salesforce data to Excel, reports, Data Loader, and the Data Export Service, plus how to edit the data and push your changes back with a diff preview.

Getting Salesforce data out into Excel is easy. Getting your edits back in is the part that trips people up. This guide covers every built-in way to export, when to use each, and how to turn a one-way export into a safe round-trip.

The built-in ways to export

1. Export a report

The most common route for a formatted, shareable extract.

Run the report.
Click Export.
Choose Formatted Report (keeps groupings and headers, exports .xlsx) or Details Only (raw rows, .xlsx or .csv).

Best for: a specific, filtered set of records you have already built a report for. Full steps in how to export a Salesforce report to Excel.

2. Data Loader

Salesforce’s free desktop tool exports any object to CSV in bulk.

Open Data Loader, choose Export (or Export All to include archived/deleted).
Pick the object and fields, or write a SOQL query.
Save the CSV.

Best for: large or whole-object exports by an admin. See the Data Loader guide.

3. The Data Export Service

Setup has a scheduled backup export (Setup, then search Data Export). It produces a set of CSV files in a zip, weekly or monthly depending on your edition.

Best for: periodic backups of the whole org, not day-to-day editing.

4. List views

A common question: can you export a list view straight to Excel? Not directly in standard Lightning. The usual workaround is to build a quick report from the same filters, or use Data Loader or a spreadsheet tool.

The catch: getting edits back in

Exporting is the easy half. The moment you want to change the data and return it, the friction appears:

You re-import a CSV, re-mapping columns to fields.
Nothing shows you a field-by-field preview of what will change before it writes.
Picklist typos (closed won vs Closed Won) slip through or fail on load.
Excel’s date formats (DD/MM vs MM/DD) can shift dates silently.

For a careful edit, that is nerve-wracking: you run the import and hope.

Turning the export into a safe round-trip

A spreadsheet tool like Upcells treats export and import as one flow:

Export to Excel, with restricted picklists as real dropdowns so only valid values go back.
Edit in Excel, Numbers, or Google Sheets.
Preview and sync: drop the file back and see a field-by-field diff (old value, new value, warnings) before anything writes. Nothing changes until you click Apply.

That is the difference between exporting data and actually working with it. More in edit Salesforce records in Excel and sync them back, or compare plans on the pricing page.

When to use which

One formatted extract: export a report.
Large or whole-object dump: Data Loader.
Scheduled backups: Data Export Service.
Edit the data and put it back, safely: a spreadsheet tool like Upcells.

Frequently asked questions

How do I export a Salesforce report to Excel? Run the report, click Export, and choose Formatted Report (.xlsx) or Details Only (.xlsx/.csv).

Can I export a Salesforce list view to Excel? Not directly in standard Lightning. Build a report from the same filters, or use Data Loader or a spreadsheet tool.

How do I export all of my Salesforce data? Use the Data Export Service (Setup, then Data Export) for a full backup, or Data Loader for a specific object.

Can I edit the exported data and import it back? Yes. You can re-import a CSV, or use a tool like Upcells that exports to a spreadsheet and syncs your edits back with a diff preview and picklist validation.