WP Ultimate CSV Importer – WordPress CSV, XML & Excel Import

WP Ultimate CSV Importer is a powerful WordPress import plugin for importing data from CSV, XML and Excel files into WordPress.

Bulk import posts, pages, custom post types, users, WooCommerce products, images, taxonomies, custom fields, ACF fields and other WordPress data without manually creating records one by one.

Whether you need to import a CSV into WordPress, upload thousands of WooCommerce products, migrate content from another CMS, import an affiliate product feed, populate custom post types, or transfer data from spreadsheets into WordPress, WP Ultimate CSV Importer provides a visual field-mapping workflow without requiring code.

Prepare your data using Microsoft Excel, Google Sheets, LibreOffice, CSV, XML or other spreadsheet/data tools, upload your file, map the source columns to WordPress fields, validate the data and run the import.

What Can You Import Into WordPress?

WP Ultimate CSV Importer can import:

• WordPress posts
• WordPress pages
• Custom post types
• WooCommerce products
• WordPress users
• WooCommerce customers with the free add-on
• Categories
• Tags
• Custom taxonomies
• Custom fields and post meta
• Advanced Custom Fields (ACF)
• JetEngine fields and Custom Content Types
• MetaBox fields
• Pods fields
• Toolset Types fields
• Featured images
• Product images and galleries
• Media library files
• SEO metadata
• Multilingual content
• Affiliate product feeds
• Directory and listing data
• LMS content
• Membership data
• And more

Import files can be provided as CSV, XML, XLS, XLSX, TSV and other supported formats.

Import WooCommerce Products From CSV, XML or Excel

Need to bulk import products into WooCommerce?

WP Ultimate CSV Importer lets you map spreadsheet columns to WooCommerce product fields and import large product catalogs without manually creating products.

Import data such as:

• Product name
• Product description
• SKU
• Regular price
• Sale price
• Stock quantity
• Stock status
• Categories
• Tags
• Attributes
• Featured image
• Product gallery images
• Taxonomies
• Product metadata

Additional WooCommerce import capabilities are available through the free Import WooCommerce Suite add-on.

Install Import WooCommerce Suite

The WooCommerce add-on extends the importer for:

• Simple products
• Variable products
• Product variations
• Grouped products
• External / affiliate products
• WooCommerce orders
• WooCommerce customers
• WooCommerce coupons
• WooCommerce reviews
• WooCommerce refunds
• Additional WooCommerce data

Advanced operations, record updates and other resource-intensive WooCommerce workflows are available in WP Ultimate CSV Importer Pro.

Import CSV Files Into WordPress

Have data stored in a CSV file?

Upload the CSV file, choose the WordPress content type, and map each CSV column to the appropriate WordPress field.

You can import:

• Titles
• Content
• Excerpts
• Authors
• Publish dates
• Post status
• Categories
• Tags
• Taxonomies
• Featured images
• Custom fields
• SEO metadata
• Custom post types

The visual mapping interface allows you to connect your CSV columns with WordPress fields without writing PHP code.

Import Excel Files Into WordPress

WP Ultimate CSV Importer supports importing data directly from Excel spreadsheets, including XLS and XLSX files.

This is useful when your product catalog, customer list, content database or other WordPress data is already maintained in Excel.

Upload your spreadsheet, map its columns and import the records into WordPress.

Import XML Files Into WordPress

Import structured XML data into WordPress without manually converting the file to CSV.

XML imports can be mapped to:

• Posts
• Pages
• Custom post types
• WooCommerce products
• Categories
• Tags
• Taxonomies
• Custom fields
• Images
• Other supported WordPress fields

This is particularly useful when migrating content or consuming feeds supplied by third-party systems.

Import Google Sheets Data Into WordPress

You can import data from a publicly accessible Google Sheets CSV URL.

Publish the required Google Sheets tab as CSV, copy the public URL and use Upload from External URL in WP Ultimate CSV Importer.

This provides a convenient workflow for teams maintaining import data in Google Sheets.

Import WordPress Users

Bulk import WordPress users from CSV, XML or Excel.

Map fields including:

• Username
• Email
• First name
• Last name
• Password
• User role
• Display name
• User metadata

For additional WordPress user and WooCommerce customer metadata support, install the free Import Users & Customers with Meta add-on.

Install Import Users & Customers with Meta

Import ACF Fields From CSV

WP Ultimate CSV Importer integrates with Advanced Custom Fields (ACF).

The free plugin supports importing supported ACF field types including Basic, Choices, jQuery and WYSIWYG fields.

Advanced ACF fields such as repeaters, galleries, flexible content, relationship fields and additional complex field types are available with WP Ultimate CSV Importer Pro.

Import Custom Post Types and Custom Fields

Import data into custom post types created by WordPress themes, plugins or custom development.

Examples include:

• Events
• Property listings
• Business directories
• Job listings
• Portfolios
• Courses
• Membership records
• Classified listings
• Product catalogs

Map your source data to post fields, custom fields, taxonomies and supported third-party plugin fields.

Import JetEngine Data

WP Ultimate CSV Importer supports JetEngine fields and JetEngine Custom Content Types (CCTs).

JetEngine CCT import and export compatibility is included in the free ecosystem.

Advanced JetEngine operations, record updates and scheduled workflows are available in Pro.

Import Images From URLs

Import images while importing WordPress content or WooCommerce products.

Your CSV, XML or spreadsheet can contain image URLs. WP Ultimate CSV Importer can download supported remote images into the WordPress Media Library and associate them with imported content.

Use image imports for:

• Featured images
• WooCommerce product images
• Product galleries
• Post images
• Media library imports

You can also map image metadata such as alt text and titles to improve media organization and SEO.

Bulk Import WordPress Media

Need to move or create a large media library?

Import images using external URLs, local files (desktop) or supported media upload workflows.

Failed media imports are recorded in logs so problematic images can be identified and imported again.

Import Data Without Creating Broken Records

WP Ultimate CSV Importer includes Pre-Flight Validation to analyze import files before records are written to WordPress.

The validator can identify problems such as:

• Invalid file structures
• Encoding problems
• Inconsistent column counts
• Malformed delimiters
• Missing required values
• Other import-file problems

The File Health Score provides a quick indication of whether your import file is ready.

Review the reported issues, correct the source file and validate it again before beginning a large import.

Resume Interrupted WordPress Imports

Large imports can sometimes be interrupted by PHP execution limits, server resource limits, browser interruptions or network problems.

The Auto Recovery and Resume feature saves import progress so interrupted imports can continue from the appropriate point rather than forcing you to restart the entire operation.

This is especially useful when importing large product catalogs, media libraries or thousands of WordPress records.

Save and Reuse Import Mapping Templates

Don’t map the same spreadsheet every time.

Save frequently used field mappings as Mapping Templates and reuse them when importing files with the same structure.

Mapping templates can significantly reduce setup time for recurring manual import jobs.

Import Dashboard and Logs

Monitor WordPress imports from the importer dashboard.

The dashboard provides visibility into import activity using:

• KPI cards
• Import statistics
• Activity information
• Import logs
• Summary logs
• Failed media logs

Use the Log Manager to troubleshoot import failures and review completed imports.

AI-Assisted WordPress Imports

WP Ultimate CSV Importer supports integrations with AI services including:

• OpenAI / ChatGPT
• Google Gemini
• Anthropic Claude

AI-assisted import workflows can help generate or enhance supported content during the import process.

Pro provides additional AI content assistance for workflows such as category suggestions, SEO titles, meta descriptions and translations with human review.

Import Affiliate Product Feeds

WP Ultimate CSV Importer can be used to create and maintain websites powered by affiliate or supplier datafeeds.

Map feed fields to:

• WordPress fields
• WooCommerce product fields
• Product attributes
• Categories
• Taxonomies
• Custom fields
• Images

This makes the importer suitable for building:

• Affiliate stores
• Product catalogs
• Price comparison websites
• Supplier-driven WooCommerce stores
• Datafeed-powered WordPress websites

Migrate Content to WordPress

Moving from another CMS or ecommerce platform?

If your source system can provide its content as CSV, XML or another supported structured format, WP Ultimate CSV Importer can map that data into WordPress.

Typical migration workflows include:

• Shopify to WooCommerce
• Magento to WooCommerce
• Wix to WordPress
• Squarespace to WordPress
• Blogger to WordPress
• Drupal to WordPress
• Joomla to WordPress
• Custom CMS to WordPress
• Another database or application to WordPress

Export the content from your source platform, prepare the resulting data and map it to the appropriate WordPress fields.

WordPress to WordPress Migration

WP Ultimate CSV Importer also provides a Migration and One-Click Import workflow for transferring supported content between WordPress websites.

The export side of the migration requires the free WP Ultimate Exporter add-on.

Install WP Ultimate Exporter

Export the required WordPress data using the Migrate option and import the generated migration bundle into the destination website.

Read the Migration & One-Click Import documentation

WP Ultimate CSV Importer Ecosystem

WP Ultimate CSV Importer is the core import plugin.

Extend it with free companion plugins when additional modules are required.

WP Ultimate Exporter

Export supported WordPress data to CSV, XML and Excel.

Download WP Ultimate Exporter

Import WooCommerce Suite

Extend WooCommerce import support for products, variations, orders, customers, coupons, reviews, refunds and other supported WooCommerce records.

Download Import WooCommerce Suite

Import Users & Customers with Meta

Import WordPress users and WooCommerce customers with additional metadata.

Download Import Users & Customers with Meta

Popular Plugin Integrations

WP Ultimate CSV Importer integrates with many popular WordPress plugins and ecosystems.

Custom Fields

• Advanced Custom Fields (ACF)
• JetEngine
• MetaBox
• Pods
• Toolset Types
• Custom Field Suite
• CMB2
• CPT UI
• TotalPress

WooCommerce

• WooCommerce
• WooCommerce Product Bundles
• WooCommerce Billing & Shipping Information
• YITH Barcodes
• YITH Cost of Goods
• PPOM

SEO

• Yoast SEO
• Rank Math
• All in One SEO
• SEOPress
• Slim SEO

Multilingual

• WPML
• Polylang
• Polylang for WooCommerce

LMS

• LearnPress
• LifterLMS
• MasterStudy LMS

Directories and Listings

• Business Directory Plugin
• Advanced Classifieds & Directory Pro
• GeoDirectory
• WP Job Manager

Community and Membership

• BuddyPress
• bbPress
• WP-Members
• Members
• WPComplete

Other Integrations

• SureCart
• Easy Digital Downloads
• Elementor Templates
• Featured Image from URL (FIFU)
• Post Expirator
• WP Customer Reviews
• Exmage
• Events Calendar
• ChatGPT / OpenAI
• And more

View supported third-party integrations

Free vs Pro

The free version is designed for powerful manual WordPress data imports.

Use it to import supported:

• Posts
• Pages
• Custom post types
• Users
• Taxonomies
• Media
• Simple WooCommerce product data
• Supported ACF fields
• JetEngine CCTs
• Supported third-party fields
• CSV files
• XML files
• Excel files
• Google Sheets data
• Images
• Affiliate datafeeds

The free ecosystem can be extended using the Import WooCommerce Suite, Import Users & Customers with Meta and WP Ultimate Exporter add-ons.

Updating existing records is a Pro feature.

Upgrade to WP Ultimate CSV Importer Pro when you need advanced operations such as:

• Update existing WordPress records
• Advanced WooCommerce update workflows
• Scheduled imports
• Recurring imports
• FTP/SFTP automation
• Google Sheets scheduled imports
• Advanced ACF fields
• Advanced custom field plugin support
• Advanced WooCommerce operations
• Failed Record Retry Queue
• Spreadsheet Live Editor
• Cloud storage imports – Google Drive, Microsoft OneDrive
• Page builders
• External database migration – MySQL import, MariaDB import, PostgreSQL import, and SQL Server import
• REST API
• Webhooks
• API key management
• Advanced filtering
• Advanced exports
• Scheduled exports
• Google Sheets exports
• Mapping Template Import/Export
• Database optimization tools
• Priority support

Explore WP Ultimate CSV Importer Pro

Try WP Ultimate CSV Importer Pro

Want to test the advanced features before upgrading?

Create a Private Pro Trial

Open the Live Demo

Trusted by WordPress Publications

WP Mayor

WP Mayor has reviewed WP Ultimate CSV Importer Pro as a WordPress data import and migration solution.

Read the WP Mayor review

Kinsta

Kinsta has featured WP Ultimate CSV Importer Pro in its coverage of WooCommerce product export and migration tools.

Read the Kinsta article

Documentation and Tutorials

WP Ultimate CSV Importer Documentation

Sample CSV and XML Files