--- title: How to Import an ACF Custom Field with Multiple Comma Separated Values Using Excel description: "Import an ACF field with several comma-separated values, such as a checkbox field, into WooCommerce from Excel." url: "https://wpfactory.com/docs/how-to-import-acf-custom-field-with-multiple-values-comma-separated-using-excel/" updated: "2026-10-05" category: How to --- # How to Import an ACF Custom Field with Multiple Comma Separated Values Using Excel To import an ACF field that holds several values, such as a checkbox, put the values in one Excel cell separated by the **Separator for multiple values import** (a comma by default). [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/) at **WPFactory > Product Import/Export** saves them as a list, the format ACF uses for these fields. ## Before you start - WooCommerce, active. - Advanced Custom Fields installed, with a field group that includes the multi-value field (for example a checkbox). - At least one product already saved with that ACF field filled in, so the plugin can detect the field. Custom field detection also requires **Import / Export Custom Fields (deactivate if you see any issues)** set to **Yes** in **WPFactory > Product Import/Export** > **Settings** > **Main**. ## Step by step 1. In your Excel file, add a column for the ACF field and enter the multiple values comma separated in each product row, for example `red,blue,green`. Use the ACF choice values, not the labels, if they differ. 2. Save the file as `.xlsx`. 3. Open **WPFactory > Product Import/Export**, stay on the **Import/Update Products** tab, and upload your file. ![Uploading an Excel file on the Import/Update Products screen](https://wpfactory.com/wp-content/uploads/woocommerce-product-import-excel.png) ## Map the ACF column On the mapping screen, find your Excel column in the **EXCEL COLUMNS** section and map it to the matching field in the **CUSTOM FIELDS** section, either by drag and drop or with **Auto Match Columns**. The field appears under its ACF field name. ## Run and verify Press **Upload** to run the import, then open an imported product and confirm the ACF field holds the correct values. ## How values are saved - A cell that contains the separator is split and saved as a list. A cell without it is saved as a single value. - Web addresses are never split, even if they contain the separator. - Empty cells are skipped, so they do not clear an existing value. - For ACF image or gallery fields, list the field names in **Settings > Main > Img/Gallery ACF - custom fields**, then put image URLs in the cell. The images are downloaded and attached. ## If it does not work - **The field is not in CUSTOM FIELDS:** no product has that field saved yet, or **Import / Export Custom Fields (deactivate if you see any issues)** is not **Yes**. Fields whose key starts with an underscore are hidden; add them in **Manually add custom field**. - **Only one checkbox is ticked:** the values are not separated by the configured separator, or the values do not match the ACF choices. - **Text values are split by mistake:** set a different separator, such as `|`, and use it in every multi-value column. ## FAQ ### Can I export ACF fields to Excel too? Yes. Detected custom fields, including ACF fields, can be ticked on the **Export Products** tab. ### Can I import ACF field groups or options pages? No. The plugin imports product field values, not ACF field group definitions or options page data. ### Which separator should I use? The value in **Separator for multiple values import**. If it is empty, a comma is used. Related: [Import WooCommerce Products with Custom Fields and ACF](https://wpfactory.com/docs/how-to-import-woocommerce-products-with-custom-fields-like-acf-with-excel/) and [Product Import and Export Settings Reference](https://wpfactory.com/docs/product-import-export-settings-reference/). ### Get the most from Products Import & Export with Excel [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/) detects ACF and other custom fields automatically and imports or updates them alongside your products. [See everything it can do](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/). Need a hand? Our team answers every ticket on the [Products Import & Export with Excel support forum](https://wpfactory.com/support/item/woocommerce-products-import-export-with-excel/). Related articles - [How to Import WooCommerce Products with a Comma in an Attribute Term Value](https://wpfactory.com/docs/how-to-import-woocommerce-products-in-bulk-with-comma-in-attribute-term-value/) - [How to Import WooCommerce Subscriptions with Excel](https://wpfactory.com/docs/import-woocommerce-subscriptions-with-excel/) - [How to Import Category Terms, Attributes, and Brands with Excel](https://wpfactory.com/docs/import-product-terms-attributes-brands-with-excel/) - [How to Import Affiliate and External Products with Excel](https://wpfactory.com/docs/import-affiliate-external-products-with-excel/) - [How to Bulk Import WooCommerce Product Translations with Excel for WPML](https://wpfactory.com/docs/how-to-bulk-import-woocommerce-product-translations-with-excel-for-wpml/)