Fix Missing Decimal Places in Excel 365 CSV Exports
Question details
Determine why numbers formatted with four decimal places appear to lose decimals when an Excel 365 workbook is saved as CSV.

- 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.
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.
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.
In Excel, open File > Account to check the version and build. Select Update Options > Update Now if that option is available.
Open the workbook and select File > Save As. Choose CSV UTF-8 (Comma delimited) (*.csv) as the file type, then save it.
Open the saved CSV in a plain-text editor and find the sample values. Compare the digits and decimal separator with the original workbook.
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.

Check separators and import the CSV with the correct locale
Use this method when the CSV contains decimal digits but Excel interprets or displays them incorrectly.
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.

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.




