How to Open and Edit a CSV File Without Excel
A CSV file is plain text: one line per row, with a delimiter between the fields. Excel opens it, but also changes it, by dropping leading zeros, rounding long numbers, and garbling accents. Here is how to view and edit one safely.
What is inside a CSV
Each line is a row, and fields are separated by a comma. In many European locales the separator is a semicolon, and TSV files use tabs. A field that contains the delimiter, a quote, or a line break is wrapped in double quotes, and a quote inside it is doubled (""). That is the RFC 4180 convention, and it is why splitting on commas by hand breaks real files.
What Excel does to CSV data
- Leading zeros disappear: ZIP code 02134 becomes 2134, and ID 007 becomes 7.
- Long numbers such as card or account IDs are stored to only 15 significant digits and shown in scientific notation.
- Values that look like dates, such as 3-4 or MAR1, are converted to dates.
- Accented characters can be garbled if the file is UTF-8 without a byte-order mark.
View and edit it as a table
ToolkitPoint's CSV Viewer & Editor keeps every value exactly as text. It detects the delimiter, handles quoted fields, and shows the data as a table you can sort, filter, and edit. You can add or delete rows and columns, with undo. It saves as CSV (commas, semicolons, or tabs) with a UTF-8 marker, so Excel shows accents correctly. You can also save as .xlsx (values with leading zeros stay text) or JSON. The file never leaves your computer.
If you must use Excel
Do not double-click the file. Use Data > From Text/CSV, choose UTF-8, and set sensitive columns (IDs, ZIP codes, phone numbers) to Text before loading. That keeps the values exactly as they are in the file.
Primary sources and further reading
Last reviewed: September 28, 2026