Sample CSV & XML files for WordPress Import – WP Ultimate CSV/XML Importer (Trial & Testing Guide)

Sample CSV and XML files help you test WordPress imports without creating data from scratch. WP Ultimate CSV/XML Importer provides ready-made CSV and XML sample files so you can understand field structure, relationships, and formatting before running a real import.

In this guide, you’ll learn what these sample files contain, how to use them for trial imports, and how to import CSV or XML files into WordPress step by step.

What’s Inside These Sample Files

The sample CSV and XML files provided in this article are not just demo data. They are reference templates that show how your WordPress data should be structured for a successful import. Each sample file is prepared so you can click, download, and use it directly to test imports with WP Ultimate CSV/XML Importer.

When you download any sample file listed in this guide, you’ll find:

• Predefined column headers aligned with WordPress fields and meta keys, making field mapping easier
• Correctly formatted relationship data, including parent–child and multi-record associations
• Structured custom field values for repeaters, groups, and flexible fields used by popular plugins
• Media reference examples showing how images and files are linked during import
• Taxonomies and hierarchy data, such as categories, tags, and custom taxonomies
• Plugin-specific field structures for WooCommerce, SEO plugins, multilingual setups, and other supported integrations

This allows you to safely download any file from the list below and use it as a working reference or trial import file.

These samples are intended to help you quickly understand the expected format and choose the right file for your import scenario.Note: The values are common for any file types. If you are importing a TSV, Excel, or Google Spreadsheet, you can download the corresponding file from the list below to verify the value formats before importing.

WordPress CSV Import

The plugin supports the CSV file type to import data into WordPress. You can create a CSV file with records of any post type, like posts, pages, products, orders, users, and coupons. But when preparing your CSV: 

• Ensure the values in each column are in proper format.
• Refer to the sample CSVs provided in this blog for guidance on how to add values in the proper format for specific field types like ACF repeater, JetEngine CCT fields, etc.
• After preparing your CSV file, validate it with a tool like CSV lint.
• Always save your file in UTF-8 format to avoid encoding issues during import.

Please note that not only CSV files, but you can also use other files like XML, TSV, Excel, and Google Sheets.

Steps to import a CSV file to WordPress with WP Ultimate CSV Importer

You can import a CSV file into WordPress with WP Ultimate CSV Importer by uploading the file, mapping fields, configuring import settings, and running the import process. Follow the simple 3 steps to successfully import any CSV data into WordPress.

Step 1: Upload the CSV File

• Upload the prepared CSV file inside the plugin’s  ‘import/update’ area. The plugin provides multiple upload sources: upload from desktop, ftp/sftp file upload, external file url, upload from external sources like Google Sheet & Dropbox, and locate a file from your server.

• Choose the post type and the import mode (whether it is a fresh import or an update to available content).

Step 2: Match the columns in CSV with WordPress fields

• On the left side, you have the WordPress fields of the selected post type. The right side of each WP field is the area to map your file fields. You can either use the dropdown or the drag-and-drop method to match the fields.

• The plugin will automatically match fields if both field headers have similar names. If you use our sample files, then most of the fields are auto-mapped.
• The advanced mode mapping area incorporates the actions section (the settings icon added beside each field). This is helpful to customize the field data during import. Configure actions like combining multiple fields, adding custom functions, formulas, and AI prompts for automatic content generation. Learn more about this here on our WP Ultimate CSV Importer how to import CSV files guide.

• You can apply conditional filters on this page to import selected records from your file. Check for the details on how to use the import filters.

• At the end of the page, enter a unique name in the ‘save this mapping as’ textbox, then proceed to the next step.

Step 3: Handling media files & other import settings

• Choose any one of the three options in manage media uploads to tell the importer how you want to handle the media imports.
• Then scroll down to import configuration settings and enable essential configurations like rollback for safety backups before import, maintenance mode to notify users about import, and iteration processing(batch imports).

• Once everything is configured, hit import, and your CSV records will be successfully imported into WordPress.

Learn more about importing a CSV File into WordPress with WP Ultimate CSV Importer.

WordPress XML import

Unlike WordPress’s default export, WP Ultimate CSV Importer allows filtered and format-specific XML exports with total control. This makes it easier to reuse exported files as controlled import sources.

It allows you to export any type of WordPress content with advanced filters and multiple file format options. So you can export exactly what you want, not everything at once.

To help you get started, we’ve provided sample XML files below. You can download them and try importing them into the plugin to see how it works.

How to export XML with the WP Ultimate CSV Importer

To export an XML file from WordPress:

• Navigate to the export tab in the WP Ultimate CSV Importer plugin.
• Choose a post type from the lists. If you want to export Products, select WooCommerce Products. To export any custom posts, choose Custom posts and select the custom post name from the dropdown.

• Next, insert a file name and select the file type as XML.

• Configure advanced export settings like filters, records split, and scheduling features(optional).
• Hit export and click download to save the data as an XML file to your device.

In this way, you’ll get the XML file. Both the import and export steps are the same for CSV and XML types, but the only difference is the file type.

How to Import an XML file into WordPress

The import steps are common for all the file formats. To import an XML file:

• Upload the file to WP Ultimate CSV Importer.
• Configure the post type and import type (Fresh Import or Update Content).
• Match the XML file columns with the appropriate WordPress fields.
• Configure media and import settings.
• Finally Import your XML file.

It’s that simple.

WP Ultimate CSV Importer Supported Plugins

WP Ultimate CSV Importer supports many popular WordPress plugins, making it easier to migrate their data. Some of the supported WordPress plugins are:

• WooCommerce
• Custom Field plugins (JetEngine, Toolset Types, Meta Box, ACF (Free & Pro), Pods, CFS, CMB2, SCF)
• Multilingual Plugins (WPML, Polylang)
• SEO Plugins (YOAST SEO, RANKMATH SEO, AIOSEO)
• Events Manager
• The Events Calendar
• Business Directory Listings
• NextGEN Gallery
• WP Job Manager

And more on the list.Get to know the complete list of supported WordPress plugins, or contact us for any details.

Download Sample Files for WordPress CSV/XML Import

WP Ultimate CSV/XML Importer Pro makes it simple to transfer WordPress data. To help you get started, we’ve prepared sample CSV and XML files for the most common use cases. Below you can download them. Each file contains properly structured data, so you can understand the formatting requirements and easily test imports.

Quick Tip: If you didn’t find a sample file here for your post type, just follow this. Create a record in that post type, export it using our plugin, and you’ll have a ready-made sample file to use for testing the imports.

You can try the test import in any of the following sources we offer:
– WP Ultimate CSV Importer Pro Demo (test in a public WordPress instance, used by all users) or
– WP Ultimate CSV Importer Trial (test in private WordPress demo instance, created only for you)

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $299/-

Samples CSV & XML Files for WooCommerce Import (Products, Orders, Reviews, Customers, Coupons)

Moving data to your new WordPress store is easy. WordPress Ultimate CSV/XML Importer Pro plugin supports WooCommerce data import, including Products, Coupons, Orders, Customers, and Reviews. Below are the sample files for WooCommerce. (CSV sample file)

Click on the links and download the sample CSV files you want.

• WooCommerce Customers Import CSV – sample customer profile and billing/shipping data
• WooCommerce Products Import CSV – Woocommerce Sample product CSV file download, contains product details like title, description, price, SKU, categories, stocks, attributes, etc.
• WooCommerce Variations Import CSV – variable product details with parent and child(variations) products
• WooCommerce Product Bundles Import CSV – example of bundled product setup
• WooCommerce Group Products Import CSV – shows how to group multiple products
• WooCommerce Orders Import CSV – sample customer order records
• WooCommerce Coupons Import CSV – contains coupon codes with discount rules
• WooCommerce Reviews Import CSV – example customer reviews with ratings

Third-Party WooCommerce Extensions

• Yith WooCommerce Order Tracking Import – sample data for adding order tracking codes
• PPOM WooCommerce Order Import CSV – sample orders with PPOM fields

Download the Sample XML files for WooCommerce below:

• WooCommerce Variations Import XML – sample variable products data in XML format
• WooCommerce Product Bundles Import XML – sample bundled product data

Events Manager Import

The WordPress Ultimate CSV/XML Importer Pro plugin supports the Events Manager Plugin. You can import the custom post-types like events, locations, recurring events, and bookings. Also, you can import events manager categories and tags.

• Events Import CSV – example event records with title, description, date, time, day, location, and other details
• Events Import XML – example event records in XML format
• Recurring Events CSV – sample recurring events in CSV
• Recurring Events XML – sample recurring events in XML
• Event Location CSV – example venue/location details in CSV
• Event Location XML – example venue/location details in XML
• Event Categories Import CSV – categorization samples for events in CSV
• Event Categories Import XML – categorization samples for events in XML
• Event Tags Import XML – sample tags for events in XML

Multilingual Pages, Posts, and Products Import Samples

If you’ve built a multilingual website using plugins like WPML, qTranslateX, or Polylang, the importer supports importing multilingual data into them. Import translated data in many languages via CSV or XML. Engage the audience worldwide and get more visits to your website. WP CSV/XML importer supports importing translated data of posts, pages, custom post types, and WooCommerce.

Sample CSV and XML files are given below,

• WPML Sample CSV – CSV with language and translated post fields
• WPML Sample XML – XML with language and translated post fields
• Polylang with WooCommerce Product CSV – sample multilingual product records

Sample CSV & XML for SEO fields Import

Millions of websites created using WordPress are getting higher ranks in search results with the help of smart WordPress SEO plugins. Due to the increased demand to boost the rankings of websites, they are used by many WordPress administrators across the globe. Many SEO plugins are available for free at WordPress.org.

WP Ultimate CSV/XML Importer integrates with these SEO plugins: Yoast SEO, RankMath SEO, All in One SEO, SEOPress, and Slim SEO plugin. You can import these plugin fields using WordPress CSV/XML Importer Pro.

Download sample files for data import to SEO fields.

• Yoast SEO Import Sample CSV – contains Yoast fields like meta titles, descriptions, focus keywords, etc.
• Yoast SEO Import Sample XML – contains meta titles, descriptions, and focus keywords, etc. in XML format
• All In One SEO Import CSV – sample AIOSEO meta fields
• All In One SEO Import XML – sample AIOSEO meta fields in XML
• RankMath SEO Import CSV – example RankMath fields like focus keyword, schema, etc.

NextGEN Gallery Import Samples

The CSV/XML Importer offers support for the free version of NextGEN Gallery. If you have existing galleries in the NextGEN Gallery plugin, you can import new images into that gallery using the WordPress CSV/XML Import plugin. You can import images along with the post metadata and relate those images to the corresponding Post, Page, or Custom Posts.

Download the sample files below for NextGEN Gallery import.

• NextGEN Gallery Import CSV – example post fields with gallery IDs
• NextGEN Gallery Import XML – example post fields with gallery IDs in XML

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $299/-

Custom Fields Import CSV & XML Samples

Add custom fields to extend your default WordPress post type or include them inside the Custom Post Type. WP Ultimate CSV Importer supports importing data for the default custom fields and custom fields created with other plugins. It supports custom field plugins like JetEngine, ACF(Free & Pro), Pods, Meta Box, CFS, Toolset Types, CMB2, CCTM, and default WordPress custom fields. You can import custom fields assigned to Posts, Pages, Custom Posts, WooCommerce Products, Users, Categories, Tags, and Custom Taxonomies.

Get samples below:

• ACF Custom Fields Import CSV – sample post with acf meta fields
• ACF Custom Fields Import XML – sample post with acf meta fields in XML
• ACF Repeater Fields CSV – example repeater field structures
• ACF Repeater Fields XML – example repeater field structures in XML
• ACF Flexible Content Import CSV – sample flexible layouts with content blocks
• Toolset Types Import CSV – basic Types custom fields
• Toolset Types Import XML – basic Types custom fields in XML
• Toolset Types Repeater Field Sample CSV – example repeater field and values
• Toolset Types Repeater Field Sample XML – example repeater fields and values in XML
• Toolset Types Intermediate Sample CSV – example intermediate posts CSV
• Toolset Types Intermediate Sample XML – example intermediate posts XML
• Toolset Types One-to-One Relationship CSV – example one-to-one relationship fields CSV
• Toolset Types One-to-One Relationship XML – example one-to-one relationship fields XML
• Toolset Types Two-to-One Relationship CSV – example two-to-one relationship fields CSV
• Toolset Types Two-to-One Relationship XML – example two-to-one relationship fields XML
• Toolset Types One-to-Many Relationship CSV – example one-to-many relationship fields CSV
• Toolset Types One-to-Many Relationship XML – example one-to-many relationship fields XML
• Toolset Types Many-to-Many Relationships Import CSV – example many-to-many relationship fields CSV
• Toolset Types Many-to-Many Relationships Import XML – example many-to-many relationship fields XML
• JetEngine metabox Import Sample CSV – sample meta box fields
• JetEngine 1 to 1 Relation Import Sample CSV – sample jetengine one-one relation fields
• JetEngine 1 to many Relation sample CSV – sample jetengine 1 to many relation fields
• JetEngine Many to Many Relation sample CSV data – sample jetengine many to many relation fields
• Pods Import CSV – sample pods fields
• CFS Import CSV – sample cfs fields
• Meta Box Custom Fields CSV – sample meta box custom fields
• Meta Box Group CSV – sample meta box group fields
• Meta Box Field Clone CSV – sample meta box clone fields
• Meta Box Group Subfield Clone CSV – sample meta box group subfield clone fields and values

Custom Post Import Samples

WP Ultimate CSV Importer supports all types of custom posts created with default WordPress fields and custom posts created using plugins like Custom Post Type UI, Types, JetEngine, ACF, Meta Box, BuddyPress, LearnPress, Pods, CCTM, CustomPress & default WordPress custom posts.

Get the samples for custom posts below,

• Custom Post Import XML – example of a custom post with title, content, taxonomy, and metadata

Post & Page Import

WP Ultimate CSV & XML Importer/Exporter plugin offers complete support for the Posts and Pages import export. You can bulk import Posts and Pages with core content and all the attributes to WordPress. WP Import XML plugin lets you import all the important fields data, including images, categories, tags, taxonomies, page attributes, menu orders, featured images, post dates, post status, and more.

Sample data is available for you to download in the form of CSV or XML. (WordPress XML file download)

Download the posts and pages samples below.

• Post Import CSV – All post fields with sample data
• Post Import XML – All post fields with sample data in XML
• Page Import CSV – All page fields with sample data
• Page Import XML – All page fields with sample data in XML

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $299/-

Comments Import

WordPress Ultimate CSV Importer Pro Plugin lets you export comments from your old site and import them into the new one. If you have already imported all your post in WordPress, the CSV Importer plugin will use the post id to match and import all the comments under the individual posts.

You can download the comments sample below,

• Comments Import CSV sample – example comments with author, email, and post references

Note: Replace sample post ids with your own site’s post ids before importing to ensure correct mapping.

WP Customer Reviews Import Samples

The WordPress Ultimate CSV/XML Importer plugin supports WP Customer Reviews field data import and export. You can import bulk user reviews with meta field information like review content, rating, business name, review format, address data, and more.

• WP Customer Reviews Import CSV Sample – example reviews with rating, reviewer details, and meta fields

Users Import CSV & XML samples

Import or update all the default User fields data in bulk with ease. WordPress CSV/XML Import plugin supports import & export for the WooCommerce plugin fields (billing and shipping information), along with default WP user fields. It also supports third-party custom field plugins like WP-Members, MemberPress, Members, and Ultimate Member.

Below are the CSV & XML sample files to download.

• Users Import CSV – example user records
• Users Import XML – example user records in XML
• Users with WooCommerce billing & shipping data CSV – sample WooCommerce customer profiles

CSV & XML for Categories, Tags & Taxonomies Import

Using Ultimate CSV & XML Importer, you can import/update, and export your Categories, Tags, and Custom Taxonomies data like slug, description, image, and more.

It supports categories, tags, and taxonomies, along with custom fields created with plugins like JetEngine, Toolset, Meta Box, Pods, and ACF.

Sample content is available to download in the CSV &  WordPress XML formats below.

• Category Import CSV – example categories with name slug, and description
• Category Import XML – example categories with name slug, and description in XML
• Tags Import CSV – sample tags data
• Tags Import XML – sample tags data in XML
• Taxonomies Import XML – sample custom taxonomy structures

If you are using the other importer and exporter plugins, the above CSV and XML files might not help you with the evaluation. All the sample files are prepared to test only with the WP Ultimate CSV Importer plugin.

If the CSV or XML header names are the same as the WordPress field names, then the WordPress CSV Importer Plugin will auto-map fields during import. You can also create with any header names, but make sure to map correctly during import configuration.

BBPress Import Samples

• BBPress Forum Import CSV – example forum records
• BBPress Topic Import CSV – sample topics under forums

MemberPress User Import Samples

• MemberPress User Import CSV – example membership user data

LearnPress Import Samples

• LearnPress Courses Import CSV – sample course structure
• LearnPress Quizzes Import CSV – example quiz data
• LearnPress Lessons Import CSV – lesson content samples
• LearnPress Orders Import CSV – sample course orders
• LearnPress Questions Import CSV – example quiz questions

Navigation Menu Import Samples

Import menus to your website using CSV/XML Importer. Simply export them with our plugin to move menu items to the new website.

Download the sample below for import testing:

• Sample CSV for Navigation Menu – example WordPress menu structure

Basic requirements for CSV

• The CSV file needs to be in UTF-8 format.
• Any delimiters can be used, but each cell needs to be properly escaped.
• The Importer can handle any large CSV files based on your server configuration.
• The headers can be of your choice. To automate mapping (relating the CSV headers with their corresponding WordPress fields), keep the CSV file headers the same as WordPress field names.

Basic XML Files requirements

• The XML file needs to be in a valid format. You can do the xml validation here.
• The plugin can handle any large XML files based on your server configuration.
• The headers can be of your choice, but you have to map the right header with WordPress fields in the mapping section. If you keep the XML file headers the same as the WordPress field slug name, the fields will get auto-mapped on the mapping page.

Frequently Asked Questions (FAQ)

Final Takeaway

Sample CSV & XML files act as ready-made templates to understand correct WordPress field structure, relationships, and formatting before running real imports. All sample files provided are tested with WP Ultimate CSV/XML Importer, ensuring accurate auto-mapping and reliable import results during trials. The samples cover real-world use cases, including posts, pages, users, WooCommerce data, custom fields, taxonomies, SEO fields, and third-party plugin integrations. Using sample files helps avoid common import errors, such as incorrect headers, encoding issues, or invalid data formats. If a sample file isn’t listed, you can easily create one by exporting a single record with the plugin and using it as a reusable import reference.

To learn how to import these sample files, follow the instructions we’ve discussed above or visit our WordPress Ultimate CSV/XML Importer documentation, and try it on our live demo.If you want a sample CSV or XML for any other use cases or if the plugin you use is not in the list of supported 3rd party add-ons of WordPress Ultimate CSV/XML Importer, you can write to us at [email protected].

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

Grab it Now $299/-