Pick one sheet of an .xlsx, .xls or .ods file and save it as UTF-8 CSV or TSV, ready for a database import or a script. Values are written as Excel displays them, so dates keep their format. Filter or sort first if you only need part of the rows.
How to use
- Open or drop a .csv, .tsv, .xlsx, .xls or .ods file, or paste a table copied from a spreadsheet.
- Tap a column header to sort (ascending, descending, off). Search filters rows across all columns or one column.
- Double-click a cell (or tap a selected cell) to edit. Use the chips under the grid to add or remove rows and columns, or remove duplicate rows.
- If a CSV looks wrong, change the delimiter or encoding; Windows-1251 and Shift_JIS files are detected automatically.
- Pick an export format. Exports follow what you see: current sorting and search filter apply.
- Files are read in a background worker on your device and never uploaded. The grid only draws visible cells, so 100,000+ rows scroll smoothly.
- Excel cells are shown as formatted in the workbook (dates, currency). Formulas show their last calculated value.
- Excel export keeps numbers as numbers and text with leading zeros (zip codes, IDs) as text.
- CSV downloads are UTF-8 with a BOM so Excel opens accented and non-Latin characters correctly.
How CSV files work
CSV (comma-separated values, RFC 4180) stores one record per line and separates fields with a delimiter. A field that contains the delimiter, a quote or a line break is wrapped in double quotes, and quotes inside it are doubled: "Smith, ""Jr.""". There is no single standard for the delimiter: many European versions of Excel save with semicolons because the comma is their decimal separator, and TSV uses tabs.
Encoding is the other common trap. Modern files are UTF-8, but older exports from Windows may be Windows-1252, Windows-1251 for Cyrillic or Shift_JIS for Japanese. If text shows symbols like é instead of é, the encoding was guessed wrong; pick it manually.
Opening CSV in Excel without surprises
Double-clicking a CSV in Excel converts values on the fly: leading zeros in zip codes and IDs disappear, long numbers turn into 1.23E+15 and strings like 3-4 become dates. Converting to a real .xlsx here avoids that, because text stays text and numbers stay numbers. CSV downloads include a UTF-8 byte order mark so Excel shows accents and non-Latin scripts correctly.
Limits worth knowing
An Excel worksheet holds at most 1,048,576 rows and 16,384 columns; larger CSV files have to be split or opened elsewhere. Formulas from Excel files are shown as their last calculated value, and formatting such as colors and merged cells is not kept when you export.
Frequently asked questions
How do I open a CSV file without Excel?
Drop the file on this page or tap Open. It is read in your browser and shown as a sortable, searchable table. Nothing is uploaded and no software needs to be installed.
Why does my CSV show strange characters?
The file was saved in a different encoding than the one used to read it, for example Windows-1252 read as UTF-8. Choose the right encoding in the options; Windows-1251 and Shift_JIS are detected automatically.
Why are all values in one column?
The delimiter is wrong. Files from European Excel versions often use semicolons, and TSV files use tabs. Change the delimiter and the columns split correctly.
How do I keep leading zeros when converting CSV to Excel?
Export to .xlsx here instead of opening the CSV directly in Excel. Values with leading zeros, such as 00501 or 0012, are written as text so Excel keeps them.
Can I remove duplicate rows?
Yes. Use the Remove duplicates action under the grid. Rows that match an earlier row in every column are removed, and you can undo with Ctrl+Z.
Is there a file size limit?
There is no fixed limit; it depends on your device’s memory. Files with hundreds of thousands of rows work on a typical laptop because only the visible cells are drawn.