Data Import & Export

Fix Salesforce CSV Files Opening in the Wrong Excel Columns

Khadija KhanKhadija Khan Nov 14, 2026 868 views

Question details

The user needs to open a Salesforce CSV export in Excel with its data in the correct columns.

Fix Salesforce CSV Files Opening in the Wrong Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Start the import

Open Excel, select the Data tab, and choose From Text/CSV.

2
Select the export

Browse to the Salesforce CSV file, select it, and click Import.

3
Choose the delimiter

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.

4
Load the data

Click Load to import the previewed data into the worksheet.

Import the Salesforce CSV with the Correct Delimiter in Excel
Check data types: If Excel changes identifiers or dates during import, select Transform Data in the preview and review the column data types before loading.
Free Microsoft Office alternative

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.

Open and review Salesforce CSV exports in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for a smoother transition from ExcelFree and lightweight office suite
QA img-9

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.