WordPress: How to Import and Export

Millions of businesses are using WordPress websites. Frequently they are updating their posts, pages. Thousands of posts were published by each business.
Are you one of them? To add and publish it manually takes a lot of effort and time, right. This can get replaced by a WP ultimate CSV importer, which can import all your post data in a CSV file and update it in the post section of your WP Dashboard. It also allows you to export data in a few clicks.

how-import-and-export-wordpress.jpg

Features of WP Ultimate CSV Importer

  • Import/update or schedule and Export your data
  • Bulk products import for WP-eCommerce plugin
  • Bulk import of e-shop products into its plugins
  • Custom Taxonomy upload
  • External URLs like a google sheet and dropbox get supported.
  • Multilingual and other third party plugins were supported
  • Nested Categories import.

And more flexible features like the update, delete already uploaded post on single click and duplicate detection, etc. Please refer to relevant posts for the detailed features of PRO Version of Ultimate CSV Importer.

How to install ultimate CSV importer plugin in WordPress

Wp Ultimate CSV Importer is very easy to install like any other WordPress plugin. No need to edit or modify anything here.

  • Unzip the file ‘wp-ultimate-csv-importer.zip’.
  • Upload the ‘ wp-ultimate-csv-importer ‘ directory to ‘/wp-content/plugins/’ directory using FTP client or upload and install
    wp-ultimate-csv-importer.zip through plugin install wizard in wp-admin panel
  • Activate the plugin through the ‘Plugins’ icon in WordPress.
  • After activating, you will see an option for ‘Wp Ultimate CSV Importer’ in the admin menu (left navigation) and you will import the CSV files to import the data.

A plugin that turns your offline data into WordPress post, page, or custom post data by a simple mapping feature as a CSV file import. Let’s discuss How to import data from an existing CSV into WordPress as Page, Post, or any Custom Post Types using the WP Ultimate CSV Importer plugin in seconds. Try for Free wordpress.org

How to import Data into WordPress?

WP Ultimate CSV Importer Plugin helps you to import any CSV file as a post, page, or even as a custom post type. Convert your offline database maintained for years into your valuable website content. Also do periodical content changes, maintenance, content update, prices, offers, coupons, and inventory, etc.

Pre-Import Checklist

After the installation of the WP Ultimate CSV importer plugin in your WordPress, now check for the minimum requirements for file import. Click on the settings module in "Ultimate CSV Importer" and move to the 'Security and Performance' section.

ultimate-csv-importer-settings-performance

System Values - The storage limit of your website server. It varies based on the server. You can’t import files more than this value. If you want to increase your memory size for bulk import, then you need to change the values in your php.ini file.
Minimum Requirements- The values are the least data import requirement.

Types of Import File Format:

WP Ultimate CSV importer allows you to upload four different file formats.

  • Comma Separated Values (.csv).
  • Extensible Markup Language (.xml)
  • Text Files (.txt)
  • ZIP Files(.zip)

CSV importer support only supports five delimiters. They are comma(,), tab space( ), pipeline(|), semicolon(;) and colon(:).
In the Zip file, you can upload other file formats. For example, you can provide 4 CSV files, 2 XML files, and 3 text files. But you have to choose the exact file while importing.

Validate your CSV and XML file

To avoid cell alignment issues while importing, validate the CSV file using CSV LINT. If your file passes the validation, then you can import the file using csv importer.
Validate the XML file by XML Validator. Upload the file if it passes the validation.

Precaution

There are two methods we are suggesting before importing your files to WordPress using our plugin, you need to manually create a CSV or XML file and test import with our plugin.

Manual Creation: Before importing just update your post or page manually. When you are using custom field plugins, verify whether your data are updated on your website. If it gets updated then process the next step.

Test Import:  In test import, just import a CSV file with respective columns since you can update columns in the existing template.  For test import, upload your CSV file with 1 row.  If it successfully uploaded, then process bulk import.

Errors While Uploading

Unsupported File Format:

If you upload other than these file formats an error message will appear as “Unsupported File Format”. When this bug arises, try changing your file format in the above-mentioned file types.

Unsupported Character Encode Type

WP Ultimate CSV importer doesn’t allow other encoding options, use UTF-8 without BOM. To avoid this error, try the below steps.

Notepad++ to Re-save Character:   Open the file in notepad++ → In the taskbar click on Encoding → Encode in UTF-8 Format → Save the file

Google Sheet to Solve: Upload the file in Google sheet and then download the file as CSV. 

File Upload Error

When you upload the CSV or XML file in the WP Ultimate CSV file, it will perfectly import it. If any issues arise in uploading the file, in that case, go to php.ini file, search “file_upload” and turn it ON from OFF. Similarly, when the error occurs while uploading a ZIP file, “enable ZIP” extract in your server.

PHP Memory Limit Error

PHP allot a default memory for processing a website. When you upload more than this, it will display an error message. In that case, you have to increase the memory to fit this. To do this, go to the php.ini file and increase the memory limit.

Post Max Size Error

post_max_size should be equal to or greater than upload_max_filesize. When you are uploading a CSV file if the cell value is more than post_max_size, an error will occur. In this case, try to increase the post_max_size in the php.ini file.

Upload file size error

Upload_file_size should be less than or equal to upload_max_filesize in the php.ini file. If this error occurs while uploading the file in WP ultimate CSV importer, resolve it by changing the value in the php.ini file.

Import CSV file into WP Ultimate CSV Importer.

Step 1: Upload your file

You can upload your data in four standard formats ie.) CSV format, XML file, text format and zip file. You can upload it in 4 different location from desktop, FTP/ SFTP, using publicly accessible URL or from server- already exist in WordPress

ultimate-csv-importer-wpimport-browse-file-from-desktop.png

Step 2: Automatically map headers

Auto mapping is a hands-free mapping feature introduced from version 3.0.0. Just replace the CSV headers with relevant auto map headers and save it to use as a template CSV file. WordPress Ultimate CSV Importer Plugin can identify these headers and automatically map your fields with relevant WordPress fields. This feature will almost eliminate the pain of mapping each and every time, in particular with many no. of fields. There are two types of mapping headers: Advanced Mapping and Drag and Drop

How to use advanced mapping features?

For a simple import post title and content is sufficient to create a successful import. All other fields are optional that set to default as in WordPress. To have more control over it, as in the above image you can add more fields in CSV as prescribed for WordPress Ultimate CSV Importer Plugin. You can add post_excerpt, post_status, post_author, etc as the below-listed format

Advanced-Mapping.png

In the drag and drop mapping method, you have to drag the title and merge it with the WP header field like the image shown below.
Read more on WP ultimate CSV importer Documentation

drag-n-drop-mapping.png

Step 3: Media Handling

In media handling, you can perform image optimization for SEO and you can download external images for your needs.

ultimate-csv-importer-wp-import-media-handling.png

Step 4: Import Configuration

In the import configuration section, you have 4 different process

  • Enable the rollback option, if an error occurs in the middle of the upload. You can commit and roll back to retrieve the data
  • Enable maintenance mode if you have to let your visitors that you are undergoing some changes in your website
  • Enable duplication, if you have to check that any duplication data in the file content.
  • Enable schedule, when you have to update content based on time and page.
Wp-Ultimate-Csv-Importer-Configuration.png

Scheduling

Scheduling is used when you are uploading 1,00,000+ records, as it takes a lot of time. In this period, you can just mention the time-stamp and date to upload the record. It will automatically upload the file at the time. You can also upload multiple documents at a time. At this time, the CSV importer uploads files based on the “Queue” format. The first uploaded file gets imported then the next and so on.

How to Export Data into WordPress?

You can export the CSV files using the export option in wp ultimate CSV importer plugin. If your CSV file was lost or deleted that you have already imported, then use this export option to regain your CSV file without any flaw. To export a CSV file select the “Export” option in the menu bar of WP ultimate CSV importer. On the export page, select any one of the options/modules that you want to export. Suppose, if you forget to choose any one of the options and clicking the proceed button, an alert message will be displayed.

“Custom post” and “Custom Taxonomy” options have a drop-down box nearer to them. Select any one of the options for a custom post or custom taxonomy that are listed in the drop down menu. If you select “Custom Post” or “Custom Taxonomy” and you didn’t select any options that are listed in the drop-down menu then the downloaded CSV file will have only the headers. Click the “Proceed” button to continue.

export-data-as-csv.png

On the export filter page, we are providing five options to export the CSV file. Those options are:

  • Export data with auto delimiters
  • Export data for a specific period
  • Export data with the specific status
  • Export data by specific authors
  • Export data based on specific exclusions

Export data with auto delimiters

To export the data based on the delimiters, enable this option. Some of the delimiters are listed. The listed delimiters are the colon (:), comma (,), semicolon (;), Tab, and Space. If you want to use additional delimiters then specify it in the “Other Delimiter” box.

Export data for the specific period

To export the CSV file that was imported in a particular period, use this option. Specify the start and end date in the particular boxes.

Export data with the specific status

This option will filter the data according to the status such as publish, sticky, private, protected, draft, pending. If you need data according to the authors. Choose the specific author in the “Authors” using the drop-down menu.

Export data based on specific exclusions

This option is used to filter data based on the particular headers of the CSV file. If you want the entire data without filtration then don’t enable any of the checkboxes. In the “File Name”, enter the name of the downloadable file.
Click “Export” to proceed. Wait until the file is downloaded successfully.

Wrapping Up

WP ultimate CSV importer allows you to import/ update or export your post, page or custom post data from WordPress website. Get your pro version for scheduled updates and other features. For clarifications and support contact us

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