How can I import a .csv file with multi-reference fields (category and department) into Webflow and map them to the appropriate collection items?
- Create Collections for multi-reference fields (e.g., Categories, Departments) and ensure all referenced items already exist with matching names.
- Format your main CSV with comma-separated values in multi-reference columns, then use a tool like PowerImporter to map and import the data into Webflow.
To import a .csv file with multi-reference fields (like category and department) into Webflow and correctly map them to Collection items, you need to follow a process that prepares your data and ensures referenced items already exist.
1. Prepare the Multi-Reference Collections
- Create separate Collections for Categories and Departments in Webflow if they don’t already exist.
- Ensure the names of items in these Collections match exactly the values in your CSV (e.g., the category name “Design” should match exactly to a “Design” item in your Categories collection).
- You can use manual entry or bulk import tools (see below).
2. Ensure Referenced Items Exist in Webflow
- Before importing your main CSV, confirm that all referenced category and department names from the multi-reference fields already exist as Collection Items in Webflow.
- If they don’t, import them first using a separate CSV for each reference Collection.
3. Structure Your CSV for Multi-Reference Fields
- In your main CSV file, make sure the multi-reference columns (Category, Department) contain a comma-separated list of values, like:
- Category:
Design, Development - Department:
Marketing, HR
4. Use a CSV Import Tool with Multi-Reference Support
Webflow’s native CSV import does not support multi-reference fields directly. Use a third-party tool like PowerImporter or Whalesync.
- PowerImporter:
- Sign in and link your Webflow site.
- Choose the relevant Collection (e.g., Projects).
- Upload your main CSV file.
- Map the multi-reference fields (e.g.,
Category,Department) to the referenced Collections. - PowerImporter will automatically link to the matching Collection items.
Note: If PowerImporter can’t find a referenced item, it will either show an error or prompt you to create it.
5. Import and Verify in Webflow
- Once imported, go to Webflow CMS and open a few items in your main Collection.
- Confirm that the multi-reference fields correctly link to the expected Category and Department items.
Summary
To import multi-reference fields from a CSV into Webflow, make sure the referenced items exist, format your CSV with comma-separated values, and use a third-party tool like PowerImporter to handle the mapping. Webflow’s native import tool cannot manage multi-reference fields directly.
