Open and view CSV files online in a fast, sortable table - even huge exports with millions of rows. The delimiter, encoding and header are detected for you, and one click exports to Excel, JSON or SQL. Tab-separated data? Use the TSV Viewer, and open .xlsx workbooks in the Excel Viewer. Old dBase or FoxPro tables open in the DBF Viewer.
Something went wrong. Please try again.
Still having trouble? Please contact us and we'll be happy to help!
or paste rows
Ctrl + Enter to view · Ctrl + V anywhere
Try a sample
1M+ rows Any encoding Export to Excel No upload
ReadIndex rowsColumns
Reading file...0%
data.csv
All columns squeezed into one? The file uses another separator - pick it here and the file is re-read instantly.
Open your CSV. Drop a .csv file anywhere on the page, browse for it, paste rows from a spreadsheet, or try a sample. Gzipped .csv.gz files open too.
Check the table. The delimiter, encoding, header row and decimal comma are detected for you. A data check lists short rows, duplicates and mixed types.
Sort, filter and search. Click a column header to sort or filter it, search every row, hide or move columns, and open Row details to read one record field by field.
Export or copy. Export the whole file or the filtered view as Excel XLSX, CSV, TSV, JSON, SQL, Markdown or HTML, or copy a selection straight into a spreadsheet.
Keyboard shortcuts
Search all rowsCtrl + F
Copy the selectionCtrl + C
Select cellsShift + arrows
Jump to the edgeCtrl + arrows
Show the full valueEnter
Select everythingCtrl + A
CSV viewer features
Built for big files
A background worker indexes every row and only the visible cells are drawn, so million-row exports scroll like a short list.
Smart detection
Comma, semicolon, tab or pipe, header row, decimal comma and encoding are worked out for you - and easy to change.
Sort, filter, search
Sort numbers and dates properly, filter with >, <, =, empty or regex, and search across every column at once.
Column stats
Each column gets a type, filled and empty counts, distinct values, min, max, mean, top values and a mini histogram.
Data check
Rows with too few or too many fields are listed with line numbers, along with duplicate rows and values of the wrong type.
Row details
Read one record as a tidy list of field names and values - handy for wide tables and on phones.
Export anywhere
Excel XLSX, CSV with any delimiter or encoding, TSV, JSON, SQL INSERT statements, Markdown and HTML.
100% private
Your file is read by your browser and never uploaded. Close the tab and it is gone.
What is a CSV file?
A CSV file (comma-separated values) is a plain text file that stores a table.
Each line is one row, and commas split the row into columns.
Because it is just text, almost every app can read and write it - Excel, Google Sheets, databases, online shops, banks and analytics tools all use CSV to move data around.
Name,City,Joined
"Popescu, Ana",Bucharest,2024-05-02
Ben Carter,London,2025-01-17
The format is described in RFC 4180. These are the rules that trip people up most:
Quotes - a value that contains a comma, a quote or a line break is wrapped in double quotes, and a quote inside it is doubled ("").
Line breaks - a quoted value may span several lines, so one row is not always one line. The viewer handles this and shows both row and line numbers.
Separators - despite the name, many CSV files use semicolons, tabs or pipes. Files with tabs are often called TSV and open in the TSV Viewer as well.
No types - CSV stores text only. Numbers, dates and true/false values are a matter of interpretation, which is why the viewer detects the type of each column.
How to open a CSV file on Windows, Mac, iPhone and Android
The quickest way on any device is this page: open it, drop the file, done.
If you prefer an installed app, here is what each system offers.
Windows
Double-clicking a CSV usually opens it in Excel, which may squeeze everything into one column or strip leading zeros. In Excel, use Data > From Text/CSV to choose the delimiter and encoding yourself. Notepad shows the raw text but no table.
Mac
Select the file in Finder and press Space for a quick preview, or open it with Numbers or Excel. TextEdit shows the raw text.
iPhone and iPad
The Files app can preview a CSV, and Numbers opens it as a sheet. For sorting, filters or files too large for Numbers, open this page in Safari and tap the drop area.
Android
Most Android phones have no built-in CSV viewer. Google Sheets can import the file, or open this page in Chrome and pick the file from Downloads or Drive - nothing to install.
Chromebook
Use Google Sheets or this viewer. Both work in the browser, but this one opens much larger files and keeps the data on your device.
How to view large CSV files
Excel shows at most 1,048,576 rows per sheet.
Google Sheets stops at 10 million cells for the whole spreadsheet.
Database exports, web analytics and log dumps easily pass both limits, and text editors freeze on files of a few hundred megabytes.
This viewer reads the file in slices and stores only where each row starts. It then parses and draws just the rows you can see, so scrolling stays smooth no matter how long the file is.
Everything works on every row - search, filters, sorting, column stats and exports run in a background worker while the page stays responsive.
Compressed files - .csv.gz exports open directly. For other archives, extract the CSV with the ZIP Viewer or GZ File Opener first.
Limits - up to 2 GB per file, depending on your device's memory. Sorting handles up to 5 million rows at once; filter first for bigger files.
Common CSV problems and how to fix them
Why does my CSV file open in one column?
The program expects a different separator. Excel in many European countries writes semicolons, and other tools use tabs or pipes. This viewer detects the separator by itself, and you can override it under Options > Delimiter.
That is an encoding mix-up between UTF-8 and an older code page such as Windows-1252. Pick another encoding under Options, then export as UTF-8 with BOM so Excel reads it right next time.
Why did Excel remove leading zeros or show 1.23E+15?
Excel converts anything that looks like a number, so ZIP codes lose zeros and long IDs turn into scientific notation. The viewer shows values exactly as they are stored, and its XLSX export keeps codes with leading zeros and IDs longer than 15 digits as text.
Why are my dates mixed up?
03/04/2025 is March 4 in the US and 3 April in Europe. The viewer looks at the whole column - a value like 25/04/2025 proves day-first order - and sorts dates by their real value.
Is my CSV file corrupted?
Shifted columns usually come from a stray separator or an unclosed quote, not real damage. The data check lists every row with the wrong number of fields by line number, and warns when a quote is never closed. If the file is binary, the viewer says what it really is - an Excel workbook goes to the Excel Viewer.
How to convert a CSV file
Every export is built into the viewer, so there is nothing else to open.
Open the file, filter or tidy it if you like, then pick a format under Export.
CSV to Excel (XLSX) - numbers stay numbers, the header gets a filter, and columns are sized to fit.
CSV to JSON - an array of objects keyed by the header, with numbers and true/false typed. Explore the result in the JSON Viewer.
CSV to SQL - a CREATE TABLE statement plus batched INSERTs for MySQL, PostgreSQL, SQLite or SQL Server. Review it in the SQL Viewer.
CSV to TSV, or CSV with a semicolon, in UTF-8, UTF-8 with BOM, UTF-16 or Windows code pages.
CSV to Markdown or HTML - a ready table for README files, wikis or emails. Preview Markdown in the Markdown Viewer.
CSV vs TSV vs XLSX vs JSON
All four can hold the same table, but they suit different jobs.
Format
What it is
Good for
Watch out for
CSV
Plain text, comma-separated
Moving data between almost any apps
Separator and encoding vary, no types
TSV
Plain text, tab-separated
Data with commas in it, scientific and database dumps
Tabs inside values, fewer apps label it clearly
XLSX
Zipped Excel workbook
Formatting, formulas, several sheets
1,048,576 row limit, needs a spreadsheet app
JSON
Structured text with keys
APIs, web apps, nested data
Larger files, harder to read as a table
Need another viewer? Browse all file viewers for documents, images and archives.
Frequently Asked Questions
Drop the .csv file onto this page, click to browse, or paste rows copied from a spreadsheet. It opens right away as a table with sortable, filterable columns.
Nothing is installed and nothing is uploaded - it works on Windows, Mac, Linux, Chromebooks, iPhone and Android.
Excel stops at 1,048,576 rows, but this viewer has no row limit. It indexes the file in the background and only draws the rows on screen, so files of hundreds of megabytes with millions of rows scroll smoothly.
Sorting, filtering and search run on every row, and you can export a filtered part to XLSX.
The file uses a different separator than the program expects - often a semicolon, which European versions of Excel write by default.
This viewer detects comma, semicolon, tab and pipe automatically and also reads the sep= line Excel sometimes adds. If it still looks wrong, pick the delimiter under Options.
Open the CSV here, then choose Export > Excel XLSX. Numbers are saved as real numbers, the header row gets a filter, and column widths are set for you.
You can export everything or only the rows left after a filter or search. To check the result, open it in the Excel Viewer.
The viewer detects UTF-8, UTF-16 and older code pages such as Windows-1250, 1251 and 1252 automatically, and you can switch the encoding under Options. Export as UTF-8 with BOM and Excel will read the accents correctly.
No. The file is read by your own browser and never leaves your device, so it is safe for customer lists, bank exports and other private data. Close the tab and it is gone.
Open this page in Safari or Chrome, tap the drop area and pick the CSV from Files, Downloads, Google Drive or iCloud.
The table scrolls with your finger, and the Row details panel shows every field of a row in a readable list.
The viewer never changes your original file, but you can shape a new one.
Sort, filter, hide or reorder columns, then export the result as CSV with another delimiter or encoding, or as XLSX, JSON or SQL.