內容簡介
WP Ultimate CSV Importer 是一款強大的 WordPress 外掛，能夠將 CSV、XML 和 Excel 檔案中的數據批量導入 WordPress。無需手動創建記錄，輕鬆導入文章、頁面、WooCommerce 產品等多種數據，提升網站管理效率。
【主要功能】
• 批量導入文章、頁面和自訂文章類型
• 導入 WooCommerce 產品及其屬性
• 支援 CSV、XML 和 Excel 檔案格式
• 可視化欄位對應界面，無需編寫代碼
• 導入 SEO 元數據和多語言內容
• 支援從 Google Sheets 導入數據
外掛標籤
開發者團隊
② 後台搜尋「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
