Export AliExpress Orders to Excel or CSV
Updated October 5, 2026
You can download your imported AliExpress orders as an Excel or CSV file, for your accountant or for your own analysis in a spreadsheet. The file contains every order that matches the date range and filters of the AliExpress report.
- Where
- Suppliers > AliExpress, Export in the report toolbar
- Time
- Under a minute for most accounts
Download the File#
In the sidebar, open Suppliers, then AliExpress.
- 1
Step 1 of 3
Pick the date range and filters#
Pick the date range, and if you need to, a Delivery country, Product or Supplier. The export contains exactly the orders the report shows.
- 2
Step 2 of 3
Click Export#
Click Export on the right of the toolbar.
The AliExpress report. Export is the last button in the toolbar at the top right.
If the Export button shows an upgrade hint instead of the menu, data exports are not included in your current plan.
- 3
Step 3 of 3
Pick a template and a format#
Pick a template and a format: Order list or Detailed order list, each as Excel (XLSX) or CSV.
Use Excel (XLSX) if you open the file in Excel. A CSV file opened in Excel can show amounts and dates in the wrong format, depending on the language settings of your computer.
Done
The file downloads#
Wait while the button shows Preparing export…. The file downloads by itself when it is ready, and a message Export ready appears with a Download button in case the download was blocked.
Which Template to Pick#
| Template | Contains |
|---|---|
| Order list | Per order: date, status, the matching Shopify order, number of items, product total, shipping, tax, discount, order total and currency. Per item: description, variant, store, quantity, unit price and line total. |
| Detailed order list | Everything in Order list, plus the amounts in the currency you paid on AliExpress, payment method and date, tracking numbers and carriers, the delivery address, and per item the product id, shipping method, shipping price and delivery time. |
How the File Is Laid Out#
Each order takes several rows: first one order row, then one item row for each product in the order. The first column, row_type, says which one a row is (order or item).
- Order rows hold the order amounts (
product_total,shipping_total,tax,discount,order_total). Their item columns are empty. - Item rows hold the item amounts (
item_unit_price,item_line_total). Their order amount columns are empty. - The order number, date, status and matching Shopify order are repeated on every row, so you can sort and filter without losing track of which order a row belongs to.
Because the other rows are empty in each amount column, you can sum a whole column. Example for an order with two products:
| row_type | platform_order_id | item_description | item_quantity | item_line_total | shipping_total | order_total |
|---|---|---|---|---|---|---|
| order | 8201764310025907 | 3.20 | 27.70 | |||
| item | 8201764310025907 | Linen cushion | 2 | 15.00 | ||
| item | 8201764310025907 | Bath towel | 1 | 9.50 |
Total spent in the period. Sum the order_total column. Only order rows have a value there, so each order is counted once. In Excel, =SUM(...) over the column is enough; there is no need to remove duplicate rows.
Number of orders. Filter row_type to order and count the rows.
Limits#
- The main amount columns (
product_total,order_totaland the others) are in your report currency (see How to Change the Currency of AliExpress Orders); thecurrencycolumn on each order row names it. The columns ending in_sourcein the detailed template keep the currency you paid in, named incurrency_source. - Cancelled AliExpress orders are included. Check the
statuscolumn if you want to leave them out.
Related articles
Was this article helpful?

