How to Export Sales Data to CSV
Tax season. Your accountant asks for "a spreadsheet of all your sales." You sell on three platforms. Each has a different export format, different column names, different date formats. Here's how to get one clean file for the range you actually need.
The Three-Export Nightmare
- 1 Export CSV from LemonSqueezy. Note its column names
- 2 Export CSV from Gumroad. Different column names
- 3 Export CSV from Stripe. Yet another format
- 4 Open all three in Excel. Manually normalize columns
- 5 Merge into one sheet. Pray you didn't mess up a date format
One Tap, One File
- ✓ SaneSales exports orders from every connected platform in one CSV
- ✓ One set of columns: date, order number, customer, email, product, provider, status, tax, total and refund date
- ✓ Refunds marked: refunded orders say so in the Status column
- ✓ On iPhone and iPad, pick a date range first and export just those orders
- ✓ Save or share it from the share sheet. It is a plain CSV that opens anywhere
Free and open source. Every feature stays unlocked. Donate if you want to support it.
What's in the CSV
Every row is one order. The columns are Date, Order #, Customer, Email, Product, Variant, Provider, Status, Subtotal, Tax, Discount, Total, Currency and Refunded. Open it in Excel, Google Sheets, Numbers or your accounting tool.
Questions
Where is the CSV export?
In Settings, choose Export Orders (CSV), then save or share the file. On iPhone and iPad it exports the date range you picked. On Mac it exports every order SaneSales has synced.
Which columns are in the file?
Date, Order #, Customer, Email, Product, Variant, Provider, Status, Subtotal, Tax, Discount, Total, Currency and Refunded. Amounts have two decimal places.
How do refunds show up?
A fully refunded order keeps its row and says refunded in the Status column. The Refunded column holds the refund date when the provider supplies one. Total is the original order amount.