excel text import wizard default settings

Changing Regional Setting in Windows CSV imports Close the Excel application. Things I have tried that did not work well.Ĭlick on the WindowsStart button. The standard field delimiters for CSV files are commas On American Windows versions the comma is set as default for the List Separator which is okay for CSV files. I need to export an Excel file as CSV to import into a database. Note that the currency separator can also be changed in the setting. Open the dialog box for changing Regional and Language settings.Ĭhange excel delimiter to. Change the Decimal separator from a full stop to a. In the Region dialog on the Format tab click Additional settings.Īfter I changed it to a comma all my CSVs open correctly with Excel 2013. By default when saving a CSV file in Excel each column will be separated using a comma as the delimiter hence the name Comma Separated Values CSV.Įasy alternatives that were under your nose in the Save As window are. Select Delimited then make sure the File Origin is Unicode UTF-8. Opening Excel Files With The Correct Csv List Separator Harvest Media In the Save as type box choose to save your Excel file as CSV Comma delimited.Įxcel csv delimiter settings. Mine was set to semi-colon for South Africa after I changed to Windows 8.

Click the Open link and browse to the CSV if it is for the NPA – it may be delimited already file you want to save in pipedelimited format.

Excel text import wizard default settings