Combine Excel Sheets Into One
Stack every sheet of a workbook into a single table.
Drop an Excel file here
or browse your computer
.xlsx, .xls · Free, up to 10MB and the first 50,000 rows.
By uploading you agree to our Terms and Privacy Policy. Files are deleted automatically.
Free, with no account, up to 10MB. The free version processes up to 50,000 rows: in a longer file it takes the first 50,000, and that is what you download.
How it works
- 1Upload a workbook with several sheets.
- 2Choose which ones to combine. We line them up by column heading, not by position.
- 3Download one table, with a column saying which sheet each row came from.
When people use this
- —A workbook with one sheet per month
- —One sheet per region, salesperson or product line
- —A template someone filled in as twelve separate tabs
Supported formats
This tool accepts .xlsx, .xls. Free, up to 10MB and the first 50,000 rows. We work out the encoding and the separator from the file itself, so a semicolon-separated export or one saved in a non-UTF-8 encoding opens correctly rather than as a single column of nonsense.
Questions
- What if the sheets have slightly different columns?
- We match the ones that mean the same thing and keep the ones that only appear on some sheets, leaving the other rows blank there. Nothing is dropped.
- What happens to my file?
- It is uploaded over an encrypted connection, processed, and deleted automatically - within 24 hours for anonymous use. We never use anyone’s spreadsheet data to train models. You can delete a job and its files at any time from the job page.
Need the combined data cleaned up as well?
The full app handles jobs that need several steps across several files, and can save the whole thing so next month takes two clicks.
Continue cleaning