Monthly reports, regional sheets, exports from different teams: sooner or later you need them in one table. Copy and paste works for two files with identical columns. It breaks when files have different column orders, renamed headers or extra columns.
Plumb is built on a simple idea: the data your business runs on should be trustworthy before anyone draws conclusions from it. Cleaning, checking and reshaping data should not need macros, scripts or a weekend. Plumb keeps your files private, shows every change it proposes, and lets you approve fixes instead of hunting for problems by hand.
How Plumb helps: Data transformation
Plumb's data transformation merges many files at once. It matches columns by name and meaning (so 'Cust Name' and 'Customer Name' line up), shows you the proposed column mapping, adds a source column so you know where each row came from, and flags rows that do not fit.
How It Works
Decide first whether you are stacking files (appending rows) or joining them (adding columns by a shared key).
- Put all files in one folder and make sure the sheets you need have headers in row 1.
- In Excel: Data > Get Data > From File > From Folder, pick the folder, then Combine & Transform.
- In Power Query, rename mismatched headers so they match, then Close & Load.
- To join instead of stack, use Merge Queries on a shared key like Order ID or Email.
- In Python: pd.concat([pd.read_excel(f) for f in files], ignore_index=True) stacks files with matching columns.
- In Plumb: upload all files, review the column mapping, choose stack or join, and export one combined sheet.
Where This Helps
Monthly rollups
Combine twelve monthly sales files into one year-to-date table.
Regional reports
Stack sheets from different branches even when their columns are in a different order.
Vendor data
Join supplier price lists to your product list by SKU.
Try Plumb in early access
Plumb is in early access. Join the waitlist on tryplumb.pro to get an invite. Early access covers Excel (.xlsx), CSV and JSON files, and we are adding more sources as people ask for them. Your files are processed privately and are never used to train models.
Many files, one source of truth
Now you have a repeatable way to do it, by hand or with Plumb. Join the waitlist and tell us what your data looks like; we read every reply.
Join the waitlist