Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

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

  1. 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.
  2. Click Add data and choose another type. The menu shows how many records each one has.
  3. 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.
  4. 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.
  5. Click Export. The types are exported one after another into one Excel file, a sheet each. The job page lists what each sheet exported.
The Bulkvane Export page: Products is listed under Data with 24 of 25 columns and a total of 17, and the Add data menu offers Customers (3) and Collections (3). The format is Excel (.xlsx).
Add data adds another data type to the same export. Each type keeps its own filters and columns.

Import a file with several sheets

  1. Open Import and add your .xlsx file, or import it from a link. A Google Sheet can be imported as a whole workbook.
  2. Choose the import mode, which applies to every sheet, then click Check file.
  3. 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.
The Bulkvane Import page: choose the data and import mode, add a .csv or .xlsx file, and a How it works panel explaining that Excel files with a sheet per data type import every sheet, each with its own preview.
Excel files with a sheet per data type import every sheet. The Excel template on this page is a good starting point.
Bulkvane Job history: one file, customers-2026-10-09.xlsx, listed as two import jobs, Customers and Products, each ready to review, and an export of Products and Customers that exported 10 products and 3 customers.
In Job history, one workbook becomes one import job per sheet, each with its own Review. A multi-type export is a single job.

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