I will build, fix or automate your google sheets or excel spreadsheet
About this Gig
Need a spreadsheet that works the way you do? I build and fix Google Sheets and Excel files: broken formulas, messy data, dashboards and Apps Script workflows.
What I can do:
- Fix formulas: VLOOKUP/XLOOKUP, INDEX/MATCH, SUMIFS, QUERY, ARRAYFORMULA, #REF! and #N/A errors
- Clean and format data: duplicates, dates, split/merge columns, data validation dropdowns
- Build dashboards: KPI cards, charts, summary tabs that update from your data
- Trackers and templates: budgets, subscriptions, inventory, trade logs, client lists
- Conditional formatting: color rows by status, due dates and thresholds
- Apps Script: custom menus, scheduled emails, auto-sort, copying rows between tabs
How it works:
1. Send me your file (or a copy with sample data) and tell me what it should do
2. I confirm the scope and price before starting
3. You get the finished file plus short notes on how to use it
I keep your structure where possible and label every formula so you can maintain it. Not sure which package fits? Message me before ordering and I'll tell you.
Platform:
Excel
•
Google Sheets
Development technology:
Google Apps Script
•
Excel
Expertise:
Formatting
•
Fixing
•
Formulas
•
Dashboard
•
Cleaning
FAQ
Do you work in Google Sheets or Excel?
Both. Apps Script (Premium) is Google Sheets only; for Excel I use formulas, tables and conditional formatting.
Do I need to share my real data?
No. A copy with dummy or sample data is fine. I only need the same columns and structure.
How do I share the file?
Share a Google Sheet with edit access, or attach the .xlsx in the order. I return a copy so your original stays untouched.
What if the job is bigger than the package?
Message me first. I'll confirm the scope and send a custom offer before any work starts.
Will I be able to edit it later?
Yes. I explain the main formulas and comment any script so you can maintain it.
Can you write macros (VBA) for Excel?
Not in this gig. I work with formulas, Excel tables and Google Apps Script. Message me what the macro should do and I'll tell you if a formula or Apps Script solution can do it instead.
Is my data kept private?
Yes. I use your file only for your order and don't share it.

