How to Stop Excel from Truncating Decimal Places in CSV Files
Question details
Users experience loss of numerical precision when saving formatted Excel data to CSV format.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or saving a workbook containing precise decimal numbers as a CSV (Comma Separated Values) file.
- Observed behavior
- Decimal digits appear truncated or completely lost when the CSV file is reopened, as the software saves the visibly formatted number rather than the underlying raw data.
Select the cell with the truncated number and look at the formula bar at the top of the screen to verify if the underlying precision still exists in your current working file.
Preserve Original Data with Native Workbook Format and Adjust Displayed Precision
Use this method to safely back up your raw numbers and adjust the visible decimal formatting before creating a text export.
Excel's CSV export mechanism strictly relies on the formatted text visible on the screen. If a cell is visually rounded to two decimal places, saving it directly as a CSV will write only those two decimal digits to the file, permanently discarding the rest.
Click File > Save As and choose Excel Workbook (.xlsx) from the dropdown. This ensures your original values and full underlying precisions are securely preserved in a native format.
Highlight the numeric cells you intend to export. Navigate to the Home tab on the ribbon, locate the Number group, and click the 'Increase Decimal' button until the required precision is fully displayed on your screen.
Once the numbers display the correct amount of decimal digits, click File > Save As again, select 'CSV (Comma delimited)' from the file type list, and save a separate copy for your export needs.
Preserve Number Formatting with WPS Spreadsheet
WPS Spreadsheet offers precise control over cell formatting, ensuring that your data is exported exactly as you need it without unexpected decimal truncation or data loss.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your working document containing the numerical data that requires exporting.
- 2. Format the cells for precision: Select your data columns, right-click, and choose 'Format Cells'. Under the 'Number' tab, specify the exact decimal places you wish to retain for the export.
- 3. Save as CSV: Click Menu > Save As, choose 'CSV (Comma delimited) (*.csv)' from the file type drop-down, and save the file to successfully retain the configured decimal precision.
Frequently Asked Questions
Why does my CSV file look fine in Notepad but truncated when opened in Excel?
When you open a CSV in Excel, the software automatically applies general formatting rules to the incoming data, which might visually hide or round long decimal places to fit the standard column width. Notepad, however, shows the raw text data exactly as it is stored in the file without any visual formatting.
Can I recover truncated decimals from a saved CSV file?
No. If the file was saved as a CSV while the decimals were visually hidden or rounded in the spreadsheet, the extra digits are permanently lost in the text file. You must recover them from the original .xlsx workbook, provided you saved one prior to exporting.
Is there a way to force a CSV save of all decimals without changing column width or cell formatting?
Because the CSV export mechanism relies on the formatted text visible on the screen, there is no direct toggle to bypass this. You must always adjust the cell formatting to display all necessary decimals before executing the 'Save As' command for a CSV.
