Data Import & Export

Fix Excel CSV Files Saving with Tabs Instead of Commas

Amos GikundaAmos Gikunda Nov 20, 2026 868 views

Question details

The user needs Excel to save data as a comma-delimited CSV rather than a tab-delimited file.

Fix Excel CSV Files Saving with Tabs Instead of Commas
Product
Microsoft Excel
Device & OS
Windows
Scenario
Exporting workbook data to CSV when the Windows list separator is set to a comma.
Observed behavior
The exported files appear to use tabs instead of commas despite the regional list separator setting.
Before you start

Open the exported file in Notepad to check whether tabs separate the fields. In Excel, check whether the affected data is combined in one column and make sure adjacent columns are empty before splitting it.

Solution 1Recommended

Split tab-delimited data and save it as CSV

Use this method when tab-separated source data appears together in one Excel column.

1
Select the affected data

Open the file in Excel and select the column containing the tab-separated data.

2
Split the data

Go to Data > Text to Columns, choose Delimited, and click Next. Select Tab, clear other delimiters if they are not needed, and check the preview.

3
Finish the conversion

Click Next, choose an empty destination if necessary, and click Finish to place the fields in separate columns.

4
Save as CSV

Choose File > Save As, select CSV (Comma delimited) as the file type, and save the active sheet.

5
Check the output

Open the saved CSV in Notepad and confirm that commas separate the fields.

Split tab-delimited data and save it as CSV
Check the destination columns: Text to Columns can overwrite data in adjacent cells. Choose an empty destination or clear space before finishing.
Free Microsoft Office alternative

Work with CSV Files in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets and CSV files. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files into WPS, though it does not change Excel's export behavior.

Open and edit CSV data in WPS SpreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my CSV appear to contain tabs even though the Windows list separator is a comma?

The source data may contain tab-separated fields within a single Excel cell, or the file may have been saved in a tab-delimited format. Check the data in Excel and inspect the exported file in Notepad.

How do I split tab-separated data into columns in Excel?

Select the affected column, then choose Data > Text to Columns > Delimited. Select Tab, check the preview, and click Finish.

How can I check whether Excel actually used commas?

Open the saved CSV in Notepad and inspect the separators between fields. Tabs or commas inside quoted field values may be part of the data rather than field separators.

What should I try if only one workbook exports incorrectly?

Copy its data into a new blank workbook using File > New, then save the new workbook as CSV (Comma delimited) and inspect the result in Notepad.