Import source files into WordPress

WP All Import Pro is a paid upgrade for importing XML, CSV, Excel, and Google Sheets data into WordPress. Its four-step process uses drag-and-drop field mapping, so source files do not need a particular layout. Use it for tasks such as migrating content from a legacy CMS, loading affiliate data feeds, or maintaining real estate listings, stock quotes, and sports scores.

Map data by format

CSV imports use the same general process as XML imports because WP All Import converts CSV data to XML internally. XPath filtering is available for CSV, and columns can use different headings. Specify another delimiter when a file does not use commas. If special characters cause import problems, use UTF-8 encoding. Excel columns are detected when a spreadsheet is uploaded. For Google Sheets, select the “Download a file” option and provide the sheet’s public URL.

Pro import features

• Custom fields: Map incoming data to fields used by themes and Custom Post Types.
• Images: Download images from URLs in XML or CSV files and add them to the post media gallery.
• External files: Download CSV, XML, or Excel data files from external websites, including sources protected by HTTP authentication.
• Recurring imports: Use cron jobs to check external files for updates. Imports can add, edit, or delete imported posts according to changes in the source data.
• Custom PHP functions: Run functions on imported data using expressions such as [my_function({xpath/to/a/field[1]})].
• Email support: The Pro edition includes guaranteed technical support by email.

Connect export and import processes

WP All Import integrates with WP All Export. Export WordPress posts, WooCommerce products, orders, customers, or other data, edit it in Microsoft Excel, Numbers, or another application, then re-import it to the same website or move it to another WordPress website. WooCommerce XML and CSV imports require a separate WooCommerce add-on.

Set up an import

Install WP All Import Pro on the site receiving the data, choose an XML, CSV, Excel, or Google Sheets source, then follow the four-step process and map fields with drag and drop. Configure any needed custom fields, images, external access, recurring schedule, or custom PHP functions before running the import.