Wait!

Lifetime licenses are only available for a short time, don't miss out!

Any File Type

No need to reorganize your data, just upload your file to WP All Import and it'll sort it out.

Complete Customization

Granular control over every single piece of data. Think your import is too complicated? Think again.

Import Huge Datasets

It doesn't matter how big your site is or how much data you need to import, WP All Import can handle it. 

Multilingual Imports

Importing data to multilingual sites has never been easier, with support from the WPML team.

Scheduled Imports

Run imports automatically on a schedule. Subscribe to our point and click scheduling service, or set up cron jobs.

Developer Friendly

Write and test PHP right inside WP All Import when setting up your import, with tons of snippets to get you started.
@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."
90-Day Guarantee
Not 100% happy? Let us know and we’ll promptly send you a refund.
Free Updates For Life
Pay once for unlimited installs, even client sites. No renewal fees.
Fast, World Class Support
Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How to Import Any CSV, XML, or Excel File into 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.

This documentation covers how to import into WordPress using WP All Import. For a broader look at importing into WordPress, check out:

Step 1: Upload Your WordPress Import File

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.

WordPress Import - Upload Import File

Step 2: Review Your Import Data

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.

WordPress Import - Review Import File

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.

WordPress Import - Drag and Drop to Configure Import

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.

WordPress Import - Import Settings

Click Continue at the end to run your WordPress import.

Step 5: Confirm & Run Your WordPress 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 - Import Complete

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:

  1. Click on Add Filtering Options
  2. Select the Element to filter from
  3. Select what Rule to use
  4. Assign a Value to match using the selected rule
  5. Click on Add Rule
  6. Click on Apply Filters To XPath
WordPress Import - Add Filtering Options

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:

  1. Start the process of creating a new import (with the same import file used by the import you want to modify filters for).
  2. 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.
  3. 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).
  4. Exit the import process & navigate to the Manage Imports page. Click on the Settings link for your import there.
  5. 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).
  6. 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:

  1. 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.
  2. Input a name as the Template name.
WordPress Import - Save Import Template

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:

  1. When in Step 3, scroll all the way down and locate the template section.
  2. Select the desired import template from the Load Template drop-down list.
  3. 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 to Import My Website into WordPress?

First, you need valid import files for all of the posts or custom post types to be imported. If you don't have them yet, you can generate those files using WP All Export. Then just import your data into WordPress by following the step-by-step process described in this tutorial.

Does My Data Have to be Specially Organized for WordPress Imports?

Not when you're using WP All Import. Our Drag & Drop interface allows you to map incoming data elements to any WordPress or WooCommerce target fields. You can even modify the incoming data as part of the import process.

How to Import XML into WordPress?

There are only a few differences when importing XML into WordPress versus other file types. First, you must have a valid XML file. WP All Import will recognize the file as XML and will automatically adjust its interfaces accordingly. Otherwise, the import process is basically the same.

Can I Import WooCommerce products?

Yes. WP All Import is completely integrated with WooCommerce and offers full support to import WooCommerce orders, customers, and all aspects of products including categories, variations, images, prices, and stock levels. If it's in WooCommerce, we've got you covered.

Can I Use WP All Import On All of My WordPress Sites?

Yes. WP All Import and WP All Export come with unlimited licenses, which 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.

How to Export a WordPress Site?

  1. Go to All Export › New Export and select what post type or custom post type to export.
  2. Drag and drop to create the export file, then configure the export as required.
  3. Run the export and download the exported file.
  4. Review the export file's contents.

For further instructions, please see How to Export WordPress to CSV, Excel, and XML.

Related Docs

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.

Related Videos

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross