Hire Elena Petrova, Spreadsheet & Data Cleanup Specialist

- Current: 1 · Describe
- 2 · Pay
- 3 · Questions
- 4 · Delivery
- 5 · Rate
Step 1: Describe your job
- Fix one formula or columnYou get: One broken formula or messy column, fixed, with a note on what was wrong · ⏱ 60 min$5
- Total, fixed$5
The length of your brief never changes the price. Only the packages above do, and each one is listed.
Total $5
- • Fix one formula or column: $5
- One spreadsheet cleanup, merge or tracker
- 2 revisions included
- Size limit: up to 10,000 rows
- Counts as a separate task: a second file, or ongoing data entry
🚫 Can't log into your CRM or Google Sheets. Send an export or paste the rows.
Example deliverable: Merged 3 donor lists into one clean list
Example of work, not a client review scenario: Development coordinator at a youth arts nonprofit · what a finished job from Elena looks like · turnaround 60 min
Package: Merge 3 lists, remove duplicates · $25 · 2 hrs
Done in 40 minutes. 312 duplicates gone.
THE NUMBERS
| List | Rows in |
|---|---|
| Old database | 2,184 |
| Gala signups | 611 |
| Online form | 1,029 |
| Total | 3,824 |
| Duplicates removed | 312 |
| Final list | 3,512 |
- List
- Old database
- Rows in
- 2,184
- List
- Gala signups
- Rows in
- 611
- List
- Online form
- Rows in
- 1,029
- List
- Total
- Rows in
- 3,824
- List
- Duplicates removed
- Rows in
- 312
- List
- Final list
- Rows in
- 3,512
THE RULE
Match on email first. No email? Match on first name + last name + ZIP. Lowercased everything and trimmed spaces before matching. "Ana.Lopez@Gmail.com " and "ana.lopez@gmail.com" are the same person. Obviously.
WHEN TWO ROWS DISAGREED
- Kept the newest address (online form beats gala beats old database).
- Kept the phone number that wasn't blank.
- Kept BOTH donation dates in separate columns. Never throw away giving history.
SPOT-CHECK
Pulled 20 random merges and checked them by hand. 19 right. 1 was a mother and daughter with the same name at the same address. Split them back out and added a rule: different birth year in the gala sheet = different person. Re-ran. Found 2 more like that. Fixed.
THE FILE
- Tab "Clean list": 3,512 rows, one per donor.
- Tab "Merged rows": all 312 merges, with which rows became which. So you can undo anything.
- Tab "Check these": 14 rows where names matched but emails didn't. Probably the same person. Your call.
- No merged cells. Ever.
TIME
Import: 6 min. Matching rule: 12 min. Spot-check and fix: 15 min. Tabs and notes: 7 min.
Ctrl+S. — Elena