Combine several Excel or CSV files into one sheet (columns matched by name) or one workbook with a tab for each.
Need to tidy the result? Use the CSV cleaner to remove duplicates and extra spaces.
“One sheet” puts all the rows under each other in a single sheet, lining up columns that have the same name, which suits monthly reports or forms with the same layout. “Separate sheets” keeps each file (and each sheet) as its own tab in one workbook.
With “One sheet”, columns are matched by their name in the first row. A column that only some files have is still included, with empty cells for the others.
Yes. Tick “Add a column with the file name” and each row says which file (and sheet) it came from.
No. The files are merged in your browser.
