CSV & Excel Merger
Stack CSV and Excel files into one table, with columns lined up by name.
Files
Rows are added in this order. Use the arrows to change it.
How to combine
Columns
Result
About the CSV & Excel Merger
Combine monthly reports, exports from several branches or the sheets of a workbook into one table. Rows are appended file after file, and columns are lined up by their header name — so a file whose columns are in a different order, or written customer instead of Customer, still lands in the right place. Choose all columns (a file without a column leaves it empty) or only the columns every file has, and see exactly which file lacks which column before you download.
You can add a column saying which file (and sheet) each row came from, drop rows that appear in more than one file, and save the result as CSV, TSV or Excel. Or keep each file as its own sheet of one Excel workbook. CSV files with different delimiters (comma, semicolon, tab) and encodings (UTF-8, UTF-16, Windows-1252 …) can be mixed: each file’s delimiter and encoding are detected on their own, and the file list shows what was found.
How to use it
- Add two or more CSV, TSV or Excel files (drop them together, or add more later). For workbooks, tick the sheets to include.
- Put the files in the order you want the rows with the arrows.
- Choose Append the rows into one table or Keep each file as its own sheet.
- For appending: check that the first row is a header, choose how to line up columns (by header name or by position) and whether to keep all columns or only shared ones; optionally add a source column and remove duplicates.
- Read the column report and the preview, choose CSV, TSV or Excel, and download the merged file.
Examples
jan.csv: Date, Customer, Amount feb.csv: customer, DATE, Amount, Notes
Date | Customer | Amount | Notes — Notes is empty for the January rows
With All columns and matching that ignores case and extra spaces, customer and Customer are the same column.
Branch A: Name, Phone, City Branch B: Name, Phone, Email
Name | Phone (City and Email are left out, and the report says so)
Q1.xlsx with sheets January, February, March
Source | … with values “Q1.xlsx — January”, “Q1.xlsx — February” …
Common uses
- Combining monthly or weekly sales, attendance or expense reports into one file for a pivot table.
- Putting the exports of several branches, stores or salespeople together.
- Stacking all sheets of a workbook into one list.
- Collecting several CSV files into one Excel workbook with one sheet each, to send as a single file.
How columns are lined up
- By header name (default): the first row of each file names its columns. Names match ignoring upper/lower case and extra spaces (untick to match them exactly). If a file has the same name twice, the second one matches the second one of the other files.
- By position: column A goes with column A, B with B — for files without headers, or with headers in different languages.
- All columns: every column of any file, in the order they first appear; files without a column leave it empty.
- Only those in every file: columns missing from any file are left out.
The column report lists, per file, the columns it lacks and the ones left out, so mismatches are visible before you download. Completely empty rows are skipped.
Duplicates, sources and the saved file
Remove duplicate rows drops rows that are identical, in every merged column, to an earlier row (spaces at the start and end ignored); the source column is not compared, so the same record in two files is kept once. The source column holds the file name, the sheet name or both. Excel output keeps the numbers, dates and number formats of workbook cells and turns whole numeric CSV columns into numbers (codes such as 007 stay text); the header row is bold and frozen. CSV output is UTF-8 with a byte-order mark and RFC 4180 quoting.
Limitations
- Each CSV up to 100 MB and each workbook up to 50 MB, with at most 12 million cells in total — the merge happens in your browser’s memory.
- Formulas are copied as their last saved values; cell colours, fonts and comments are not copied.
- Columns are matched by name or position only — differently named columns (Mobile and Phone) are not merged; rename them first, for example in the CSV Editor.
- More than 1,048,576 merged rows continue on a second sheet in Excel output, because that is the most rows an Excel sheet can hold.
Privacy
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
How do I combine several CSV files into one?
Add all the files, keep Append the rows into one table, check the column report and download. The header is written once and the rows of every file follow, in the order of the list.
What if the files have different columns?
With All columns, every column appears and files without it leave it empty; with Only those in every file, the extra columns are left out. The report tells you which file is missing what.
Can I merge all the sheets of an Excel workbook?
Yes. Add the workbook and tick the sheets you want (hidden and empty sheets start unticked); each sheet is appended like a separate file. Tick Add a column saying where each row came from to keep the sheet name.
Can I put several CSV files into one Excel file with separate sheets?
Yes — choose Keep each file as its own sheet (Excel). Each file becomes a sheet named after it.
Do my files get uploaded?
No. All files are read and merged in your browser, and the merged file is created on your device.