Modern Niche World MNW

CSV to Excel

Paste CSV or open a file and get an .xlsx workbook in which every cell is already a number or text, so leading zeros and long numbers survive.

Drop a CSV file here, or

CSV, TSV or TXT · up to 25 MB · or paste it below

Paste CSV or open a file, up to 25 MB. It stays on this page: nothing is sent anywhere or saved.

Up to 31 characters, without : \ / ? * [ or ].

Values

Paste CSV or choose a file, then press Make the Excel file.

Everything happens on this page, on your device: your data is never uploaded, sent or saved.

Turn CSV into an Excel workbook

Opening a CSV file in a spreadsheet app makes the app guess what each value is, and its guesses can drop the leading zero of a ZIP code, cut a long ID number to 15 digits or turn a code into a date. This tool writes an .xlsx workbook in which every cell is already a number or text, so nothing is guessed when it opens.

How to use it

  1. Paste CSV, or choose or drop a .csv, .tsv or .txt file of up to 25 MB.
  2. Name the sheet and check the options.
  3. Press Make the Excel file, and look over the preview and the notes under the summary.
  4. Download the .xlsx file.

What the options do

  • Delimiter: found for you, as the one that splits the first rows into the same number of values, or chosen: comma, semicolon, tab or pipe.
  • Find numbers: plain numbers such as 42, -3.5, 0.25 and 1e6 become numbers you can add up. Everything else stays text.
  • Keep every cell as text: nothing is changed at all, which suits codes, IDs and phone numbers.
  • Header: the first row stays text, even a heading such as 2026.
  • Widen columns: each column fits its longest value, up to 60 characters.

What stays text

Values with a leading zero (02134), a comma (1,250 or 3,5), a currency or percent sign, dates, which mean different days in different countries, and whole numbers longer than 15 digits, which Excel can’t hold exactly. Cells starting with =, +, - or @ are always text, never formulas, because a CSV file from someone else can hide formulas that run when it’s opened. A negative number such as -42 is still a number.

Good to know

  • One plain sheet: no bold, frozen or filtered header rows, and no formulas.
  • Excel’s limits apply: 1,048,576 rows, 16,384 columns and 32,767 characters in a cell.
  • Text encodings: UTF-8 and UTF-16 files are read as they are, and a file that isn’t UTF-8 is read as older Windows text (Windows-1252).
  • Nothing is uploaded: the CSV is read and the file made on your device.
  • Making JSON for code instead? CSV to JSON does that; this page makes a workbook for Excel, Google Sheets, Numbers or LibreOffice. Excel to CSV goes back the other way.

Frequently asked questions

Why make an Excel file instead of opening the CSV directly?
A spreadsheet app opening a CSV file guesses what each value is, and a guess can drop the leading zero of a ZIP code or cut a long ID number to 15 digits. In the .xlsx file this tool makes, every cell is already a number or text, so there’s nothing left to guess.
Why are some numbers kept as text?
Because turning them into numbers would change them: 02134 would lose its zero, 4111111111111111 would lose its last digit because Excel keeps 15, and 1,250 means one thousand two hundred fifty in some countries and one and a quarter in others. The tool says how many values it kept as text, and why.
Can a CSV file run formulas?
When a spreadsheet opens a CSV file, a value starting with = can run as a formula, and one written by someone else can be made to do harm, such as sending your data to a website. This tool always stores such values as text, so the workbook shows them as written and never runs them.
Is my data uploaded?
No. The CSV is read and the workbook is made in this page, on your device, and nothing is uploaded, sent or saved. Closing or reloading the page clears it.