Data Import & Export

Fix Missing Decimal Places in Excel 365 CSV Exports

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

Determine why numbers formatted with four decimal places appear to lose decimals when an Excel 365 workbook is saved as CSV.

Fix Missing Decimal Places in Excel 365 CSV Exports
Product
Microsoft Excel 365
Device & OS
not provided
Scenario
A user saves a workbook containing numbers formatted to four decimal places as a CSV file.
Observed behavior
The exported numbers appear to lose decimal places, possibly because of separator or regional settings.
Before you start

Identify a few sample cells and note their values and displayed decimal places in the original workbook. Check which decimal separator the intended CSV reader expects.

Solution 1Recommended

Update Excel and inspect the exported CSV

Use this method to determine whether decimal values are missing from the file or only displayed differently in Excel.

1
Check and update Excel

In Excel, open File > Account to check the version and build. Select Update Options > Update Now if that option is available.

2
Save a UTF-8 CSV

Open the workbook and select File > Save As. Choose CSV UTF-8 (Comma delimited) (*.csv) as the file type, then save it.

3
Inspect the file contents

Open the saved CSV in a plain-text editor and find the sample values. Compare the digits and decimal separator with the original workbook.

4
Identify the next step

If the digits are present in the text editor, check the import and display settings in Excel. If digits are absent, return to the original workbook, verify the source values and formatting, and test the export again.

Update Excel and inspect the exported CSV
CSV does not preserve cell formatting: A CSV stores text values rather than Excel number formats. Four displayed decimal places may need to be reapplied after import, even when the underlying value was retained.
Free Microsoft Office alternative

Work with spreadsheets and CSV files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. It supports common Microsoft Office formats and CSV files, making it easy to move existing files into a new workflow. It does not repair Excel's own export settings.

Open and work with CSV data in WPS SpreadsheetsCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether Excel removed decimals from my CSV?

Open the CSV in a plain-text editor and compare sample values with the original workbook. If the digits are present there, the issue is likely related to import or display.

Why does a CSV show fewer than four decimal places?

CSV files do not retain Excel cell formatting. If the value is intact, select the imported cells and use Format Cells > Number to display four decimal places.

Where can I check Excel's decimal separator?

Open File > Options > Advanced and review Use system separators and the decimal separator setting. The appropriate separator depends on the data and locale being used.

Does saving as CSV UTF-8 guarantee that decimal values are preserved?

No. UTF-8 specifies the file's text encoding; it does not by itself control number formatting or locale interpretation. Inspect the exported file and check the import settings.

Can I recover decimal digits that are missing from the CSV?

Changing the number format cannot restore digits that are absent from the file. Open the original workbook, verify the source values and formatting, and export a new CSV.