Open a CSV file and turn it into Excel
Drop in a CSV file, or paste one, to see it as a table you can search and sort, then download it as an Excel file. Zip codes keep their leading zeros and long ID numbers keep every digit. It turns Excel into CSV too. The file is opened by your browser and is never uploaded.
Drop a file here
CSV, tab-separated text, Excel (.xlsx or older .xls) or JSON. The kind of file is worked out from what is inside it, so a wrong file ending does not matter.
What it reads
- CSV split by commas, semicolons, tabs or pipes, found for you
- Excel .xlsx and older .xls, with a choice of sheet when there are several
- JSON: a list of records, a record holding a list, a list of lists, or one record per line
Your file is opened by your browser and is never uploaded. This is a plain converter. No AI is involved and nothing is guessed.
What happens to your data
Every download holds the whole file, not only the rows shown here. Values are written exactly as they appear, so zip codes such as 02134 and long numbers such as 16-digit references keep every digit, and dates stay as written. With the numbers box ticked, plain amounts become numbers Excel can add up, while values with leading zeros or more than 15 digits stay as text.
In CSV and tab-separated downloads, a cell that starts with =, +, - or @ and is not a plain number gets an apostrophe in front, so a spreadsheet shows it as text and does not run it as a formula.
Moving the same export between two systems every week?
I connect the two systems read-only and send one page each morning with the numbers you were pulling out by hand. A free 30-minute look shows what your systems could answer today.
What a CSV file is
A CSV file is a table saved as plain text. Each line is one row, and commas separate the cells, so a row might read 10041,02134,12. CSV stands for comma-separated values. Almost every system can export one, which is why it is the usual way to move data from one program to another.
Some systems use semicolons, tabs or the | character in place of commas. This page works out which one your file uses.
Why Excel loses leading zeros and long numbers
When Excel opens a CSV file, it guesses what each cell is. Anything that looks like a number becomes a number. A zip code like 02134 becomes 2134, and a part number like 000417 becomes 417. Excel also keeps only 15 digits of any number, so a 16-digit card or order reference such as 4000123412341234 is shown as 4.00012E+15 and its last digit turns into a zero for good. Some codes get turned into dates as well.
This page does not let Excel guess. It writes every cell into the Excel file as text, exactly as it appeared in your CSV. If you want amounts that Excel can add up, tick "Turn number-looking text into real numbers". Even then, values with leading zeros or more than 15 digits stay as text.
How to turn Excel into CSV
Drop the .xlsx file in, pick the sheet if it has more than one, choose CSV under "Download as" and press Download. Cells come out as Excel shows them, so dates and zip codes with a number format keep their look.
Need to check two exports against each other? Use compare two lists.
Questions
Is my file uploaded?
No. Your browser opens the file and does the converting. Nothing is sent anywhere, and nothing is kept after you close the page.
How big a file can it open?
In a test on a fast desktop computer in Chrome, a 100,000-row CSV file (8 MB) opened in under a second and became an Excel file in about a second and a half. A 500,000-row file (44 MB) took about 10 seconds to become Excel and about a second to become CSV or JSON. An older laptop will be slower. The table shows the first 200 rows, but every download holds the whole file. Excel itself holds at most 1,048,576 rows, so larger files can only come out as CSV, JSON or tab-separated text.
Why do some cells in my CSV start with an apostrophe?
A cell that starts with =, +, - or @ can be run as a formula when a spreadsheet opens the file, which is a known way to slip harmful commands into a CSV. The apostrophe makes the spreadsheet show it as plain text. Plain numbers such as -12.50 are left alone.
My file uses semicolons. Will it work?
Yes. Some systems use semicolons, often where decimals are written with a comma. The page looks at the first rows and picks commas, semicolons, tabs or pipes, whichever splits them into the same number of columns.
Is this AI?
No. It is a plain converter. It reads the file, shows it as a table and writes it out in another format, the same way every time.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools, with compare two lists and the aging report.