Workbook Merger
Combines many workbooks or sheets into one, stacking rows or adding each source as its own sheet.
Twelve monthly exports that need to become one table, or a folder of workbooks that needs to become one file. The difference matters: stacking aligns rows by header name rather than by position, so a file with its columns in a different order still lands in the right places.
Drop the workbooks to combine
Drop them in the order you want them. Everything is read in this tab.
How to use it
Drop the workbooks in order
Order matters for stacking — it is the order the rows end up in.
Choose sheets or a stacked table
Sheets copies everything into one workbook unchanged. Stacking builds one table, matching columns by header name.
Keep the source columns on
A source file and sheet column is the only way to trace a row in the combined table back to where it came from.
Read the missing-column warning
It lists the headers that appear in some files and not others. That is usually a typo in one file, not genuinely missing data.
Common questions
What happens to formulas?
They come across as their last calculated value. A merged workbook has no relationship to the sheets a formula referred to, so keeping the formula would produce either a broken reference or a wrong number.
Is the formatting kept?
No — values, dates and text only. Colours, borders, charts and images are not carried, which is the trade for a merge that runs entirely in the browser.
The columns did not line up.
Stacking matches on the exact header text, so a trailing space or a different word breaks the match and the column appears twice. The warning lists the ones that only appear in some files.
Feed it from
Workbook Splitter
Splits a workbook into one file per sheet, or one file per distinct value of a chosen column.
Excel to CSV
Exports each sheet of an .xlsx or .xls workbook to CSV with the encoding and delimiter you choose.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
Report Sheet Tidier
Unmerges cells, fills the gaps left behind, drops decoration rows and turns a report into a flat table.
Next
These accept what this tool produces, so the result can go straight in.
CSV Cleaner
Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.
CSV Join
Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.
Workbook Splitter
Splits a workbook into one file per sheet, or one file per distinct value of a chosen column.
Excel to CSV
Exports each sheet of an .xlsx or .xls workbook to CSV with the encoding and delimiter you choose.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
Audio Converter
Converts between MP3, WAV, FLAC, AAC, OGG and Opus with bitrate and sample-rate settings.