I will clean, match and reconcile your CSV, sql or spreadsheet data
IT Operations Business Systems Automation Specialist
About this Gig
Messy exports, duplicates, phone numbers in five formats, two systems that should match but don't? I do this kind of cleanup regularly: matching call logs to CRM tickets, reconciling marketing lists against ERP records, tracing missing orders between an online store and fulfillment systems.
What I can do:
Clean CSV or Excel files: duplicates, formatting, phone and email normalization, broken encodings
Match records between two files or systems by ID, email, phone or name - and show what matches, what doesn't and why
Write SQL queries against your MySQL database or run the check on your exports
Deliver a clean file plus a sheet of flagged discrepancies with explanations
How it works: send the files (or a sample) and describe the expected result. I confirm the approach, then deliver the cleaned data and a short note on what was changed. A reusable Python script can be included so you can rerun the process yourself.
Your files are used only for this task and deleted after delivery.
Platform:
Excel
•
Google Sheets
•
Power BI
Development technology:
Google Apps Script
•
Python
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Functions
•
Macros
•
Data validation
FAQ
What formats do you accept?
CSV, XLSX, Google Sheets, JSON, or direct MySQL access
Is my data safe?
Files are used only for the task and deleted after delivery
Can you set this up to run regularly?
Yes, the Premium package includes a reusable script; recurring work can be arranged separately
