How to Open a CSV File
A .csv file is plain-text tabular data — rows and columns separated by a delimiter, with no formulas or formatting. It's the universal format for moving data between spreadsheets, databases and apps. Here's how to open one properly, and how to fix the most common problem: the wrong delimiter.
Open a CSV File Online
Drop a .csv file below. It's parsed as a real table right in your browser — the tool auto-detects whether it actually uses commas, semicolons, tabs or pipes as the delimiter (a very common source of "everything's in one column" problems in Excel), and flags any row whose column count doesn't match the rest.
🔒 Nothing is uploaded — your file never leaves this deviceOn this page
What is a CSV file?
CSV stands for Comma-Separated Values. It's plain text: each line is one row, and within a row, fields are separated by a delimiter — usually a comma, though semicolons and tabs are also extremely common depending on the exporting program's locale settings. There's no formatting, no formulas, no multiple sheets — just the raw data, which is exactly why it's the most universal format for moving tabular data between completely different programs, databases and programming languages.
The closest thing to an official standard is RFC 4180, which defines how fields containing the delimiter, quotes, or line breaks should be wrapped in double quotes. In practice, real-world CSV files vary a lot in how strictly they follow it — which is exactly what trips up naive parsers, and what this page's tool is built to handle correctly.
How to open a CSV file on Windows
- Double-click it — it opens in Excel by default on most Windows installs.
- If it looks garbled or crammed into one column, don't fight Excel's import settings — use the tool on this page instead, which detects the real delimiter automatically.
- To open it as plain text instead, right-click → Open with → Notepad (or any text editor).
How to open a CSV file on Mac & online
- Mac: Double-click the file — it opens in Numbers by default, or Excel if installed.
- Google Sheets: File → Import, or just drag the file into sheets.google.com.
- Any platform: the tool on this page works identically everywhere a modern browser runs, with no spreadsheet software required at all.
The "everything's in one column" problem
This is, by far, the single most common CSV complaint. It happens because "comma-separated" is really more of a convention than a strict rule: many programs — especially ones set to a European locale, where a comma is the decimal separator for numbers — export CSV files using a semicolon instead. Excel then opens the file using whatever delimiter your system's regional settings expect, and if that guess is wrong, every field lands in a single column.
The fix isn't to re-export the file differently — it's to tell your spreadsheet program (or, more reliably, use the tool on this page) what the real delimiter actually is. This page's tool tests the comma, semicolon, tab and pipe against the file's own first several lines and picks whichever one produces a consistent column count, then reports exactly which one it found.
Common CSV file problems and how to fix them
Numbers turn into dates (e.g. "1-2" becomes "Jan-2")
This is Excel's autocorrect "helpfully" reinterpreting a value on import. It happens at the spreadsheet-app level, not in the file itself — the tool on this page shows every value exactly as stored in the raw file, unaltered.
Special characters look like garbage (mojibake)
This means the file's character encoding doesn't match what's opening it — commonly a UTF-8 file opened as if it were a different encoding, or vice versa. Re-save or re-export as UTF-8 if you control the source.
Some rows have more or fewer columns than others
Almost always a text field containing the delimiter character without being wrapped in quotes, per RFC 4180. The tool on this page flags exactly how many rows are affected so you can find and fix them.
Technical references
CSV's closest thing to a formal specification is an IETF informational RFC, documenting the format most real-world implementations converged on.
- RFC 4180 — Common Format and MIME Type for Comma-Separated Values (CSV) Files — The IETF specification this tool's quoting and escaping rules follow.
Frequently asked questions
What program opens a .csv file?
On Windows and Mac, CSV files usually open automatically in Excel, Google Sheets or Numbers, since "CSV" just means comma-separated plain text — any spreadsheet program understands it. Any plain-text editor (Notepad, TextEdit, VS Code) also opens it, showing the raw comma-separated text. This page's tool opens it as a real table directly in your browser, with no spreadsheet software needed.
Why does my CSV look wrong in Excel, with everything crammed into one column?
This almost always means the file actually uses a different delimiter than a comma — commonly a semicolon, which is standard for CSV exports from many European locales (where a comma is the decimal separator). Excel guesses based on your system's regional settings, and guesses wrong. This page's tool detects the real delimiter automatically and shows you which one it is.
What's the difference between CSV and Excel (XLSX)?
CSV is plain text — just the raw data, with no formulas, formatting, multiple sheets, or charts. XLSX is a full binary/ZIP-based spreadsheet format that can hold all of that. CSV's simplicity is exactly why it's the universal format for moving data between completely different programs and databases.
How do I fix a CSV file with broken rows?
The most common cause is a text field containing the delimiter character (like a comma inside an address) without being wrapped in double quotes, per the CSV standard (RFC 4180). This page's tool flags exactly which rows have an inconsistent column count so you can find and fix the offending line in a text editor.
Last updated September 23, 2026.