Fix CSV Decimal and Number Import Errors in Excel
Question details
The user needs to import CSV numbers into Excel without converting them to text or interpreting decimals incorrectly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or importing a CSV file containing numeric values and decimal separators.
- Observed behavior
- Imported numbers may appear as text, have incorrect decimal values, or produce errors.
Open the CSV in a text editor and check which characters separate fields and decimals. The user's system uses a period as the decimal separator, so compare that setting with the values in the file before changing it.
Import CSV numbers with the correct locale in Power Query
Use Power Query to set the field delimiter and interpret numeric columns according to the CSV's decimal format.
In Excel, select Data > From Text/CSV, choose the CSV file, and select Import.
In the import preview, choose the delimiter that separates the CSV fields, then select Transform Data.
In Power Query, check Applied Steps for an automatic Changed Type step. Select its X to remove it if it converted the numbers incorrectly.
Right-click the numeric column header and select Change Type > Using Locale. Choose Decimal Number and a locale that matches the decimal separator in the CSV, then select OK.
Check the column preview for correct values, then select Home > Close & Load to import the data into Excel.
Check the system decimal separator before importing
Compare the operating system's decimal separator with the CSV format when imports depend on regional settings.
Open and Review CSV Data with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open CSV files and work with Excel-compatible spreadsheets for an easier transition from Microsoft Office.

Frequently Asked Questions
Why are CSV numbers appearing as text in Excel?
Excel may interpret the column as text when its values use a decimal separator that does not match the import locale. Use Data > From Text/CSV, select Transform Data, and set the column type with Change Type > Using Locale.
How do I import a CSV that uses commas for decimals?
Choose the correct field delimiter under Data > From Text/CSV, then select Transform Data. In Power Query, right-click the numeric column and choose Change Type > Using Locale, Decimal Number, and a locale that uses commas for decimals.
Is the CSV delimiter the same as the decimal separator?
No. The delimiter separates fields, while the decimal separator appears within a number. Check both in a text editor and choose the field delimiter in Excel's CSV import preview.
Why did my Excel number formatting disappear after saving as CSV?
CSV stores plain text values rather than Excel formatting. After importing the file, select the cells and apply a number format from Home > Number.




