Data Import & Export

Fix CSV Decimal and Number Import Errors in Excel

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

The user needs to import CSV numbers into Excel without converting them to text or interpreting decimals incorrectly.

Fix CSV Decimal and Number Import Errors in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Start the import

In Excel, select Data > From Text/CSV, choose the CSV file, and select Import.

2
Check the delimiter

In the import preview, choose the delimiter that separates the CSV fields, then select Transform Data.

3
Remove an incorrect type change

In Power Query, check Applied Steps for an automatic Changed Type step. Select its X to remove it if it converted the numbers incorrectly.

4
Set the numeric locale

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.

5
Load the results

Check the column preview for correct values, then select Home > Close & Load to import the data into Excel.

CSV formatting: CSV files store plain text values, not Excel number formatting. Apply the desired number format in Excel after importing.
Free Microsoft Office alternative

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.

Open and review CSV data in WPS SpreadsheetsCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for Microsoft Office usersFree and lightweight office suite
microsoft office alternative - wps 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.