Shopify orders CSV analyzer

English export headers are required. If the file has CSV structure warnings or unsupported headers, repair the file before analysis.

Summarize orders once, by date, currency and payment status.

Supported export and calculation rules

Export orders from one Shopify store. English headers are required. Multiple line items count as one order; conflicting order fields exclude that order. Dates use the calendar day written in the file. Order totals include unpaid and refunded orders, separated by financial status. Blank refunds count as zero; this is neither profit nor a Shopify sales reconciliation.

Export columns

Name
Created at
Currency
Total
Lineitem name

Use the result in another tool

Open a file or paste rows; the sample is synthetic. Processing stays in this browser. Review issues before exporting. Charts use one selected currency, clicks, or catalog row counts. A single snapshot produces a snapshot video, not an invented time series. Use Chart this for image exports, the video tool for animation, or Excel for a workbook. CSV downloads protect formula-like text with an apostrophe; the feed TSV keeps source values.

Try a sample

SAMPLE DATA

CSV

Name,Created at,Currency,Financial Status,Total,Refunded Amount,Lineitem name
#1001,2026-10-01 10:00:00 +0800,USD,paid,90.10,0,Notebook
#1001,,,,,,Pen
#1002,2026-10-02 11:00:00 +0800,USD,refunded,30,30,Notebook
#1003,2026-10-02 12:00:00 +0800,EUR,paid,50,0,Bag

Result

date,currency,financial_status,orders,order_total,reported_refunds
2026-10-01,USD,paid,1,90.1,0
2026-10-02,EUR,paid,1,50,0
2026-10-02,USD,refunded,1,30,30

Standards and references

Shopify