Gabungkan beberapa file Excel atau CSV menjadi satu sheet (kolom dicocokkan berdasarkan nama) atau satu workbook dengan tab untuk masing-masing.
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.
