CSV files are so common that people assume they need Excel. They do not. A CSV is plain text, and several free routes will open it, including the browser you already have.
Option 1: A free spreadsheet application
LibreOffice Calc and Google Sheets both import CSV well. In Google Sheets, choose File, then Import, upload the file and pick the separator type, or let it detect it. In LibreOffice, opening a .csv shows a Text Import dialog where you can choose the character set, the delimiter and the column types.
The import dialog matters. It is where you tell the program to treat a column as text so that leading zeros are kept, and to read dates in the order you expect. Skipping it by double-clicking is how data gets damaged; see CSV leading zeros and dates in Excel, which applies to other spreadsheets too.
Option 2: A text editor
Any text editor shows the raw content: Notepad, TextEdit in plain-text mode or a code editor. This is the most honest view, because nothing is reinterpreted. It is the best way to check the delimiter, whether values are quoted, and whether the file has a header. It is harder to read for wide tables, so use it to inspect rather than to analyse.
Option 3: Your browser
Docento's Text & Markdown Editor opens a CSV in the browser without uploading it:
- Open the page and choose your
.csvfile. - The contents appear in a fixed-width view.
- A status bar reports "Valid CSV" or names the first row whose number of fields differs from the header.
- Use Find to locate a value, edit a cell in place, then Download.
It shows the text, not a grid, which is exactly what you want for checking structure. For analysis or sorting, use a spreadsheet.
Option 4: A phone or tablet
On Android, the Docento app opens .csv files from the file picker, from "Open with" and via Share, and shows the text with the same syntax bar. On iPhone and iPad, the browser route above works in Safari, and Files can preview some CSVs. For analysis, the Google Sheets app can import them.
Option 5: The command line or a script
For large files, command-line tools are fastest. On any system with Python, a few lines using the csv module read the file safely, including quoted values. Utilities like head show the first rows without loading the whole file.
Check these before analysing
- Delimiter. Comma, semicolon or tab? If everything lands in one column on import, the delimiter is wrong.
- Encoding. Accented characters turning into symbols means the encoding does not match; see fixing garbled characters.
- Header row. Is the first line column names?
- Quoting. Values containing commas should be wrapped in quotes; see quoting and escaping rules.
- Consistent rows. Ragged rows mean a quoting problem or a damaged file; see how to validate a CSV file.
Very large CSV files
Spreadsheet programs have row limits. Excel's worksheet limit, for example, is 1,048,576 rows, and a CSV with more rows is cut off when opened (Excel shows a warning, but the extra rows are not loaded). Text editors that load whole files can also struggle. Browser tools such as the one above cap at 5 MB. For larger files use a scripting language, a database import or a tool designed for big data files.
Saving changes safely
If you edit a CSV in a spreadsheet, Save As CSV explicitly and check that the delimiter and encoding are what the receiving system expects. If you edit the text directly, preserve the quoting. Keep a copy of the original.
Takeaway
A CSV opens in a free spreadsheet, any text editor, your browser or a phone app. Use the import dialog to control delimiter, encoding and column types, and use a plain-text view when you need to see what is really in the file.
