0

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

Sample-CSV-XML-files–WP-Ultimate-CSV-XML-Importer

Table of Contents

Getting a WordPress import right starts with a correctly structured file, and that’s exactly what this page gives you.

WP Ultimate CSV Importer supports CSV and XML imports for posts, pages, WooCommerce products, users, custom fields, and more. Below you’ll find free, pre-formatted sample files for every major content type. Download the one you need, swap in your data, and import it in minutes.

What is a CSV file?

A CSV (Comma-Separated Values) file is a plain-text file where each row is a record and each column is a field. It’s the most widely used format for bulk-importing content into WordPress because it’s simple, universal, and compatible with tools like Excel, Google Sheets, and virtually every CRM or eCommerce platform.

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

WP Ultimate CSV Importer Pro

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

Each file includes pre-set column headers mapped to WordPress fields, open it, fill in your data, and it’s ready to import. The same value formats apply whether you’re using CSV, TSV, Excel, or Google Sheets.

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.

Third-Party WooCommerce Extensions

Download the Sample XML files for WooCommerce below:

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.

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,

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.

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.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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

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:

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,

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.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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

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,

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.

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.

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.

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

MemberPress User Import Samples

LearnPress 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:

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.

Need a Step-by-Step Guide?

These sample files cover the file structure, but if you need help with the full import process, the official documentation walks you through field mapping, advanced settings, and troubleshooting in detail. Prefer a visual walkthrough? Our YouTube tutorial covers the entire import process from upload to completion. If you’re exploring the plugin’s full feature set or looking for pricing, visit the WP Ultimate CSV Importer.

Frequently Asked Questions (FAQ)

1. What should a CSV file look like?

A CSV (Comma Separated Value) file stores tabular data in plain text format with a list of data separated by commas. The first row in CSV is used as headers, and the remaining rows are values. Each column represents a field, and each row is a record.

For example, 

Name, Mailid, DOB, Address
Tanny, [email protected], 12/03/1978, Sample Address
Benno, [email protected], 11/09/1972, Example Address
You can open the CSV file in any text editor, but most of them use a Microsoft Excel sheet.

2. How do I create a CSV file format?

Creating a CSV (Comma-Separated Values) file format is relatively simple. 
Follow these steps to create a CSV file: 

1. Open a Text Editor: You can use any text editor, such as Notepad (Windows), TextEdit (Mac), or any code editor like Visual Studio Code, Sublime Text, etc.

2. Enter Data: Input your data in a tabular format, with each cell separated by a comma and each row separated by a new line. 

For example,
Name, Age, City
John, 25, New York
Alice, 30, London
Bob, 28, Paris

3. Save as CSV: Save the file with a .csv extension. For example, data.csv.

3. How do I format a CSV file to import?

Formatting a CSV file for import typically involves ensuring the data is structured correctly and follows specific guidelines to be successfully imported into the target system, like WordPress. Each CSV file should have a specific structure depending on what you’re importing (users, posts, etc.). Ensure that column headers match the fields in WordPress.

Here’s a general guide on formatting a CSV file for import:

– Headers: Include headers at the top of the CSV file. These headers should accurately describe the data contained in each column.
– Delimiter: Choose a delimiter to separate the values within each row. Comma (,) is the most common delimiter, but other options like semicolon (;) or tab (\t) can be used depending on your requirements.
– Quoting Values: If your data contains special characters (like the delimiter itself), whitespace, or line breaks, you may need to enclose values within quotes (“). This helps the importer distinguish between actual data and separators within the data.
– Consistent Structure: Ensure that each row of data has the same number of columns and that the data in each column adheres to the expected format. Inconsistent structure can cause errors during the import process.
– Encoding: Save the CSV file with an appropriate character encoding to support special characters and ensure compatibility with the import tool. UTF-8 encoding is commonly used and recommended.
– Clean Data: Remove any unnecessary whitespace, special characters, or formatting from the CSV file to prevent errors during import.
– Handle Empty Values: If a column doesn’t have data for a particular row, leave it empty or use a placeholder value as needed. Ensure that the CSV file handles empty values consistently throughout.

Following these guidelines will help ensure your CSV file is properly formatted for import into WordPress.

4. How do I import a CSV file into WordPress?

1. Format the CSV File: Ensure that your CSV file is properly formatted with the required data for import. WP Ultimate CSV Importer supports importing various data types, including users, posts, and custom post types.
2. Access the Import Tool & Upload CSV: In your WordPress admin dashboard, go to Ultimate CSV Importer Pro → Import/Update. Upload the desired CSV file.
3. Configure Post Type & Mapping: Configure the post type and map the CSV columns to the corresponding WordPress fields.
4. Run the Importer: Then, run the import. All CSV file data will be imported into WordPress.

5. Can I create a CSV file without Excel?

– Yes, you can do that. Use a text editor like Notepad or a code editor to create and edit CSV files.
– Provide the column headers and subsequent rows for the data corresponding to columns.
– Separate data with commas (,), and use new lines for each row.
– Ensure you have saved the file with the ‘.csv’ extension. For example (Lead.csv)

Now your CSV file has been created without Excel.

6. Can I use these sample files as templates for my real data?

Yes, that’s exactly what they’re designed for. Open the file in Excel or Google Sheets, delete the example rows, and fill in your actual content. Keep the header row exactly as it is. Then upload the file and import as normal.

7. How do I fix CSV formatting?

Fixing CSV formatting involves identifying and resolving any issues with the structure or content of the CSV file. Here are some common steps to fix CSV formatting issues:
Check for missing or extra commas.

– Ensure consistency in quoting values if necessary.
– Verify that the CSV structure matches the import requirements of your target system.
– Confirm that the headers at the top of the CSV file accurately describe the data in each column.
– Headers should be clear, concise, and correctly spelled to avoid confusion during import.
– If your data contains special characters (like commas), whitespace, or line breaks, ensure that values are properly enclosed within quotes (“). This prevents the importer from misinterpreting the data structure.

8. What’s the difference between importing CSV and XML in WordPress?

Both formats work the same way in WP Ultimate CSV Importer, you upload the file, map fields, and run the import. CSV is easier to create and edit in a spreadsheet. XML is better suited for structured or hierarchical data and is commonly used when migrating from other CMS platforms.

9. How do I import an XML file into WordPress?

You can import an XML file into WordPress using the WordPress built-in tool or using the WP Ultimate CSV importer plugin.

Using WordPress Built-in Tool
– Importing an XML File into WordPress involves the following simple steps:
– Navigate to Tools → Import in the WordPress admin dashboard.
– Here, click on Install WordPress → Run Importer.
– Browse the XML file you want to import and click on Upload File, and then hit Import.

Using CSV Importer Plugin
– Install and activate the WP Ultimate CSV importer plugin.
– Browse and open the XML file of your post, page, or custom posts. The plugin supports many ways to upload the XML file.
– Choose the content type, map the XML fields, and configure the import settings.
– Finally, click on Import. Your XML file has been successfully imported into your WordPress site.

10. How do I download an XML file from WordPress?

You can download an XML file from WordPress in two ways.

With WordPress’s Built-in Export tool
– You can export content from WordPress into an XML file using the default export tool located in the Tools menu.
– Choose the content types you want to export and click the Download Export File button. 
– The selected content type(posts, pages, or other) will be exported as an XML file and saved to your device’s downloads folder.

With WP Ultimate CSV Importer Plugin
– Install and activate this plugin on your WordPress.
– Access the plugin page and navigate to its Export tab.
– Choose the content type, such as posts, pages, or WooCommerce products.
– Provide the file name and choose the file type as XML.
– Configure any filters to extract selective data when exporting.
– Click on Export, then Download to download your WordPress data as an XML file.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

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

Picture of Smackcoders Editorial Team

Smackcoders Editorial Team

The Smackcoders Editorial Team includes plugin engineers, product strategists, and technical writers with over a decade of hands-on WordPress development experience. We build and support real WordPress tools, and every article is based on practical testing to help readers apply solutions with confidence.