How to Import Any CSV, XML, or Excel File to WordPress
Setting up a WordPress import for thousands of posts is very similar to manually creating a post in WordPress. You create a template for your posts that WP All Import uses when importing your data. To set or add data from your import file to your import template, you simply drag and drop it.
Here's a video showing how WP All Import works in-depth:
Continue reading below for text instructions.
Step 1: Upload Your File to Create WordPress Import
The first step to creating a WordPress import is to upload your import file via All Import › New Import. You can choose to upload the file from your computer, paste in a URL to the file, or choose an existing file that you've already used with WP All Import.
Next, choose either New Items or Existing Items. If you are importing data from your file into posts that are already on your site, select Existing Items. Otherwise, select New Items.
Finally, you need to decide what you want to import. You can import Posts, Pages, Taxonomies, Users, or custom post types added by other themes and plugins like WooCommerce Products.
Step 2: Review Your Data in WordPress Import
WP All Import will process your file and prepare it for import. If you uploaded a CSV, check that the correct delimiter was used. When you upload an XML file, check that the correct node is selected.
If you only want to import some of the records in your import file, you can Add Filtering Options.
Click Continue to Step 3 to carry on with your WordPress import.
Step 3: Configure Your WordPress Import
Every column or element from your import file will be displayed on the right. On the left, you have your import. WP All Import will create posts using the import template you create here. Simply drag your WordPress import data from right to left. You can fill in as many or as few of the fields as you like depending on your needs.
Step 4: Choose Which Data to Update
Here you can tell WP All Import how to handle each specific piece of data. For example, you can have it only add new images to posts, or just update the stock and price for your products.
You can also configure this import to run on a schedule and other advanced options.
Click Continue at the end to run your WordPress import.
Step 5: Confirm & Run Import
Now it's time to run your import. You will see an Import Summary section where you can review all import settings and a description of what will happen. To run the import, click on Confirm & Run Import.
Once the import is complete, you'll see an Import Complete! message.
WordPress Import – Advanced Topics
Add Filtering Options to Control WordPress Import
You can import WordPress data granularly using WP All Import with its visual built-in filtering options. This is done in Step 2 when reviewing the WordPress data to import. Here's what to do:
- Click on Add Filtering Options
- Select the Element to filter from
- Select what Rule to use
- Assign a Value to match using the selected rule
- Click on Add Rule
- Click on Apply Filters To XPath
You can learn more about filtering here: Filtering with XPath.
Modify Filtering Options on Existing WordPress Import
Modifying the filter for an already existing import is not possible out of the box but it can be achieved using this workaround:
- Start the process of creating a new import (with the same import file used by the import you want to modify filters for).
- In Step 2, set up the desired filtering rules inside of the Add Filtering Options panel, as explained above in the Add Filtering Options to Control WordPress Import section.
- Once you have set the filters correctly, copy the code in the XPath field (put the code in a safe place such as a note).
- Exit the import process & navigate to the Manage Imports page. Click on the Settings link for your import there.
- Once there, expand the Configure Advanced Settings section & note down what's currently in the XPath field there (as a backup in case it doesn't work with the new XPath code).
- Finally, insert the new XPath filtering code and save your import settings.
Saving or Using a Saved Import Template
WP All Import provides full control over the WordPress import process. This means that there's also a way to save the existing import template and settings to apply to a different/new/future import process. To save an import template, do the following:
- While in Step 3 (as shown in this guide above), scroll all the way down and click to enable the Save settings as a template option.
- Input a name as the Template name.
That's it! The template will be saved once you continue to the next step or save/update the template.
To load a saved template, do the following:
- When in Step 3, scroll all the way down and locate the template section.
- Select the desired import template from the Load Template drop-down list.
- Once selected, the page will reload and apply all import mappings and settings.
You can manage saved import templates via All Import › Settings › Import/Export Templates.
Scheduling an Import to Run Automatically
You can schedule your WordPress import using WP All Import and its built-in options. Here's what you can do:
- Use manual cron jobs: these can be configured via your web server and allow total manual control to run the import in a schedule. See Manual Scheduling.
- Use Automatic Scheduling Service: this is an optional and paid service that comes built-in with WP All Import. It allows you to configure automatic imports directly from within its interface. See Automatic Scheduling.
Frequently Asked Questions
How Do I Export a WordPress Site?
Exporting data from your WordPress site is very easy with WP All Export. Here's what to do:
- Go to All Export › New Export and select what post type or custom post type to export.
- Continue the export process, drag and drop to create the export file, then configure the export as required.
- Run the export and download the exported file.
For further instructions, please see How to Export WordPress to CSV, Excel, and XML.
Can I Import My Website into WordPress?
Yes. You would need valid import files for all of the posts or custom post types that will be imported. If you don't have them yet, those files can be generated using WP All Export.
Then, use WP All Import to import your data into WordPress by following the step-by-step process described in this tutorial.
Can I Use WP All Import On All of My WordPress Sites?
Yes, WP All Import and WP All Export come with unlimited licenses, this means that you can make unlimited installations on any number of your own websites. You can read and review the full license agreement here: www.wpallimport.com/license.
Learn to export your WordPress data to a CSV, Excel, or XML file with WP All Export.
Learn how to migrate data to a different site using WP All Import and WP All Export.
Learn to bulk edit your WordPress data with WP All Import and WP All Export.