I will merge multiple spreadsheets into one clean master file
Data Processing and Data Entry
About this Gig
Exports from Shopify, a warehouse sheet and a sales report that don't line up? I map the columns, merge everything into one master sheet, remove duplicates and format it so it's ready to share or import.
What I do:
- Match records across files (e.g. sku1006 vs SKU-1006)
- Map and rename columns to one standard
- Merge, dedupe and standardize values
- Flag conflicts (e.g. two different prices) instead of overwriting
- Import-ready CSV for your CRM or accounting tool on request
- Change log tab explaining every decision
How I work: AI-assisted tools process your file, then every delivery is checked against your instructions and comes with a change log. Your original is never altered. Prefer no AI on your order? Message me before ordering and I'll confirm or decline.
Message me with the number of files and rough row counts for a quick recommendation.
Platform:
Excel
Development technology:
RStudio
Expertise:
Formatting
•
Fixing
