Home › Excel, CSV and lists › Merge Excel or CSV files into one
Merge Excel or CSV files into one
Many Excel or CSV files into one table, columns lined up by name. Free, instant, no sign-up.
- Press Select file and pick all files (hold Ctrl, Mac: Cmd).
- Leave Extra spaces and Empty rows and columns ticked. Duplicate removal is off here.
- Choose Save as: Excel or CSV.
- Press Clean, then Download.
- Press Select file and pick all files (hold Ctrl, Mac: Cmd).
- Leave Extra spaces and Empty rows and columns ticked. Duplicate removal is off here.
- Choose Save as: Excel or CSV.
- Press Clean, then Download.
💡 Simple guide · no technical skills needed
When do I need this?
You have several Excel or CSV files with the same kind of table (one per month) and want one big table.
Good to know
- Columns are lined up by their title, so use the same titles in every file.
- Check totals after merging.
Words explained
- Excel
- A spreadsheet program (tables with rows and columns). Google Sheets and LibreOffice open the same files.
- CSV
- A very simple table file. Excel and Google Sheets open it.
Stuck? Press Help in the bottom corner and write your question in any language. You get an answer in seconds, or a real person answers you.
More free tools
Excel, CSV and lists
For Excel and lists: clean up, join, split, convert or compare them.
PDF tools
For when you have a PDF: join, cut, shrink, turn pages, or get the text and tables out of it.
Images
For photos and pictures: make them smaller, change the size or type, or copy the text in them.
Invoices, banking and VAT
For invoices, bank account numbers (IBAN), VAT numbers and bank upload files.
Websites and e-mail
For your website and e-mail: find problems and get the fix in plain words.
Products, customs and cars
For sending goods abroad (customs codes) and checking used cars.
QR codes and barcodes
Make a QR code (link, Wi-Fi, payment) or a barcode in one click.
Live rates and data
Today's numbers from official sources. Nothing to upload, just read.
Text and code tools
For text and code: count words, change capital letters, remove repeats, tidy JSON, make passwords, encode or compare text.
Calculators
For everyday sums: percent, loans, VAT, working days, dates, ages, units and time zones.
Audio and video
For your own video and sound files: get the MP3, make a GIF, cut, shrink or change the format.