WordPress Ultimate CSV Importer Sample CSV files and Updates

January 27, 2015

Since the launch of WP Ultimate CSV Importer in 2012, we’ve been constantly working to automate WordPress Import and Update. We’ve added support for most of the common WordPress add-ons and also based on our customer’s requirement. The supported 3rd Party WordPress add-ons includes WooCommerce, MarketPress, WPML, qTranslate X, NextGEN Gallery, ACF, CustomPress and much more.

Sample CSV file for MarketPress Import

WordPress Ultimate CSV Importer supports both MarketPress Pro & MarketPress Lite versions.

Sample CSV file for WP eCommerce Import

WordPress Ultimate CSV Importer supports WP eCommerce along with its supported custom field add-on WP e-Commerce Custom Field.

 

Sample CSV file for WooCommerce Import

WordPress Ultimate CSV Importer supports WooCommerce product import, WooCommerce variations import, WooCommerce orders & refunds import, WooCommerce coupons import and 6 other WooCommerce add-ons.

Sample CSV file for Events Manager Import

WordPress Ultimate CSV Importer supports Events Manager add-on to import locations, events & recurring events.

Sample CSV file for Multilingual Post, Page or Product Import CSV Sample

WordPress Ultimate CSV Importer supports both WPML & qTranslate X to make your website content multilingual. You can import your WooCommerce, MarketPress, WP eCommerce, Post, Page, Custom Post & Custom fields in any of the languages supported by those 2 add-ons.

Sample CSV for SEO fields Import

WordPress Ultimate CSV Importer supports SEO fields created with Yoast SEO and All-in-One-SEO add-ons.

Sample CSV for NextGEN Gallery Image Import

WordPress Ultimate CSV Importer supports free version of NextGEN Gallery. You can import and relate the image with the corresponding Post or Page.

Sample CSV file for Custom Fields Import

WordPress Ultimate CSV Importer supports 3rd party custom field add-ons such as ACF, Pods, Types, CustomPress, CCTM and WordPress custom fields. All these custom fields can be imported along with WooCommerce, MarketPress, WP eCommerce, Post, Page, Custom Post.

Sample CSV for Custom Post Import

WordPress Ultimate CSV Importer supports Custom Post Type UI, Types, Pods, CCTM, CustomPress & default WordPress custom post.

Sample CSV for Post & Page Import

WordPress Ultimate CSV Importer supports Post and Page import.

Sample CSV for Comments Import

WordPress Ultimate CSV Importer lets you to import user comments in WordPress.

Sample CSV for Customer Reviews Import

WordPress Ultimate CSV Importer supports WP Customer Reviews add-on to import user reviews.

Sample CSV for Users Import

WordPress Ultimate CSV Importer supports WordPress users import along with the additional custom fields of users created with WP-Members and Members.

Sample CSV for Categories, Tags & Taxonomies Import

WordPress Ultimate CSV Importer lets you to import Categories, Tags and Taxonomies in bulk.

If the CSV files are given with header names same as of WordPress field names, then it automates mapping in CSV Import. You can also create with your own header names and it can be mapped to import in corresponding WordPress fields.

Basic Sample CSV Files requirements:

  • The CSV file needs to be in UTF-8 format.
  • Any delimiters can be used but each cell needs to be properly escaped.
  • Importer can handle any large size 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 same as WordPress field names.

Latest sample CSV files of all supported WordPress add-ons.

To learn how to import these sample files, visit our WordPress Ultimate CSV Importer documentation and try out in our Live demo. If you want sample CSV for any other use cases or If your add-on is not in the list of supported 3rd party add-ons of WordPress Ultimate CSV Importer, you can leave a comment or write to us at [email protected] for customization.

Subscribe for blog updates


8 Comments

  1. Hello Sir, while trying to import, i get this error message in most of the posts: “Can not import the record. It may have unsupported values”. How can i solve this?

  2. In general only CSV with UTF-8 format is supported for wordpress import. Also csv file contains such values should be properly escaped and validated before import to avoid ending up with such issues. Either use google sheet or notepad++ to convert your csv encode to UTF-8. Also you can use http://csvlint.io to validate your csv for any issues and correct those. Hope this helps.

  3. Commas in tags and categories cause the tag or category to be split into two. This makes it impossible to add a tag or category containing a comma in its name.

  4. Hi Ned,

    Thanks for using our Ultimate CSV Importer.

    To import multiple tags & categories, we have used the default WordPress comma(,) separator for tags and pipeline(|) for categories. And including commas in the tag name is currently not possible. But we can tweak the code to replace the separator and help you get your name imported with comma. Kindly email us at support[at]smackcoders[dot]com, we will help you

  6. Hi Dan,

    Our Ultimate CSV Importer supports import of UTF-8 format CSV files. In Excel, when the columns are not escaped properly, your file may fail to import. You can upload the same data in Google sheet and download it as CSV file. And it will support the specified characters ÆØÅ.

  7. hello every one kindly help me,
    how can insert one posting in different categories, i dont know how to write multiple category in the sheet column
    pls help,

  8. Hi Raj,

    Yes, you can relate a single post with multiple category during import. You have to mention the list of category you want to relate in pipeline(|) separator in your CSV file. For eg. category1|Category2|Category3

    You can refer our documentation to know more on importing Nested Category.

Leave a Reply

Your email address will not be published.