1. Home
  2. Spreadsheets & Data
  3. Merge Excel & CSV Files

Merge Excel & CSV Files

Combine several Excel or CSV files into one, as one sheet or a sheet per file.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
Open several files at once and each file and sheet becomes a source. A single multi-sheet xlsx is merged sheet by sheet too. Pick how columns are matched and whether to add a source column.

Operations

Stack several files and sheets vertically. Matches columns by name and can add a source column.
Files and sheets to merge
No files added yet. Open several files at once above, or add them below.
Files are processed in your browser and never sent to a server.

How to use

  1. Drop or select the .xlsx, .csv or .tsv files to merge all at once. Each file and sheet becomes one source, and this page opens with a Merge files & sheets step already added. Even a single xlsx with several sheets is split into one source per sheet.
  2. In the step card’s Files and sheets to merge list, tick what to include or leave out, and add more files inside the card. Turn on “Include the table that is open now” to also use the first file that is currently open, separately from the list.
  3. Choose how to match columns (compared below).
  4. Set the source column, skipping repeated headers, removing duplicates after merging, and the result shape.
  5. Check the preview and the step report (Merged 2 tables → 3 rows · 3 columns) and download. A one-sheet result saves as xlsx, csv or json; the one-sheet-per-source mode saves as xlsx.

Options

Option What it does
By column name Stacks columns with the same header. Column order does not matter; columns found in only some tables are added at the end and missing cells stay blank
By position Ignores headers and stacks from the left. The first table’s header is used, and a wider table adds columns such as Col 3
Add a source column Adds a “Source” column first with the file name (and sheet), such as seoul.csv or sales.xlsx/Jan
Skip repeated headers By-position only. Drops rows equal to the first table’s header (surrounding spaces ignored, case sensitive)
Remove identical rows after merging Keeps one copy of rows whose values are all equal. The source column is not compared, so identical rows from different files count as duplicates
Result shape One sheet (default), or one sheet per source when saving as xlsx

By name vs by position

Say the Seoul branch saved date, sales and the Busan branch saved sales, date.

File Header Data
seoul.csv date, sales 10/1, 100
busan.csv sales, date 200, 10/2
  • By column name: 10/1, 100 and 10/2, 200 | Busan’s values land in the right columns.
  • By position: 10/1, 100 and 200, 10/2 | sales end up in the date column. Use by-position only when every file has exactly the same column order, or when stacking files without headers.

Tables with different columns become a union when merged by name. A name, age table (2 rows) and an age, city, name table (1 row) merge into 3 rows of name, age, city, and the step report says 2 cells left blank for missing columns.

Saving one sheet per source

With “one sheet per source” the preview still shows the merged one-sheet result, but saving as xlsx turns each source into its own sheet. Sheet names are file name sheet name (for example sales Jan), drop []:*?/\ as Excel requires, are cut to 31 characters and get (2) when they collide. In this mode the column matching and source-column settings do not touch the sheets, which keep the original data. To do the opposite and split one file into several, use Split Excel & CSV Files.

Good to know

  • Each file’s header is guessed automatically (a first row that is all text, not numbers or dates, and followed by a row with numbers or dates or with distinct names). When files without headers are mixed in, by-position plus skipping repeated headers fits best.
  • CSV files get their own encoding detection (UTF-8, CP949 and others) and values are never converted to numbers, so leading zeros survive. Legacy .xls, .ods and password-protected files cannot be opened; unreadable files are listed by name.
  • Up to 500 sources are allowed, and a merged table over 200,000 rows, 200 columns or 5 million cells is cut to the first part with a notice.
  • When merging is the first step in the pipeline you can stack dedupe, sort or date-format steps after it and save once.

Your files are processed only in your browser and are never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.