You can download your orders as an Excel file (xlsx) that opens in Excel, Google Sheets or Numbers. You choose which orders to include and which columns to show. You need the Orders permission.
Opening the export window
On the Orders page, click the spreadsheet icon (Export to XLS). The Export orders to sheet XLS window opens.
Choosing the orders
- Markets: pick one or more countries, or leave it empty for all markets.
- Product: search a product, pick it and click the plus button. Add as many as you need. Only the lines of those products are kept in the file. Leave it empty to export all products.
- Order status: All statuses (the default) or one status.
- Date range: a start and end date, with the time if you want. It filters by the date the order was placed. Leave it empty to export all dates.
- Sort by: Created at - descending (newest first, the default), Created at - ascending, Updated at - descending or Updated at - ascending.
Test orders, deleted orders and blurred orders (hidden because of unpaid usage fees) are never exported.
Choosing the columns
The window shows two lists: Available fields and Selected fields. Click fields to highlight them, then use the single arrows to move them, or the double arrows to move all of them. The order of the Selected fields list is the order of the columns in your file. Pick at least one field, otherwise you see "Please select at least one column to export".
Order fields
Order's ID, Order's Number, Order's date, Order's shipping method, Order's weight, Order's payment method, Order's subtotal, Order's discount, Order's shipping, Order's vat, Order's total, Order's currency, Order's market (country name), Order's market code (country code), Order's status, and a checkmark for Order's abandoned status, Order's duplicated status, Order's returning customer status and Order's test status.
Product fields (one per item)
Product's ID, Product's name, Product's price, Product's quantity, Product's sku, Product's barcode, Product's weight, Product's variants (for example Red - Large) and Product's link (the product page on your store).
Customer fields
Customer ID, Customer's fullname, birthday, gender, company, address1, address2, state / region, city, commune, province, postal code, country (the order's market), connection country (the country of the visitor's internet connection), email, phone, whatsapp, note, browser, OS, device and IP.
UTM and store fields
UTM's source, UTM's medium, UTM's campaign, UTM's term, UTM's content, and Store's name (useful when you merge files from several stores).
Downloading the file
Click Export. The file downloads with a name like orders-2026-09-28.xlsx. If nothing matches your choices, you see "No orders found matching the selected criteria".
How rows are laid out
The file has one row per item, so an order with three products takes three rows. Order, customer and UTM values show only on the first row of each order; the next rows of the same order leave them empty. Use Order's Number to group the rows of one order.
Want orders to reach a sheet by themselves, without exporting? Use the Google Sheets app. See Google Sheets.