What this converter can do
| Option | Works with | You get |
|---|---|---|
| To CSV | XLSX, XLSM, XLSB, XLS, ODS | One CSV file for each sheet with data |
| To Excel | CSV, TSV, TXT, XLS, XLSB, ODS | An XLSX file |
| Compress | XLSX, XLSM | A smaller copy, when one is possible |
How to use it
- Choose an option.
- Add your file. Tap the upload area or drop it there.
- Press Convert, then download your new file. Your original isn’t changed.
What each conversion keeps
- To CSV: a CSV holds plain values only, as they’re shown in the sheet. Formulas, formatting and pictures aren’t included.
- To Excel from CSV: plain numbers become numbers. Values like the ZIP code 01234 and very long IDs stay as text, so no digits are lost. Dates stay as you typed them, and nothing is run as a formula.
- To Excel from older files: your values are kept, and formulas are kept when the file holds them, but formatting, charts and pictures may be lost, so check the result.
How much can I compress an Excel file?
Often not much. An XLSX file is already a compressed ZIP inside, so packing it again usually saves only a little. This tool doesn’t change your cells or shrink your pictures, and if it can’t beat your original, it says so and gives you the same file back.
To make a large workbook smaller, try opening it in Excel and compressing its pictures, removing unused sheets, or saving it as .xlsb.
Limits
- Files can be up to 100 MB. Very large files may be slow on a phone.
- Password-protected files can’t be opened. Remove the password in Excel first.
Is it private?
Yes. Everything runs inside your browser, and your spreadsheets are never sent to our servers.
Which Excel converter option fits your file
Spreadsheet files come in several formats, and each option of this Excel converter suits some of them better than others.
| Format | What it is | Option to use |
|---|---|---|
| .xlsx | Excel’s standard XML-based workbook | To CSV or Compress |
| .xlsm | A workbook that can hold macros | To CSV or Compress |
| .xlsb | Excel’s binary workbook | To CSV or To Excel |
| .xls | The older Excel 97 to 2003 format | To CSV or To Excel |
| .ods | OpenDocument spreadsheet | To CSV or To Excel |
| .csv, .tsv, .txt | Plain text tables | To Excel |
Microsoft describes .xlsx as the default XML-based file format and .xlsb as a binary format.[1] It also says an .xlsx file can’t store VBA macro code, while .xlsm can.[1] So if an old .xls file holds macros, the new .xlsx won’t keep them. For OpenDocument files, Microsoft notes that formatting might be lost when saving and opening .ods files.[1]
Example: a workbook with several sheets to CSV
Say Budget.xlsx has three sheets: Jan, Feb and an empty one called Notes. Choose To CSV and press Convert. You get two files, Budget-Jan.csv and Budget-Feb.csv. The empty sheet is skipped. If only one sheet has data, the file is simply called Budget.csv. Characters that can’t go in a file name, such as a slash in a sheet name, are replaced with a hyphen.
This saves you work. When you save a workbook as CSV in Excel itself, only the current worksheet is saved to the new file, so you would repeat Save As for each sheet.[3]
How numbers are read from a CSV
When you turn a CSV into Excel, a cell becomes a number only when it is plainly one, such as 42, -7 or 3.25. Everything else stays as text:
- Numbers that start with a zero, such as 01234.
- Numbers with thousands separators or a currency sign, such as 1,250 or $40.
- Numbers with 16 or more digits before the decimal point, such as card or account IDs.
- Anything that looks like a date or a formula.
This is on purpose, so no digits change. If you need a text column as numbers, select it in Excel and convert it there. Opening a CSV straight in Excel works differently: Microsoft’s guide shows how to import a column of numbers with leading zeros as text so the zeros are kept.[3]
Excel limits to keep in mind
An Excel worksheet holds at most 1,048,576 rows by 16,384 columns, and one cell can hold up to 32,767 characters.[2] A CSV exported from a database can be longer than that. If yours is, split it into smaller files before you turn it into Excel, or Excel won’t be able to show every row on one sheet.
Common mistakes
- Choosing Compress for an .xls or .ods file. Compress only works with .xlsx and .xlsm. Use To Excel first.
- Expecting formulas in a CSV. A CSV holds values only, so keep the original workbook too.
- Adding a locked file. Password-protected workbooks can’t be read. Remove the password in Excel first.
- Adding several files at once. The converter takes one file at a time. To combine files, use merge Excel files.
To turn a sheet into a PDF instead, use Excel to PDF.
How this tool works
Your spreadsheet is read and converted in your browser with the SheetJS library. It is not uploaded. You can add one file at a time, up to 100 MB. XLSX, XLSM, XLSB, XLS, ODS, CSV, TSV and TXT files are accepted.
- To CSV: every sheet that has data becomes its own CSV file. A byte order mark is added so Excel reads accented letters correctly.
- To XLSX: the workbook is read and written again as a modern .xlsx file with compression.
- Compress: an .xlsx or .xlsm file is a ZIP inside. Its parts are repacked at the strongest ZIP level. Cells and pictures do not change. If the repacked file is not smaller, you get the original back.
Password-protected files cannot be read, and the tool says so.
What next
Use this often? Add Excel Conver to your Home screen.
Frequently asked questions
How do I convert Excel to CSV?
Choose To CSV, add your file and press Convert. You’ll get one CSV file for each sheet that has data.
How do I compress an Excel file online?
Choose Compress, add your XLSX file and press Convert. Excel files are already compressed, so the saving is often small.
Will my ZIP codes keep their leading zeros?
Yes, when you convert CSV to Excel here. Values like 01234 stay as text, so the zero isn’t lost.
Are my files uploaded?
No. Everything runs in your browser, so your spreadsheets stay on your device.
Does converting XLS to XLSX keep macros?
No. An .xlsx file can’t store VBA macro code, so macros in the old file are not carried over. Your values are kept, and formulas are kept when the file holds them.
Why is my empty sheet missing from the CSV files?
To CSV makes one file for each sheet that has data. A sheet with no data is skipped, and if no sheet has data, the tool tells you the file has nothing to convert.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.