Browse categories
Explore
Fiverr Pro
English
$
USD
I will merge excel files, reconcile spreadsheets with data integration into one sheet
About this Gig
Have the same data spread across several spreadsheets? I will merge them into one clean file and show you exactly where they disagree.
I can:
- Combine files with different column orders and names
- Match records by ID, email, name or any key you choose
- Reconcile two sources, such as bank vs. ledger or orders vs. invoices
- Flag missing, duplicate and mismatched records on a separate sheet
- Keep a clear audit trail of which file each row came from
You receive one tidy workbook plus a summary of matches and differences.
Custom key matching: records matched on whichever column you trust most.
Clear audit trail: every row tagged with the file it came from.
Comprehensive report: one summary sheet of matches, gaps and mismatches.
Platform:
Excel
•
Google Sheets
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Power Query
•
Cleaning
My Portfolio
FAQ
My files use different column names. Is that OK?
Yes. Tell me which columns mean the same thing, or I will map them and confirm with you.
Can you reconcile bank statements?
Yes, as long as you can export them to Excel, CSV or a typed PDF.
Will I get formulas or values?
Values by default, so the file stays fast. Formulas on request.
Is my data kept confidential?
Yes. Your files are used only for your order, never shared with anyone, and deleted once you confirm the delivery. If some columns are sensitive, you can remove them first and I will match on the rest.
