excel

Edit CSV files without Excel changing them

Excel is a spreadsheet. When it opens a CSV file, it reads each value as it sees fit, and when you save, it writes back what it made of them. Here is what changes, how to keep it from happening in Excel, and how Trusty CSV keeps the file as it is.

what changes

What a CSV goes through in Excel

The same file, opened in Excel with its default settings and saved, and opened in Trusty CSV and saved.

orders.csv, opened in Excel and saved
idzipskuorderedtracking
4280012-Sep3/4/20269.40011E+21
43280131-Dec3/5/20269.40011E+21
orders.csv, opened in Trusty CSV and saved
idzipskuorderedtracking
004208001SEPT22026-03-049400111202555842332669
004328013DEC12026-03-059400111202555842332676
  • Codes lose their leading zeros. An id of 0042 becomes 42, a postcode of 08001 becomes 8001.
  • Long numbers keep 15 digits. Excel’s numbers have 15 digits of precision: a 22-digit tracking number becomes 9.40011E+21, and the digits past the 15th are zeros. Two different numbers end up the same.
  • Codes that look like dates become dates. SEPT2 becomes 2 September. Spreadsheets did this to so many gene names that in 2020 the committee that names human genes renamed 27 of them: SEPT1 is now SEPTIN1, MARCH1 is MARCHF1.
  • Dates are written your computer’s way. 2026-03-04 is a date to Excel, and goes back into the file as your computer writes dates, 3/4/2026 on a computer set to the United States.
  • Accents can come out garbled. Microsoft’s advice is that a UTF-8 CSV opens correctly if it was saved with a byte order mark, and otherwise should be imported with From Text/CSV. Opened with a double-click, a file without one can show Málaga as Málaga.
  • The delimiter follows the region. Where the decimal separator is a comma, Excel uses semicolons, so the file you save in Madrid may not open the same way in Chicago.

Save the file, and these changes are in it for good.

in excel

How to stop it in Excel

Excel for Microsoft 365 and Excel 2024 have Automatic Data Conversion options (on Windows, in File › Options › Data) that turn off four of these: removing leading zeros, keeping 15 digits in scientific notation, reading the digits around an E as a number, and turning letters and numbers into a date.

In any version, Data › From Text/CSV imports a file with the encoding you choose and lets you set a column’s type to Text, so that it stays as written.

Both work on the computer where they’re set, and each time someone remembers to use them.

trusty csv

How Trusty CSV keeps the file

Trusty CSV opens a CSV as what it is, text. Each column gets its colour and lines up on screen, but nothing in the file is converted: 0042 stays 0042, and a date stays written the way it was.

Saving writes back the same delimiter, quotes, encoding and line breaks. If you fix one value, the file changes by one value.

Cells copied in Excel paste into a CSV as rows, with the file’s delimiter and each value as Excel copied it. When Excel is where the data has to go, Trusty CSV saves a new .xlsx workbook in which numbers are numbers and codes like 00123 stay text.

If a file has been through Excel already, Quality Check finds codes that lost their leading zeros, numbers a spreadsheet rounded and text with a broken encoding. And if Excel saves over a file you have open in Chrome or Edge, Trusty CSV asks before loading the new version, and Compare shows what changed.

when

When Excel is the better choice

When the data is going to become a workbook: formulas, charts, pivot tables, formatting, a file you share with people who work in Excel. Trusty CSV opens .xlsx, .xls and .ods workbooks sheet by sheet, but it edits tables of values, not spreadsheets.

Sources, read on 12 November 2026: