Fix Excel CSV Files Saving with Tabs Instead of Commas
Question details
The user needs Excel to save data as a comma-delimited CSV rather than a tab-delimited file.

- 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.
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.
Split tab-delimited data and save it as CSV
Use this method when tab-separated source data appears together in one Excel column.
Open the file in Excel and select the column containing the tab-separated 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.
Click Next, choose an empty destination if necessary, and click Finish to place the fields in separate columns.
Choose File > Save As, select CSV (Comma delimited) as the file type, and save the active sheet.
Open the saved CSV in Notepad and confirm that commas separate the fields.

Test the export from a new Excel workbook
Use a new workbook to check whether the issue is limited to a particular source workbook or its data.
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.

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.




