Importing multiple checkbox values using WP All Import

I’ve recently been working on a project that requires the import of data from a CSV sheet to ACF (Advanced Custom Fields) values for a CPT (custom post type). It’s been a frustratingly long journey, so I thought I’d share to make your life a bit easier. In theory, it’s a super straightforward process, but in practice it’s a tad difficult if you’re not sure what you’re doing or how the data is manipulated by WPAI when attempting to import multiple checkbox values using WP All Import. Here is a sample of the data I was attempting to import. In ACF, I have a multi-checkbox field that has a checkbox for each of the listed items (bike, horse, ski, etc). Originally, I formatted my spreadsheet with types of activities as the column name, and a 1 if that activity was to be checked. If you’re importing to a single checkbox, that works well, but not if you’re trying to import multiple checkbox values using WP All Import.

Checkboxes in ACF

In order to understand how to import, you’ll need to take a gander at how your field is set up in ACF. Here’s how my multi-checkbox is set up…
bike : Bike
horse : Horse
ski : Ski
skate : Skate
snowmobile : Snowmobile
hike : Hike
mountain Bike : Mountain Bike
The first bit of text is the value, and the second after the colon is the label.
value : label

Back to WP All Import

Now, if you have the ACF Plugin for WP All Import, this is gonna be easy. Here are the steps to make sure your checkboxes are imported as ‘checked’ when importing multiple checkbox values using WP All Import.
  1. Make sure the values in your spreadsheet match the values of the checkboxes you want to check.
  2. Add a list of all values separated by comma to the WP All Import field. Mine was: {activity1[1]},{activity2[1]},{activity3[1]},{activity4[1]},{activity5[1]},{activity6[1]},{activity7[1]}
  3. Import and verify that all boxes have been checked.
  4. Enjoy!

Tools used in this post

3 thoughts on “Importing multiple checkbox values using WP All Import”

  1. I’m trying to do something similar only I have values that are comma separated into one cell “value1,value2,value3,etc.” Do you know of a way to import a comma-separated list into checklists? I can’t find anything!

  2. I also would like to know that.
    In my case I also have a cell with comma seperated values that are representing the ‘slug’ values of the choices of the checkbox field.

Leave a Comment

Your email address will not be published. Required fields are marked *

Posted in