How to Open a CSV File on Any Device
Any CSV file opens in Excel, Google Sheets, Numbers, LibreOffice Calc, or any plain-text editor. The tricky part is avoiding encoding glitches (mojibake) and Excel's tendency to mangle long numbers and dates. This guide gives you the safest way to open a CSV on every major platform.
Windows (Excel)
Double-click usually works but can corrupt encoding. The safe way: open Excel first, then Data → From Text/CSV, pick your file, choose 65001: Unicode (UTF-8) as the file origin, and click Load. Excel keeps your accents and emoji intact this way.
Mac (Numbers or Excel)
Numbers opens CSV directly with good UTF-8 detection — just double-click. For Excel on Mac, use the same Data → Get External Data → From Text flow to control encoding.
Google Sheets
File → Import → Upload, choose the CSV, and pick Replace spreadsheet or Insert new sheet(s). Sheets auto-detects UTF-8 and the delimiter.
Text editor (VS Code, Sublime, Notepad++)
Best for inspecting structure, debugging stray quotes, or peeking at a huge file without loading it all into a spreadsheet. VS Code has a Rainbow CSV extension that color-codes columns.
Frequently asked questions
Why does Excel show garbled characters?
Excel is reading the file in a non-UTF-8 encoding. Use Data → From Text/CSV and select UTF-8.
Why does Excel turn '00123' into 123?
Excel auto-detects numbers and drops leading zeros. Import via Power Query and set the column type to Text first.