Browse categories
Explore
Fiverr Pro
English
$
USD
I will write sql queries and clean your excel and database data
About this Gig
Is your Excel messy or your database slow? I will fix it FAST.
I clean dirty Excel/CSV AND write SQL queries that actually work. Perfect if you need 2-in-1
WHAT I DO FOR EXCEL:
- Remove duplicates, trim extra spaces, fix formatting
- Fix and standardize messy locations - provinces, states, cities (e.g. W.Cape -> Western Cape, CA -> California)
- Standardize emails, phone numbers, names
- Clean 100 to 1000+ rows using Excel and Python (pandas)
WHAT I DO FOR SQL AND PYTHON:
- Write 1-3 custom SQL queries (SELECT, JOIN, WHERE, GROUP BY)
- Optimize slow queries and fix errors
- Clean data directly inside MySQL or using Python
- Create before and after reports in Excel
WHY ME?
I built a case study on the Madlanga Commission - tracking R5B unspent by Land Reform, R13-14B by UIF, officials on full pay for 7 years, and ballistics backlogs. I mapped it with Risk Analysis (Single Point of Failure, Moral Hazard) and designed 3 trackers: Suspension Tracker in MySQL, Unspent Funds vs Delivery in Python, and Vetting Gap analysis.
You'll get Clean Excel/CSV file ready to use + working SQL queries + explanation + revisions.
Send your file or SQL problem before ordering if over 1k rows.
My Portfolio
FAQ
What do you need to start?
Just upload your Excel or CSV file or tell me your SQL table names and what you want the query to do.
Can you handle large files over 1000 rows?
Yes. Message me first with the row count and I will give you a custom offer using Additional Items Tagged.
What SQL do you use?
I use MySQL and standard SQL. I can do SELECT, JOIN, WHERE, GROUP BY, and query optimization.
Do you also do Power BI dashboards?
My laptop does not handle Power BI well, so I offer Python data cleaning with pandas instead. I clean your data in Python and give you a clean Excel file plus a simple report. Message me if you need python visualization and data cleaning.
