Skip to content
English
All tools

Categories

Developer ToolsEncoding & DecodingJSON & DataHash & ChecksumText ToolsDate & TimeNetwork ToolsFile ToolsMarkdown & Diagrams

Excel Merger

Drop several workbooks or CSV files and get a single .xlsx, with the rows appended together or every sheet kept side by side.

Processed locally in your browser

Options

Max 31 characters, without [ ] : * ? / \

What is Excel Merger?

Combining monthly reports, exports from several branches or a folder of CSV extracts usually means copy-pasting sheet after sheet. This tool reads all the files you choose (.xlsx, .xls, .xlsm, .ods and .csv) and writes one clean .xlsx workbook, without opening Excel.

Four modes cover the common cases: append the rows of sheets that share the same name, append the rows of sheets in the same position, append everything into a single sheet, or keep each file or sheet as its own sheet. With a header row, columns are matched by name so files with reordered or extra columns still line up, and only one header is kept. Sheet names are cleaned to Excel’s 31-character rules and made unique, and numbers, dates and text keep their types.

How does it work?

  1. Drop or select two or more files; the order you pick is the order of the rows.
  2. Choose how to merge: same sheet name, same sheet position, everything into one sheet, or one sheet per file/sheet.
  3. Tick whether the first row is a header (columns are then aligned by name), and optionally add a source_file column or include hidden sheets.
  4. Click merge, check the preview and summary, then download merged.xlsx.

Common use cases

  • Consolidating twelve monthly sales workbooks that all have the same columns into one yearly sheet.
  • Combining regional exports where some files have extra columns or a different column order.
  • Bundling several CSV extracts into one workbook with a tab per file for a colleague.
  • Keeping track of where each row came from by adding a source_file column before analysis.

Examples

Drop several workbooks or CSV files and get a single .xlsx, with the rows appended together or every sheet kept side by side.

Privacy

Excel Merger runs entirely in your browser. The text or files you provide are processed on your device and are not uploaded, logged or stored on our servers.

Limitations

Only values and number formats are copied: formulas become their last calculated value, and styles, charts, images, merged cells and macros are dropped. Files are limited to 50 MB each, and the result to Excel’s 1,048,576 rows.

Frequently asked questions

What happens if the files do not have the same columns?

With "first row is a header" on, columns are matched by header name. A column that exists only in some files is added at the end and left blank for the others, and the tool tells you how many such columns there were. With it off, rows are appended by position.

Which mode should I use for workbooks with several sheets?

Use "same sheet name" when every file has Jan, Feb… sheets that should be stacked by name, "same position" when the sheets are named differently but ordered the same way, and "one sheet per file/sheet" when you just want everything in one workbook without combining rows.

Are my files uploaded anywhere?

No. The workbooks are read and written in your browser with a local spreadsheet library, formulas and macros are never executed, and nothing leaves your device.

Related tools

More tools in JSON & Data →