I will do data entry and clean up your messy excel spreadsheets
About this Gig
Got a spreadsheet you dread opening? Send it over and get back a file you can actually use.
WHAT I DO
- Data entry from PDFs, scans, websites, images or handwritten notes
- - Clean-up: duplicate rows, mixed date formats, numbers stored as text, inconsistent names, stray blank rows
- - Splitting and merging columns, standardizing text, fixing formatting
- - Merging several files into one consistent sheet
- - Formulas that work: SUM, SUMIFS, COUNTIFS, INDEX/MATCH, plus a summary tab and chart
- - Web research and list building into a ready-to-use sheet
WORKS WITH
Excel (.xlsx), Google Sheets, CSV and plain text.
HOW YOU GET IT BACK
Your original data stays on its own tab so you can check my work. Totals are live formulas, not pasted numbers, so the sheet still adds up when you add a row. Every judgement call I made is written at the bottom of the file, so nothing changes quietly behind your back.
HOW IT WORKS
Send the file and tell me what "clean" means for you and when you need it. I'll confirm which package it needs before you order. You get a draft inside the delivery window, and revisions until it's right.
Message me with your file before ordering
FAQ
What do you need from me to get started?
The file itself, a note on what "clean" means for you (deduplicated, reformatted, merged, totalled), and your deadline. If you're not sure what's wrong with it, send it anyway and I'll tell you what I find before you order.
How many rows can you handle?
Roughly 200 on Quick, 1,000 on Full and 5,000 on Bulk, but it depends on how messy the file is. Send it first and I'll tell you which package it actually needs rather than have you guess.
Will you change my data?
Only in the ways you'd expect: formatting, duplicates, obvious errors. Your original stays on its own tab, and every judgement call - an ambiguous date, two spellings of the same customer - is listed at the bottom for you to check.
Can you work in Google Sheets?
Yes. Share the sheet with edit access or send a CSV, and tell me whether you want the result back as a Google Sheet or an Excel file. Either works.
Can you do this weekly or monthly?
Yes, as a separate order each time - send the new file and I'll apply the same clean-up. I don't take on standing access to your systems or live day-to-day admin, so everything stays file-in, file-out.

