How to Export and Import Advanced Custom Fields

Nowadays businesses understand the importance of website development and it acts as a catalyst for their business. Nearly 60 million websites were 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 taking full control of your edit screen. But importing the fields manually and assigning them to Post, Page, Custom Post, Users, Products, etc takes time.

Import-ACF-fields-into-WordPress.png

You can also be automated to make it much easier using WP Ultimate CSV Importer. It can import Post or Page with advanced custom fields(ACF) data from CSV into WordPress. It has been integrated with both the Free and Pro version of ACF with support for all the fields.

The import is not only limited to the below-mentioned fields, you can import & export all the fields of ACF free and PRO. You can upload different types of content format in the Advanced Custom Field (ACF) importer.

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 $99. You have to provide input as $99.

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

    * Import/ Update
    * Instant/ Scheduled import

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:

  • Custom Field Importer
  • Premium
  • WPML importer

  • In CSV Format: Custom Field Importer, Premium, WPML importer

    Checkbox

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

    • Custom Field Importer
    • Premium
    • WPML importer
    In CSV Format: Custom Field Importer, Premium

    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

    Radio Button

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

    • Custom Field Importer
    • Premium
    • WPML importer
    In CSV Format: Premium

    Button Group

    Specify the button value to be selected. For example

    • Custom Field Importer
    • Premium
    • WPML importer
    In CSV file format: Premium

    True/ False

    Specify the desired value. For example

    • if it is True- 1
    • if it is false- 2
    but in CSV Format you have to provide as 1

    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:
    https://www.smackcoders.com/wp-leads-builder-any-crm-pro.html

    Post Object

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

    • Custom Field Importer
    • Premium
    • WPML importer
    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,

    • Custom Field Importer
    • Premium
    • WPML importer
    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

    • Purchase the WP Ultimate CSV importer plugin from Smackcoders.
    • In your WordPress website click on the Plugin menu on the right side.
    • Add new→ Upload the plugin from desktop→ Install and activate the plugin.

    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:

    • A Upload from Desktop
    • Upload from FTP / SFTP
    • Upload from URL
    • Choose File in the Server.

    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.

    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 Trial version or Pro version. Ultimate CSV importer documentation guides you to import/ update/ scheduled or export the data. Contact us for clarification and enhancements.

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