Analyze Amazon order-history CSV exports

Paste an Amazon order-history CSV export to calculate total spend, monthly spend, top items, and category totals. The parser handles both classic Amazon Order History Report columns and newer Request My Data / Retail.OrderHistory exports.

Everything runs locally in the browser. Your purchase history is not uploaded.

Worked example

Input:

Order Date,Order ID,Title,Category,Quantity,Item Total
2024-01-05,111-1111111-1111111,USB-C Cable,Electronics,2,$9.99
2024-01-20,111-1111111-1111112,Coffee Beans,Grocery,1,$18.50
2024-02-03,111-1111111-1111113,USB-C Cable,Electronics,1,$9.99

With output=summary and top=5, the result reports total spend, a month-by-month table, the repeated USB-C Cable grouped as a top item, and an Electronics/Grocery category breakdown.

Supported columns

The analyzer detects common columns case-insensitively:

• Date: Order Date, Order Date/Time, Date, Shipment Date, Ship Date
• Item: Title, Product Name, Item Name, Name
• Amount: Item Total, Total Owed, Item Subtotal, Total Charged, Subtotal, or Purchase Price Per Unit
• Optional: Quantity, Order ID, Category

Currency symbols and thousands separators are tolerated. If the export uses per-unit prices, quantity is multiplied into item spend.

Limits and edge cases

This tool is deterministic CSV aggregation, not a budget app. It does not connect to Amazon, fetch receipts, infer categories with machine learning, or reconcile refunds that are not represented in the CSV rows. Rows with missing or unparsable amounts are counted as skipped in the summary.