search
Help / Topics / Import & export

Import & export

Everything about importing CSV files, exporting to Excel or CSV, and moving Shopify data in and out of Mixtable.

Import and Export

Export store data to Excel or CSV
Set up a worksheet, choose your columns, then download your Shopify data as an .xlsx file with formatting intact, or as a CSV of a single worksheet.
Export Shopify collections
Export Shopify collections to Excel or CSV with titles, handles, IDs, collection types, metafields, product counts, and other fields you choose.
Export products data
Export your Shopify product and variant data to Excel or CSV. Sync a live product spreadsheet, choose your columns, and download it whenever you need it.
Export products with metafields
Export Shopify products along with their metafields to Excel or CSV. Map any metafield namespace to a spreadsheet column and download it in seconds.
Export products with collections
Export Shopify products together with the collections they belong to. Add a collections column to your product worksheet, then download it all as an Excel file.
Export orders and line items
Export Shopify orders, custom attributes, line items, and line item properties to Excel or CSV. Choose your fields and download an up-to-date file.
Export orders with metafields
Export Shopify order metafields to Excel. Add an orders worksheet, map your metafield columns, and download a complete file with every order detail.
Export Shopify refunds
Export Shopify refund records and refund line items to CSV or Excel using a Mixtable spreadsheet connected to your store.
Export Shopify customers
Export Shopify customer data to CSV or Excel. Load the Customers template, add the fields you need, and download an up-to-date file whenever you want.
Export blog posts
Export Shopify blog posts to CSV or Excel. Load the Blogs and Blog Posts template, add any extra fields you want, and download the file in one click.
Export Pages
Export Shopify pages to CSV or Excel. Sync your store's Pages into a spreadsheet, add the fields you need, and download the file in one click.

CSV Import

Import CSV file
Import a CSV to update or add Shopify data in bulk. Map your columns, match rows by SKU or handle, and sync every change back to your store.

Can't find what you need?

We read every email. Real merchants, real answers, usually the same day.