I will clean and dedupe shopify data in google sheets and dashboard
Data Cleaning and Excel Dashboard Specialist
About this Gig
Your Shopify export is lying to you. Duplicate orders, three different date formats, and totals that refuse to add up because half your amounts are text. You cannot make decisions from data like that, so let me fix it properly. I will clean, dedupe and standardise your Shopify sales data in Google Sheets or Excel, verify every total, and with Standard and Premium turn it into a clean KPI dashboard showing revenue, orders, average order value, top products and returns. What you get: duplicate rows/orders removed with before/after row counts; one consistent date format, one product-name style, clean customer names; amounts converted to real numbers your formulas and pivots can use; totals verified before and after cleaning, with check numbers in delivery; Standard and Premium include a KPI dashboard with revenue, orders, AOV, top products, returns and a revenue-by-month chart; Premium adds auto-refresh formulas/scripts, a PDF summary, and a 7-day fix window. How it works: send your export as it is; I clean and verify it; you get a tidy file plus your dashboard on Standard/Premium. Message me your row count if unsure which package fits.
Platform:
Excel
•
Google Sheets
Development technology:
Google Apps Script
•
Power Query
•
Excel
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Charts
•
Cleaning
FAQ
My export is a complete mess. Is that a problem?
No — that's exactly what this gig is for. Duplicates, mixed date formats, inconsistent product names and amounts stored as text are the normal state of a Shopify export. Send it as it is; don't waste time pre-cleaning it.
Could you lose or change my real data?
No. I reconcile before and after: row counts, duplicates removed and sum totals, and I include those check numbers in your delivery. Your original file is never overwritten — I work on a copy.
Google Sheets or Excel — which do you deliver?
Your choice. Google Sheets is best if you want easy sharing and, on Premium, automatic refresh. Excel works the same for the cleaned data and dashboard, just without live auto-refresh.
What if I have more rows than the package limit?
Message me before ordering with your row count and I'll make you a fair custom offer. I won't surprise you with mid-order upsells — we'll agree the scope first.
Is my data private?
Yes. Your file is used only for your order, never shared or sold, and I will delete it on request and confirm once done.

