Home › Merge Guides › WooCommerce + Depop › Google Sheets Import
Merge WooCommerce and Depop Sales Data for Google Sheets Import
A clean Google Sheets dashboard across channels starts with a single sheet that already has matching columns.
Why WooCommerce and Depop exports don't line up
- WooCommerce: an Order Date in whatever format your WordPress site's locale is set to; an Order Total that depends entirely on which tax/shipping plugins are installed; a plain numeric Order Number. Also, column layout depends on which export plugin generated the CSV, so two WooCommerce stores can produce different headers entirely.
- Depop: a transaction date column; item price and Depop's payment processing fee as separate lines; a transaction ID rather than a traditional order number. Also, like Poshmark, the export is minimal and mixes sold, refunded, and offer-related rows together.
For google sheets import, that mismatch is exactly what causes hours of manual cleanup every period.
How to merge them in under a minute
- Open CSV Experts and set your target columns once (Date, Channel, Order ID, Total).
- Drop in your WooCommerce export and map its columns once.
- Drop in your Depop export and map it the same way — both merge into one sheet, normalized.
- Export as CSV or Excel. Same-layout files merge automatically next time.
FAQ
Does this upload my sales data anywhere?
No. Everything runs in your browser using JavaScript — your files are never sent to a server.
Does it work for more than two channels?
Yes. Add as many source files as you want; each distinct file layout is mapped once and remembered.
Prefer a longer walkthrough of this pair? See the step-by-step version.
More WooCommerce + Depop guides
- WooCommerce + Depop for Bookkeeping
- WooCommerce + Depop for Tax Prep
- WooCommerce + Depop for QuickBooks Import
- WooCommerce + Depop for Xero Import
- WooCommerce + Depop for Profit Tracking
- WooCommerce + Depop for Inventory Reconciliation