I will clean up, format, and add formulas to your excel or google sheets
Python scripts, spreadsheet cleanup, small website fixes, and tidy data lists
About this Gig
Messy spreadsheet? Duplicate rows, inconsistent dates, broken formulas, or a sheet nobody wants to open? I'll tidy it up and make it easier to use.
I can help with:
- Removing duplicates and fixing inconsistent text, dates, and numbers
- Writing formulas: VLOOKUP/XLOOKUP, INDEX/MATCH, SUMIFS, IF, QUERY, and more
- Conditional formatting, data validation, and drop-down lists
- Pivot tables and simple charts
- Basic dashboards that summarize your data on one page
- Splitting or combining sheets and files
What you get:
- Your cleaned and formatted file (Excel or Google Sheets)
- Short notes explaining what I changed and how key formulas work
I work on a copy of your data and keep your original structure unless you ask me to change it. I don't use paid add-ons, so the file works in standard Excel or Sheets.
Not sure which package fits? Send me a message with a description or screenshot and I'll suggest one.
Platform:
Excel
•
Google Sheets
Development technology:
VLOOKUP
Expertise:
Formatting
•
Pivot tables
•
Formulas
•
Charts
•
Cleaning
FAQ
Excel or Google Sheets?
Either. Tell me which one you use and I'll deliver in that format.
Do you use macros or VBA?
Not by default. Most tasks are handled with formulas. If you need a macro, message me first.
Is my data safe?
I only use your file for your order and don't share it. Feel free to remove sensitive columns before sending.
