'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Prevent Excel from Changing Decimal Points in CSV Coordinates
Question details
The user wants to prevent Excel from automatically changing long decimal coordinates into numbers with regional thousands separators, which alters the data and causes precision loss in CSV files.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening or saving CSV files containing high-precision coordinate data.
- Observed behavior
- Excel interprets coordinate strings as numbers, applies regional number formatting (like swapping periods and commas), and truncates values to 15 significant digits, leading to permanent data loss upon saving.
Always verify the raw contents of your CSV file using a plain text editor like Notepad before importing it into Excel to ensure the original coordinates haven't already been altered by previous saves.
Import CSV as Text Using the Data Tab
Bypassing the default opening method and using the import wizard allows you to format coordinate columns as text, preventing Excel from changing decimals or losing precision.
By default, double-clicking a CSV file forces Excel to interpret the data using general number formats. Importing the data gives you the opportunity to declare high-precision coordinates strictly as text before they are loaded into the workbook.
Launch Excel and open a completely new, blank workbook rather than opening your CSV file directly.
Click on the 'Data' tab in the top ribbon and select 'From Text/CSV' in the Get & Transform Data group.
Locate your CSV file and click 'Import'. In the preview window that appears, click 'Transform Data' (or 'Edit' in older versions).
In the Power Query Editor, select the column containing your coordinates. Click the Data Type icon in the column header and change it to 'Text'. Click 'Replace Current' if prompted.
Click the 'Close & Load' button in the top left corner to bring your safely formatted text coordinates into the Excel spreadsheet.
Adjust Windows Regional Number Formats
If you frequently work with US-formatted CSVs in a region like Indonesia, changing your system's decimal separator can prevent auto-conversion of coordinates.
Prefix Coordinates with an Apostrophe
Adding an apostrophe at the beginning of a coordinate forces Excel to treat the cell contents strictly as text.
Easily Import and Manage CSV Data with WPS Office
WPS Spreadsheet provides a robust and user-friendly Text Import Wizard that gives you full control over your data types, ensuring high-precision coordinates are perfectly preserved without unwanted formatting changes.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new blank spreadsheet.
- 2. Launch the Import Wizard: Click on the 'Data' tab, select 'Import Data', and choose 'Import Data' again from the drop-down menu.
- 3. Select Your File: Locate your CSV file, choose 'Delimited' in the text import wizard, and click 'Next'.
- 4. Set Column Format: Highlight your coordinate column in the Data Preview section, select 'Text' under the Column data format options, and click 'Finish'.
Frequently Asked Questions
Why does Excel truncate my coordinates to 15 digits?
Excel has a hardcoded limit of 15 significant digits for numeric values, based on the IEEE 754 standard for floating-point arithmetic. Any digits beyond 15 are automatically changed to zero unless the data is explicitly imported and stored as text.
Can I recover the lost precision if I already saved the CSV in Excel?
No. If you saved and closed the CSV file in Excel after it truncated the numbers, the lost digits are permanently overwritten with zeros. You will need to restore the data from an original backup or source file.
How do I check what the real values in my CSV are?
Right-click the CSV file, select 'Open with', and choose 'Notepad' or another plain text editor. This displays the raw, comma-separated data exactly as it is saved, bypassing Excel's automatic formatting entirely.
