WP All Import – XML, CSV & Excel Import

Go to All Import › New Import.
Upload the import file.
Choose the import post type.
Map the incoming data elements to the WordPress fields.
Complete the import and verify the imported data.

Can I import any WordPress post type?
Yes. You can import any standard WordPress post type, including posts, pages, categories, tags, users, comments, and images. You can also import custom data from third-party themes and plugins.
How does WordPress import work?
The default WordPress import tool uses a brute-force approach that often imports all or nothing. WP All Import is a lot more flexible and lets you filter, modify, and map incoming data elements so that you can import your data exactly as you want it.
Does my data have to be specially organized for WordPress imports?
Not when you use our plugins. Our Drag & Drop interface lets you map incoming data elements to any WordPress field. You can even modify the incoming data as part of the import process, so we can handle a wide variety of import layouts.
How do I import a CSV file into WordPress?
To import a CSV file into WordPress, just specify the CSV file as your import source. WP All Import will automatically recognize the file type and adjust the interface accordingly. You don’t need to do anything special to handle the CSV format.
How do I import XML data into WordPress?
To import XML data into WordPress, just specify the XML file as your import source. WP All Import will automatically recognize the file type and adjust the interface accordingly. You don’t need to do anything special to handle an XML file.
How do I import Excel data into WordPress?
To import Excel data into WordPress, just specify the Excel file as your import source. WP All Import will automatically recognize the file type and adjust the interface accordingly. You don’t need to do anything special to import WordPress Excel files.
Can I import Google Sheets to WordPress?
Yes. WP All Import includes an option to download a file from an external URL. You can add your WordPress data to a Google Sheet, copy its URL, and then paste the sheet's URL into WP All Import.
How do I import large files into WordPress?
To import large files into WordPress, you can use our advanced settings to split the import into manageable chunks, modify the batch processing size, and take several other steps to either speed up the import or reduce its impact on the server.
How do I import data into a WordPress custom plugin?
Our plugin automatically recognizes many WordPress custom plugins and themes, so just select the custom post type, and away you go. If a custom plugin stores its data in an unconventional manner, just contact our support staff for further guidance.
Can I use WP All Import on all of my WordPress sites?
Yes. Our plugins come with unlimited licenses, so you can install them on all of your own websites.
Can I import WooCommerce customers, products, and orders?
We have special add-ons for all types of WooCommerce data, so you can import WooCommerce customers, orders, products, reviews, and anything else WooCommerce has to offer.
How do I import WordPress posts as a draft?
In Step 3 of the import process, under Other Post Options, change the Post Status to Draft. This ensures that all imported posts will be created as drafts.
How do I import images into WordPress?
In the Drag & Drop screen, map the incoming image elements to the appropriate fields in the Images section. The tricky part about images is that they can have many different sources, including URLs, images that are on your computer, images that are already on your server, and even images that are already in your media library. To understand how to handle each of these scenarios, see our documentation.
How do I import a featured image into WordPress?

Create a standard WordPress import.
In Step 3, add the images element in the Images section.
Check the Set the first image to the Featured Image (_thumbnail_id) option.
Complete the import.
Verify that the featured image(s) were correctly imported.

Export the WordPress data that you wish to migrate.
Download the Bundle option, which includes import instructions.
Import the bundle file on the target site.
WP All Import will use the bundle file to automatically configure itself.
Run the import and review your migrated data.

Export the WordPress data that you wish to edit.
Edit the export file in your favorite spreadsheet app.
Use the Import with WP All Import option to configure your import.
Run the import.
Review the affected data to make sure the changes were applied.

How do I get support?
If you are using the free version of the plugin, you can obtain support through the WordPress.org community forums. If you have purchased the premium version, you can email us directly and we will respond as quickly as we can, typically in less than one business day.