CSV to Excel converter
Turn a CSV file into an Excel spreadsheet. Leading zeros and long IDs stay as they are, and your file never leaves your browser.
Excel
Google SheetsDrop a CSV file here
CSV, TSV or TXT, up to 100 MB. It stays on your computer.
- No sign-up
- Nothing uploaded
- Leading zeros kept
A spreadsheet that keeps what your CSV says.
Your file stays on your computer
The Excel file is built in your browser. Nothing is sent to Mammoth or anyone else.
Leading zeros and long IDs stay
Opening a CSV in Excel turns 02134 into 2134 and a 20-digit reference into 4.01122E+19. Here they stay as text.
Commas and line breaks stay in their cell
A value in quotes can hold a comma or a line break, and it still lands in one cell.
How to convert CSV to Excel
The first line gives the column names and the separator is found for you. Each column is typed once, as numbers, dates or text.
- 1
Add your CSV
Drop a .csv file on the box, choose one, or paste the CSV in.
- 2
Check the table
A preview shows the rows and columns the Excel file will have.
- 3
Download
Save the .xlsx, with the header row in bold and frozen.
Other ways to do it
Excel opens CSV files itself. The catch is what it changes on the way in.
Double-click the CSV
A quick look at the data
- Keeps leading zerosNo
- Keeps long IDs wholeNo
- No settings to chooseYes
- Refreshes when the file changesNo
Excel's From Text/CSV
A file you refresh often
- Keeps leading zerosPartly
- Keeps long IDs wholePartly
- No settings to chooseNo
- Refreshes when the file changesYes
- This page
This converter
A clean .xlsx in one step
- Keeps leading zerosYes
- Keeps long IDs wholeYes
- No settings to chooseYes
- Refreshes when the file changesNo
How to import a CSV into Excel without losing leading zeros
Double-clicking a CSV lets Excel guess every value. Importing it through Data > From Text/CSV lets you choose instead.
Need it the other way round? The Excel to CSV converter saves any sheet, or every sheet, as a CSV.
- 1
Open a blank workbook and go to Data > From Text/CSV.
- 2
Pick your CSV file and select Import. A preview shows the columns Excel found.
- 3
Check that File Origin is 65001: Unicode (UTF-8), so accents come through.
- 4
If a column holds codes with leading zeros, set Data Type Detection to Do not detect data types. Every column then loads as text.
- 5
Select Load to put the data on a new sheet.
Your file stays private
The converter runs inside this page. Your CSV is read and turned into a spreadsheet on your computer, and nothing is sent to Mammoth. That makes it safe for exports with customer or payroll data in them.
Once the page has loaded, it works with your internet switched off.
Getting the same CSV export every week?
Mammoth can take it from there. Put each week's CSV in a folder and the rows are added to one table, ready to download as Excel.
Weekly exports
Drive
DropboxOneDrive
SFTP| Week 43 | Oct 21 | Ana Costa | 129.50 | |
| Week 43 | Oct 23 | Ben Ellis | 48.00 | |
| Week 44 | Oct 28 | Dev Patel | 75.90 | |
| Week 45 | Nov 04 | Chloé Martin | 310.25 | |
| Week 45 | Nov 06 | O'Neill & Co | 1,200.00 |
Illustration. Every new file in the folder is added to the same table.