How to Export and Import Advanced Custom Fields

  • Blog
  • How to Export and Import Advanced Custom Fields
Import-ACF-fields-into-WordPress.png

Nowadays businesses understand the importance of website development and it acts as a catalyst for their business. Nearly 60 million websites are developed in WordPress and it requires a lot of posts, pages, contents, custom fields to reach audiences. Some organizations frequently update their content on the website. Creating your own custom fields for custom data management in your WordPress website made easy with the Advanced Custom Field plugin. It takes full control of your edit screen.

Creating custom fields for the first time and assigning the created Advanced Custom Fields to Post, Page, Custom Post, Users, and WooCommerce Products takes less time. But the real headache starts to creep up only when you plan to push the content into the created advanced custom fields in your WordPress Website. To make this complex data entry process into a simple one, We at Smackcoders Technologies Private Limited developed the plugin WordPress CSV/XML Importer plugin. WP CSV/XML Import plugin makes it easier to import and export the Advanced Custom Fields data. You can also automate the import process via the schedule function using the WP Ultimate CSV/XML Importer.

WordPress Ultimate CSV/XML Importer and Exporter plugin let you import, update and export the Advanced Custom Fields data assigned under the Post or Page or User or Custom Taxonomies or Custom Posts or WooCommerce Products. Advanced Custom Fields Free and Pro plugins are supported using the WP CSV/XML plugin.

Complex field types like Group field type, Repeater fields, and Google
Map field data get imported updated using the WordPress CSV Importer and
Exporter plugin.

Text Field:

Single line content comes under text field. For example, WP Ultimate CSV importer

Text Area Field:

You can add paragraph content in the text area field. Example WordPress Ultimate CSV Importer is an import tool that allows you to import CSV/XML data into the WordPress website. You can either import new data or update existing data in your WordPress website.

Number Field:

Any numeric data can be added in this field. Example for number field is 0123456789

Range Field

You can upload any range of values Ranges from or to 100.

For an illustration the price of a WP ultimate CSV importer is from $199. You have to provide input as $199.

Email Field

Use the standard email format. It should have @ and dot(.). For example [email protected]

URL Field

Upload specific links to a page, content, product or URL’s. Example is https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html

Password

You can put any text values in the password. A password may be numeric, alphabets or includes special characters. An example for the password field is [email protected]!32

Wysiwyg Editor

Any type of text values are supported in the Wysiwyg editor field. For example You have to provide in CSV format as
WP Ultimate CSV Importer

Image

In the image field you have to add the URL of the external image or the WP media gallery image. Example for image field is https://cdn.smackcoders.com/wp-content/uploads/2018/08/web_development_home_page.png

File

Specify the file path in your WordPress Media gallery. External URLs are not supported.
An example is
https://cdn.smackcoders.com/wp-content/uploads/2018/08/web_development_home_page.png

oEmbed

This field accepts or mentions the youtube video URL.

Example https://www.youtube.com/watch?v=6tdiOjw4EDk

Gallery Fields:

You can import your photos or gallery field images from the WordPress media library or from the external image URL. You can specify the URL in comma(,) separation in your CSV with the field name as the header to automap the field. For the image in the media library, you can also specify the media ID.

 Example
https://cdn.smackcoders.com/wp-content/uploads/2018/08/mobile_app_development_home_page.png

Select

Provide the values of your select option to select the desired one. Multiple values are selected by using Comma(,) separation. For Example:

Checkbox

Provide the checkbox values in your CSV file. To enable multiple checkboxes to provide the values in Comma(,) separation. An example

In CSV Format:
Custom Field Importer, Premium

Radio Button

Specify the radio button value to be selected. For an illustration

In CSV Format:

Premium

Button Group

Specify the button value to be selected. For example

In CSV file format:

Premium

True/ False

Specify the desired value. For example

but in CSV Format you have to provide as

Link

Specify your Post or Page or any external link. In CSV file provide link as


https://www.smackcoders.com/wp-ultimate-csv-importer-pro.html

Page Link

Specify your WordPress page URL. Mention multiple pages using Comma(,) separator.In CSV file provide page link as:

WordPress Leads Builder for any CRM

Post Object

Specify the Post ID. Multiple values are separated in Comma(,) separation.

To add post object as custom field importer, premium and WPML importer mention their ID in CSV file as
1,2,3

Taxonomy Field:

ACF taxonomy field can be created and assigned with the taxonomy values in comma(,) or pipeline(|) separation. If the value of the taxonomy doesn’t exist then the new taxonomy is created and assigned to the Post or Page.
CSV Format: To add tags CSV importer, Ultimate CSV importer provide values as csv importer, Ultimate CSV importer

Relationship Field:

Linking multiple Pages or Posts with advanced linking to another Post type can be done by relating to multiple post object data. You can mention the related Post or Page ID in comma(,) separation with the field name as the header in your CSV file to relate the CSV file with the created ACF field automatically . For example,

CSV Format: To relate Custom field importer and premium mention value as 1,2

Repeater Field

Repeating a section with the same set of subfields in ACF repeater fields can be automated to insert the data in each field type. Mention the value in comma(,) separation or pipeline(|) separation if the inserted field type has multiple values.?
For eg, if one of the field types is a checkbox and the field name is color, you can have the header as color to automap and the value as blue, black, red, or blue|black|red

User

Mention your User ID. To assign multiple users to mention the ID in Comma(,) separation.

CSV Format:

To select 101, 110, and 201. Provide values as
101, 110, 201

Google Map

Specify your exact geo-location with Geo Codes.

CSV Format:

Smackcoders Inc., Kattnayakan, Palayamkottai, Tirunelveli, Tamil Nadu, India|8.7149916|77.73236250000002.

Date Picker

Mention the date value in the standard format. DD/MM/YYYY

CSV Format:
29/12/2020

Date Time Picker

Specify the date(DD/MM/YYYY) and time(HH/MM/SS).

CSV Format:

29/12/2020 and 01:10:00

Color Picker

Mention your colors in Hex code.
CSV Format: #ffffff

Install WP ultimate CSV Importer

Import and Export Advanced Custom Fields from CSV in WordPress

Importing your ACF fields data into WordPress is simple and the same as you import posts usually using CSV Importer. The first thing you need to do is to install and activate the WP Ultimate CSV Importer plugin. Let’s take a look at the import and export of CSV files in WordPress using WP Ultimate CSV Importer.

CSV Preparation

Upon activation, you can simply go to ‘WP Ultimate CSV Importer → Import/Update’. Now you will prompt to upload your CSV file containing ACF field info in UTF-8 file format.

The WP Ultimate CSV Importer fetches ACF field info based on the columns in your spreadsheet. The first row must have the column names, and you can have the name of your choice and there is no restriction in naming the ACF fields.

You can download the sample ACF CSV file for your reference. And you can open it in Microsoft Office, LibreOffice Calc, or Google Docs. While downloading the CSV file, make sure you use the comma(,) to separate columns and the text delimiter is set to double quotes(“).

google-sheet-preparation

Import ACF Fields in WordPress from CSV

Before importing your CSV file you have to create a custom post type in the ACF plugin. In the ACF dashboard, click on create new where you have to create a custom template based on your needs in ACF. You have to assign the template for the post, page, or any other field. This allows ACF to get mapped with WP header fields.

Now you can import the CSV file by following 4 simple steps, import or update the existing content on your WordPress website.

Step 1: Uploading the CSV file

Upload your CSV in any of these 4 methods:

Then choose ‘New Items’ whether the CSV file contains new items to import or ‘Existing Items’ to update the website content.

acf-import-wp-ultimate-csv-importer.png

Step 2: Mapping the Header fields

Relate the CSV headers with WordPress fields. You can use the ‘Advanced Mode’ with dropdown or simply use the ‘Drag & Drop’ mode to match the CSV headers with WordPress fields.

wp-ultimate-csv-importer-acf-fields-mapping.png

Once you map the fields, give a name in the ‘Save this mapping as’ field to use this mapping as a template later. Then proceed to next with Continue. Skip the Featured media handling section if you don’t upload any images.

Know More: Documentation for CSV importer

save-mapping-wp-ultimate-csv-importer.png

Step 3: Importing the CSV file

Now import the content to WordPress. To commit safe importing, check the ‘Enable safe prostate Rollback(Backup before import)’ to get a backup before you import and it also rollbacks to the previous edition if in case an unexpected problem arises while importing.

Enable ‘Do you want to SWITCH ON Maintenance mode while import?’ to notify your website visitors that the website is under maintenance. You also check for duplicates while you import using the option ‘Do you want to handle the duplicate on existing records?’ and choose the WordPress fields to check duplicates for those fields.

Now choose the ‘Import’ button to instant import the content on your WordPress website or schedule the post to get an update in the future, that is, to update content on the website at the specified date and time. The custom field ACF info will update successfully in WordPress from CSV.

wp-ultimate-csv-importer-import-acf-fields-information.png

Export ACF Fields in WordPress as CSV

The ACF fields info in WordPress along with the Post, Page, or Custom Post can be exported as a CSV file for safe backup or migration in just 2 simple steps. In Step one, you can choose the Post Type and in the second step, give the export file name and select the export type as ‘CSV’.

‘Split the Record’ field mention the records number to export one by one like, if you give 100, the first 100 records will be exported in the first CSV and the next hundred records exported in the second CSV file, so on.

You can export records with advanced filters like ‘Export with auto delimiters’, ‘Export data for the specific period’, ‘Export with specific status’, ‘Export data by specific author’, and ‘Export data based on specific inclusions’, this lets you export data with specific fields.

wp-ultimate-csv-importer-export-data-as-csv.png

End Tips

WP Ultimate CSV importer supports ACF importer plugin. You can import or export 1000’s custom fields, post, page using CSV Importer Free or CSV Importer Pro version. WP Ultimate CSV importer documentation guides you to import/update/schedule or export the data. Contact us for clarification and enhancements.

© 2022 | All Rights Reserved | Smackcoders, Inc

Cookies help us deliver our services. By using our services, you agree to our use of cookies.