Shopify and e-commerce exports
Clean Shopify and e-commerce exports for reports and re-imports
Order and product exports repeat rows per line item or variant, mix date formats and carry currency text. Turn them into clean tables in your browser, the same way every week.
Before
| Name | Created at | Total | |
|---|---|---|---|
| #1001 | ana@example.com | 2026-03-02 10:14:00 +0100 | $84.00 |
| #1001 | (blank) | 2026-03-02 10:14:00 +0100 | (blank) |
| #1002 | ben@example.com | 2026-03-02 11:40:00 +0100 | $19.50 |
After
| Name | Created at | Total | |
|---|---|---|---|
| #1001 | ana@example.com | 2026-03-02 | 84.00 |
| #1002 | ben@example.com | 2026-03-02 | 19.50 |
Store exports are built for re-importing into the same store, not for reporting or for other tools. Shopify’s order export, for example, writes one row per line item, with order-level fields such as email and total only on the first row of each order; product exports repeat the handle on every variant row. Spreadsheets, accounting software and email tools expect one clean row per order or customer.
What GridRinse fixes
- One row per order or customer: remove duplicates by key columns you choose (order number, email), keeping the first or last occurrence; optionally ignoring capital letters and spaces. Choosing keys.
- Dates and times: timestamps like
2026-03-02 10:14:00 +0100become one date format, with or without the time of day. - Money: currency symbols and separators removed so totals sum correctly.
- Columns: drop the dozens of columns you do not need, rename the rest, merge or split columns (for example a full name into first and last name).
- Several exports at once: stack monthly files into one table, or clean each separately into a ZIP (merging files).
Do it once, then one click every month
Build the steps on this month’s file, check the preview, and save them as a workflow. Next time, load the new export and apply the workflow: the same steps, in the same order, every time. The free plan keeps workflows in your browser and lets you export them as JSON; Pro ($9/month) saves up to 50 workflows to your account so they follow you between computers, and raises the limits to 50 MB files, 500,000 rows and 20 files per batch.
Questions
- Does it connect to my store?
- No. You export the CSV from your store admin as usual and open it in GridRinse. Nothing is connected and nothing is uploaded.
- How large can the export be?
- 5 MB and 50,000 rows per file on the free plan, 50 MB and 500,000 rows on Pro, 200 MB and 2,000,000 rows on Business. Processing speed depends on your computer.
- Can I keep the line items instead?
- Yes. Leave out the duplicate step (or use other key columns) and only clean dates, money and spacing.
Try it on this month’s export
The cleaner is free in your browser, no sign-up. When the steps are right, save them as a workflow; Pro keeps them in your account for $9/month, cancel any time.
Other uses: Bookkeeping and bank exports · CRM and mailing-list imports