Export Shopify orders

Works with Spreadsheet EditorExport: Excel & CSV Updated November 3, 2026
On this page
Export Shopify ordersVideo walkthrough

To export Shopify orders to Excel with Mixtable, load your orders into a spreadsheet with the Orders and Order Items template, add any extra fields you need as columns, then choose Import & Export > Export to Excel (or Export to CSV).

Shopify’s own order export gives you a fixed set of columns. In Mixtable you choose them: tracking numbers, the custom attributes saved on an order, the line item properties saved on each item, metafields, and much more. Your orders spreadsheet also stays up to date with Shopify, so next month’s export for your accountant is a click away instead of a fresh setup. Here’s how it works:

Load Shopify Orders in a spreadsheet

First, set up a worksheet that syncs data to your Shopify orders. The quickest way is the pre-built Orders and Order Items template:

Open your Mixtable dashboard and click Create spreadsheet at the top of the page. If you haven't created a spreadsheet yet, click Browse all templates below the dashboard's suggestions instead. In the Create spreadsheet window, find Orders and Order Items under Orders & customers on the Store data tab, or type its name in the search box, and click it to preview it. Then click Create spreadsheet at the bottom of the window. Mixtable creates the spreadsheet and fills it with data from your Shopify store.

When you click the template, its preview has an Include orders placed drop-down set to Since 1 month ago. If your export needs older orders, choose an earlier date, or All orders, before you click Create spreadsheet.

On your first visit to Mixtable Export: Excel & CSV, clicking Orders and Order Items on the dashboard creates the same spreadsheet in one click, with orders since 1 month ago.

The Orders and Order Items template in Mixtable's Create spreadsheet window, with its Since 1 month ago start date

To load more Shopify data, click + Shopify data in the header row of an empty column, such as the one right after your last column. You can also choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column's letter in place of E. It lists everything the worksheet can show from Shopify, grouped into sections the way your Shopify admin groups them. Type in the search box at the top, or click a section on the left, to find the field you want.

Add Shopify data to a spreadsheet

Click the field you want, such as Payment status in the Order section, or Additional order detail in the Additional details section for the custom attributes saved on an order (then choose one under Select a detail). Click Save Column. Mixtable fills the new column with that data for every order.

Additional order detail picked in the Mixtable field picker for a Shopify Orders worksheet

When the data sync is ready, which could take a few minutes if you have a lot of data, you can trigger the export.

Order fields you can include

When you export your Shopify order data with Mixtable spreadsheet apps, you can include extra data, such as:

  • Order number
  • Order ID
  • Total (the order’s total amount)
  • Fulfillment status (fulfilled; unfulfilled; partially fulfilled; scheduled; on hold)
  • Payment status (paid, pending)
  • Order status page
  • Tracking numbers, with the Fulfillment tracking numbers field in the Fulfillment section

Note: Mixtable order worksheets stay up to date with Shopify automatically, so you can export the most recent order information at any time without re-downloading anything. If the sync control at the top right shows updates waiting from Shopify, for example Apply 3 updates, click it first so your export includes them.

Connecting order details with Metafields, Vendors, Product Types, etc. information used to mean VLOOKUP formulas. Not anymore! Mixtable now puts this data directly within your reach. Here's how to do it:

If you have already created a Mixtable spreadsheet with your Shopify Order information, you can quickly add related data to it.

Note: The worksheet needs to show order information, e.g., you can use the Orders and Order Items template spreadsheet, or the Orders (no line items) or Orders (with line items) worksheets.

Click + Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar.

Add Shopify data to a spreadsheet

  • In the field picker, click Products in the order in the list of sections on the left. It holds the details of the products in each order, such as Product vendors, Product types, Variant SKUs, and Product metafields. Fulfillment details, such as Fulfillment count, are in the Fulfillment section

The Products in the order section of the Mixtable field picker for a Shopify Orders worksheet, with related data fields such as Product vendors, Product types, and Variant SKUs

  • Click the field you want. If the panel on the right asks how to combine the values, or which metafield to use, make your choice
  • Click Save Column
  • Allow some time for the data to appear in the column, and you are ready!

Find more about Related Data Fields functionality here.

Add order, product, and variant details to line items

The Line Items worksheet gives you one row per line item: a single product sold in an order, with its SKU, quantity, price, and vendor. What makes it special is related data. Next to each line item’s own fields, you can add details from its parent order and from the product and variant that was sold, with no lookups and no copying between sheets.

  1. Open the Line Items worksheet
  2. Click + Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens
  3. Pick a section in the list on the left:
    • Line item holds the line item’s own fields, such as SKU, Quantity ordered, and Unit price
    • Order, Customer, Payment & totals, Shipping address, and the other order sections hold details from the line’s parent order. These fields are marked Order: every line of the same order shows the same value
    • Products in the order holds details of the product and variant that was sold, such as Product vendor, Product type, Product category name, Variant SKU, Variant barcode, and product or variant metafields
  4. Click the field you want, such as Customer first name in the Customer section, then click Save Column

Mixtable fills the new column for every line item, straight from Shopify. For example, add Customer first name and Product category name, and each row of your export shows who bought the item and what kind of product it is.

Export order customizations and additional order details

Some stores collect extra information about the whole order during checkout. Shopify and other apps may call this information order custom attributes, note attributes, or additional order details. Examples include a gift message, a purchase order number, a requested delivery date, or a preferred pickup time.

Mixtable can place each additional order detail in its own spreadsheet column so it is included when you export your Shopify orders:

  1. Open an Orders (no line items) worksheet
  2. Click + Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens
  3. Click Additional details in the list of sections on the left, then click Additional order detail. Mixtable reads your recent orders and lists the attribute names it finds under Select a detail
  4. Pick the attribute you want, then click Save Column

Mixtable names the column after the attribute and fills it with the value saved on each order. Repeat these steps for every additional order detail you want to export.

Export line item properties and product customizations

A line item property is extra information attached to one specific item in an order rather than to the order as a whole. Product option, personalization, and custom pricing apps all use line item properties. Common examples are engraving text, a monogram, a recipient name, a gift wrap choice, and the exact quantity or measurement a customer chose for that item.

To export Shopify line item properties to Excel or CSV:

  1. Open the Line Items worksheet. It gives you one row for each item sold, and you can add the details of its parent order to every row
  2. Click + Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens
  3. Click Additional details in the list of sections on the left, then click Line item property. Mixtable reads your recent line items and lists the property names it finds under Select a detail
  4. Pick the property you want, then click Save Column

Mixtable names the column after the property and fills it with the value saved on each line item. Repeat these steps for every property you want to export.

If the attribute or property you need is not in the list

Mixtable reads both lists from your recent orders every time you click Additional order detail or Line item property, so a name appears as soon as one order carries it. If an order came in while the field picker was open, click Reload beside Select a detail to read your orders again.

Names that start with an underscore, such as _source, are normal. Apps use them for information they hide from the customer, and they export exactly like any other property.

Important: The app that collects the customization must save it to Shopify as an order attribute or line item property. Mixtable cannot export information that the app keeps only in its own private system. If you are unsure, open one of the orders in your Shopify admin: anything you can see on the order there is something Mixtable can export.

If you can see the information on the order in your Shopify admin but not in the Mixtable list, email Mixtable support so we can investigate.

Export Shopify Orders in a .xlsx or .csv file

Once your order fields, additional order details, and line item properties are visible in the worksheet, click Import & Export in the menu bar. You have two choices:

  • Export to Excel downloads the entire spreadsheet as an .xlsx file, with every worksheet included
  • Export to CSV downloads only the worksheet you have open at that moment. To get your line items into a CSV, open the Line Items worksheet first, then export

Every column you mapped is included in the file, so your custom attributes and line item properties arrive alongside the standard order fields.

Mixtable's Import & Export menu open over a Shopify Orders worksheet, with Export to Excel and Export to CSV

Tip: If you export orders mainly to total them up in Excel afterwards, Mixtable can do the totalling for you. Mixtable Analytics Spreadsheet builds reports such as store sales and orders by month, and those worksheets export to Excel or CSV exactly the same way.

Mixtable Spreadsheet EditorBulk edit and sync products, prices, inventory, metafields, and more
Install on Shopify

↑↓to moveEnterto open