Fix Salesforce CSV Files Opening in the Wrong Excel Columns
Question details
The user needs to open a Salesforce CSV export in Excel with its data in the correct columns.

- Product
- Microsoft Excel and Salesforce
- Device & OS
- not provided
- Scenario
- A Salesforce CSV export is opened in Excel on computers that may have different regional or import settings.
- Observed behavior
- The CSV data is split incorrectly between columns on some computers.
Check which delimiter the Salesforce export uses, such as a comma, semicolon, or tab. If the file contains sensitive data, test with a sanitized sample rather than sharing the original.
Import the Salesforce CSV with the Correct Delimiter in Excel
Use Excel's import preview to choose the delimiter explicitly instead of opening the CSV directly.
Open Excel, select the Data tab, and choose From Text/CSV.
Browse to the Salesforce CSV file, select it, and click Import.
In the import preview, select the delimiter used by the file, such as comma, semicolon, or tab. Check that the preview places values under the expected columns.
Click Load to import the previewed data into the worksheet.

Check the Windows Regional List Separator
Use this check when the same Salesforce CSV opens differently on Windows computers.
Test a Sanitized CSV and Repair Office if Necessary
If the correct delimiter still produces inconsistent results, test a non-sensitive sample before considering an Office repair.
Work with Salesforce CSV Exports in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. It supports common Microsoft Office formats for an easy transition, though it does not repair Excel's import settings.

Frequently Asked Questions
Why does the same Salesforce CSV open differently on two computers?
The computers may use different regional list separators or Excel import settings. On Windows, compare Control Panel > Region > Additional settings > List separator, or import the file using Data > From Text/CSV and select its delimiter.
How do I choose a comma or semicolon when importing a CSV?
In Excel, select Data > From Text/CSV, choose the file, and select the appropriate delimiter in the import preview before clicking Load.
Can I troubleshoot without sharing classified data?
Yes. Create a sanitized sample with the same delimiter and a few representative columns, then test it through Excel's Data > From Text/CSV import.
Should I repair Office immediately?
First confirm the file's delimiter and test the import preview with a sanitized sample. If Excel still behaves inconsistently, follow Microsoft's Office repair instructions.




