To view a CSV file without Excel changing it, open it in a plain text editor such as Notepad or TextEdit, or in a CSV viewer that shows every value as text. Both display the file exactly as saved. Excel, by contrast, guesses a type for each column, which can strip leading zeros, reorder dates and round long numbers.
Why does opening a CSV in Excel change the values?
Opening a CSV in Excel changes values because Excel converts each cell to a number, date or text as it loads, using its default settings.
Microsoft's guide to importing and exporting text and CSV files says that when you open a CSV directly, Excel applies its current default data format to each column, and gives leading zeros and date order as examples.
A worked example with made-up values. The CSV holds this line:
00412,03/04/2026,4417123456789012345,-86.40
Opened in Excel with US settings, the cells can read 412, 3/4/2026 (a date serial underneath), 4.41712E+18 and -86.4. The SKU lost its zeros. The date became a real date in month-first order, which is wrong if the file meant 3 April. The long reference was rounded, because Excel keeps only 15 significant digits, per its specifications and limits. The amount lost its trailing zero in display.
Nothing is damaged until you save. Save the CSV from Excel, though, and the changed values are what gets written.
Text editors that show a CSV file exactly as saved
A text editor is the simplest safe CSV viewer: it shows the characters in the file and nothing else. Notepad on Windows, TextEdit on a Mac (in plain text mode), and any code editor will open a CSV without changing a value. You see the commas, the quotes and the line breaks exactly as written.
The cost is readability. Columns do not line up, so a wide file is hard to scan. Code editors help: many highlight each column in its own colour or align columns with an extension. For checking a few rows, or for confirming that a zero is really there, a text editor is enough.
Text editors are also where you spot problems Excel hides, such as a stray quote, a semicolon delimiter or a byte order mark at the start of the file.
Browser previews and free CSV viewers with columns
Browser previews and free CSV viewers show the file as a grid, like a spreadsheet, while treating every value as text. That gives you columns you can scan and sort without the type guessing. Some code-hosting sites render a CSV as a table, and dedicated desktop viewers open large files quickly.
Check two things before you trust a viewer. First, look at a value with leading zeros, to confirm it is shown as text. Second, if the file contains bank or client data, prefer a viewer that runs on your computer over a website that asks you to upload the file.
| Viewer type | Keeps values exactly | Columns aligned | File stays on your computer |
|---|---|---|---|
| Text editor | Yes | No | Yes |
| Desktop CSV viewer | Usually | Yes | Yes |
| Online CSV viewer | Usually | Yes | No, it is uploaded |
| Spreadsheet with an import step | Yes, if columns are set to Text | Yes | Yes |
Files where columns are separated by spaces rather than commas are a different case; importing a fixed-width text file into Excel covers how to set the column breaks.
Can a spreadsheet app open a CSV as text columns?
Yes. A spreadsheet app shows a CSV unchanged if you import it instead of opening it, and mark the sensitive columns as Text during the import.
LibreOffice Calc shows an import dialog every time it opens a CSV, where each column's type can be set. In Excel, the Microsoft guide above says renaming the file from .csv to .txt before opening it forces the Import Text Wizard to run.
If you later save the result, the format you choose matters. Choosing between ODS and XLSX explains what each keeps when you move a sheet between LibreOffice and Excel.
Money columns are a reminder that the file format and the app both shape the numbers. If the CSV is headed for code instead, storing money amounts in JSON covers how to keep cents exact in that format.
Viewing a CSV file you must not save over by accident
Viewing a CSV you must not alter is easiest with a copy. Duplicate the file first and open the copy, so the original stays as it was received. That one habit removes the risk of an accidental save from Excel rewriting dates and codes in the only version you have.
Two more safeguards help. Mark the original as read-only in its file properties. And when a tool offers to keep the format or save as a workbook on close, choose the workbook, which leaves the CSV untouched. FastBankConvert, which is getting ready to open, is built to deliver statement data as an Excel workbook as well as CSV, so you can skip the CSV step when a spreadsheet is all you need; Get started to join the list.