Wait!

Lifetime licenses are only available for a short time, don't miss out!
People Love WP All Import 
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@glitzformals
"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!"
@adatfalo
"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."
@jessedw44
The Powerful Features You Need

Any File Type, Any File Structure

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 Amounts of Data

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 with WPML

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

Scheduled WordPress 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.
90-Day Money Back 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

Export WordPress Data to a Custom Spreadsheet

To create a new spreadsheet export go to WP All Export › New Export and select the type of posts to export. Drag and drop to select your data, rearrange columns, rename them, and customize your file. There are three types of spreadsheets available: CSV, Excel (XLSX), and Excel (XLS).

CSV WordPress Exports

Go to Export Type › Spreadsheet and select CSV File from the drop-down.

CSV stands for Comma Separated Values. Data is stored in plain text, with commas separating each column. CSVs are the most flexible and widely used type of spreadsheet. They can be opened and edited in any text editor, as well as spreadsheet software like Excel, Google Sheets, Numbers, and LibreOffice:

The posts you export will each be on their own row in the CSV file. Each export element will appear as a column in your CSV file. If the data has spaces or line breaks, WP All Export will automatically wrap the value in quotes to make it valid. Keep in mind that data with line breaks may look broken if you open the file in a text editor, but it's not. The quotes allow spreadsheet software to put all of the line breaks and spaces in a single column.

In the Advanced Options section, you can change the delimiter from commas to something else for your CSV file, and you can choose whether or not you want to include the header row.

Excel WordPress Exports

When creating a new export you can choose Excel (XLS) or Excel (XLSX) as the file type. This file type is specifically for Excel and the data is not stored in plain text.

Just like CSV exports, each record will be stored as a row and each export element will be a column in your file.

Customizing Your Spreadsheet

When exporting your WordPress data to Excel or CSV, you can add elements by dragging them in from the Available Data section on the right:

You can also add individual fields, add all fields, clear fields, and preview the export using the buttons below the export template box.

After adding fields, you can drag and drop them to arrange the columns in any order that you'd like. If you want to remove an export element, simply drag it out of the export box and drop it.

To change the column name, click on a field that has been dragged into your export to access the Edit Export Field modal:


Drag and drop to export WordPress data to XML.

Use a powerful templating engine to create custom WordPress XML exports.

Learn more about the different types of WordPress data you can export.

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