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 Smack@897!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
- 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
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
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.
- 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(“).
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.
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.
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
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.
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.
End Notes
WP Ultimate CSV importer supports ACF importer plugin. You can import or export more than 1000’s of custom fields, post, and page using CSV Importer Free or CSV Importer Pro version. All our premium plugins are now available as bundle packs for purchase. Check them out now!
For more detailed information check the WP Ultimate CSV importer documentation to import/update/schedule or export the ACF fields data. Contact us for any help and also please share your feedbacks with us without any hesitation.