Open a CSV in Excel Without Fighting the Import Wizard

Double-clicking a CSV often dumps everything into column A. A real .xlsx file opens like a normal workbook.

Try the tool →

CSV is a text file that pretends to be a spreadsheet. Excel can open it, but on many PCs a double-click treats the whole row as one cell, or splits on the wrong character if your region uses semicolons.

CSV to Excel reads a comma-separated file and writes a proper .xlsx. Open that in Excel or Google Sheets and the columns are already there. No import wizard, no “Text to Columns” after the fact.

What it expects

Commas between fields. Quotes around a field that itself contains a comma. Tab-separated exports from some science tools will not auto-detect here. Save or export as CSV with commas first.

First 10,000 rows, 10 MB. That covers most exports from a form or a small database dump. A million-row warehouse extract belongs in desktop Excel or a real database, not a browser tab.

Going the other way

Excel to CSV takes the first sheet of an .xlsx and writes a CSV. Charts, extra sheets, and macros are dropped. Formulas become the calculated values when the library can see them. If you still have an old .xls, save it as .xlsx first.

Both conversions upload the file, build the download, and discard the copy. Do not send a sheet you would not attach to an email.

Related reads

FAQs

Why is everything still in one column?
The source is probably not comma-separated. Open it in a text editor. If you see tabs or semicolons, convert or replace those before you upload.
Are dates kept as dates?
They are stored as they appear in the CSV. Excel may treat some of them as text. Format the column after you open the workbook if you need real date cells.
Can I convert several sheets at once?
No. Excel to CSV exports sheet one only. Copy other sheets into their own workbooks, or export them one at a time.

← Back to Blog