I will build a working spreadsheet or clean up your data
About this Gig
I build working spreadsheets and I clean messy tables in Excel or Google Sheets. The aim is a file your team can update without breaking it: clear columns, formulas that calculate, drop-down lists where they help, and a short instructions or notes tab.
Typical files include job costing and cash flow trackers, quote and invoice templates, job or defects registers, simple budget sheets, and customer or invoice lists that need a consistent clean-up. I stay with standard formulas, data validation and conditional formatting. This gig does not include custom VBA or Apps Script, or a live link into your accounting system.
If I am cleaning data, I will standardise names, dates, phone numbers and amounts, remove clear duplicates, and record every rule I used. I will not invent missing names, addresses or figures.
The gallery has a fictional job costing and 13-week cash flow workbook, a quote and invoice template, and a before and after customer data clean-up, so you can see the range of work.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Functions
•
Cleaning
•
Data validation
FAQ
Excel or Google Sheets?
Either. Tell me which one your team uses, and I will build for that.
Can you write VBA macros or connect this to Xero or MYOB?
Not in this gig. If you need that later, ask first, and I will tell you if it is out of scope.
Will you guess missing customer or invoice details?
No. Blank or unclear values stay blank, or are flagged in the notes, unless you give me the missing fact.

