CleanCSV

Combine Multiple Excel Sheets into One

Stack every tab of a workbook, or of several workbooks, into a single sheet with a column showing where each row came from.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

Combine Excel sheets

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your Excel workbook here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Upload an .xlsx, .xls or .ods workbook. Every sheet with data is read; empty sheets are skipped.

  2. 2

    Combine all is selected. Rows from each sheet are stacked and columns are matched by header name.

  3. 3

    The Source column holds each row's sheet name. Untick it if you do not need it, or click a single sheet to export it alone.

  4. 4

    Download as Excel (.xlsx) or CSV.

No macros, no copy and paste

The usual ways to do this in Excel are Power Query, a VBA macro or copying each sheet by hand. Here you just upload the workbook. It works the same on Windows, Mac and Chromebooks, and the file never leaves your computer.

Sheets with different layouts

Columns do not need to be in the same order on every sheet. Matching is by header name, and a column that only exists on some sheets is kept with blanks elsewhere. If a sheet has a title above its header row, the header is detected automatically.

What is read from each cell

Values are read the way Excel shows them: formulas come through as their results, dates as YYYY-MM-DD and formatted numbers such as zip codes keep their leading zeros. Formatting, colours, charts and comments are not carried over.

Frequently asked questions

Are hidden sheets included?

Yes, every sheet with data is included. Click a single sheet in the list to work with it alone.

Can I combine sheets from several workbooks?

Yes. Upload several files at once and every sheet from every workbook is combined.

Will formulas still work?

The combined sheet contains the calculated values, not the formulas.