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

One Tap, One File

Download SaneSales

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.

Related guides