How I read an Etsy order export in the browser without uploading it

Description and use

A browser‑only tool lets Etsy sellers analyze order exports locally, computing EU shipment share and packaging needs while keeping buyer data private.

Problem

Sellers needed to determine how many orders shipped to the EU for EPR compliance without exposing buyer addresses.

Outcome

The tool allows sellers to compute EU shipment share and packaging requirements locally, preserving buyer privacy.

Workflow

• 1. Drop the Order Items CSV onto the eprkilo web page.
• 2. The page uses papaparse with a FileReader to parse the file client‑side.
• 3. Header names are matched case‑insensitively to locate required columns.
• 4. Rows are grouped by distinct Order ID to count orders and compute per‑order and per‑item packaging weights.
• 5. Sales totals are bucketed by currency code without conversion.
• 6. The UI shows the percentage of EU orders and total packaging weight.
• 7. No data is sent to the server except minimal counter pings (≤74 bytes).

Evidence

The page hands the File object to papaparse. Without a download option, papaparse reads it through a FileReader, so the bytes never become a request.

Source

The contents of the file never leave the browser.

Source

I wrapped this in a free page called eprkilo. You drop the Order Items file and the first screen shows what share of your orders went to the EU... The source is public under MIT, and I built it.

Source