Data types
Export and import several data types in one file
One Excel file with a sheet per data type, exported together and imported as one job per sheet.
Last updated
Export several data types at once
- Open Export. Your first data type is listed under Data, with a summary of its filters (such as All products), how many columns are chosen and how many records it has.
- Click Add data and choose another type. The menu shows how many records each one has.
- Open a type's row to choose its filters and columns, or remove it with the bin icon. ID and Handle (or Email, for customers) are always included so you can import the file back.
- Leave the format on Excel (.xlsx). A CSV file holds only one data type, so CSV can't be chosen once you add a second type.
- Click Export. The types are exported one after another into one Excel file, a sheet each. The job page lists what each sheet exported.

Import a file with several sheets
- Open Import and add your .xlsx file, or import it from a link. A Google Sheet can be imported as a whole workbook.
- Choose the import mode, which applies to every sheet, then click Check file.
- Bulkvane creates one import job per sheet and opens Job history, where they're listed. Each job has its own preview, so you can review and apply them one at a time, and its own Undo.


Sheets are recognised by name: Products, Customers, Collections, or Smart Collections and Custom Collections. Files exported by Bulkvane or Matrixify work as they are. See Bulkvane vs Matrixify.
For other workbooks, the sheet named after the chosen data type is used; otherwise the first sheet.
How it counts toward your plan
- Each data type has its own limit. On Free, one export can include 10 products and 10 customers.
- An import runs one job per sheet, so each sheet can include up to your plan's limit for its data type.
See plans and billing for the limits on each plan.
Good to know
- Keep the ID columns in every sheet. They make sure edits update the right customers, collections and products.
- Each sheet uses the same columns as a single-type file. See the column reference.
- If one sheet has errors, the other sheets' jobs aren't affected.
Related guides
- Install Bulkvane and run your first exportInstall from the Shopify App Store, export your products to Excel and see how the file is laid out.
- Import and export customersCustomer columns, how customers are matched, and what's read-only.
- Import and export collectionsSmart collections with conditions, manual collections with product lists, and what Replace mode does.
- Plans and billingHow plans work, how you're charged, and how to change or cancel.