WP Ultimate CSV Importer supports three multilingual plugins.
- qTranslate X import
Import for WPML Multilingual
With WP Ultimate CSV Importer import multiple language data uninterruptedly in a single CSV file into your WordPress multilingual site. WP import export of your WP all import multilingual site’s Posts, Pages, Custom Posts, WooCommerce, MarketPress, WP eCommerce, Categories, Tags, and Custom Taxonomies in any language is possible. If you have not yet purchased the WPML plugin, click here to purchase now.
Prepare your CSV
First of all, prepare a proper CSV to import the content into your website.
- In your CSV, the first row should be headings of fields that are used for mapping.
- To import your translated content into WordPress, add two extra fields ‘language_code’ and ‘translated_post_title’ in your CSV file, instead of using these header names you can give your desired names. In the ‘language_code’ field, mention the language code of your default and translated post.
- The other field ‘translated_post_title’ is to relate the translated post with the default post(the post you’re translating in multiple languages). Mention the heading of the default post(post_title) in the ‘language_post_title’ field.
Start importing data with WP Ultimate CSV Importer
- In your WP Ultimate CSV Importer plugin, navigate to the ‘Import/Update’ section.
- Upload your CSV file in any of the four methods of Import.
- After uploading, choose your post type from the ‘import each record as’ dropdown.
- If you are importing the CSV as new, then check the ‘New Items’. Otherwise, use ‘Existing Items’ to update the already existing content.
- Click Continue.
- In the mapping section, map the fields of WP fields related to the CSV headers. The plugin automatically maps the fields if WP fields are similar to CSV headers.
- In WPML Fields map the language Fcode and translated_post_title fields.
- Save the mapping by providing a name in the ‘Save this mapping as’ field, so that you can use it as a template in the future.
- Select continue.
- Use the media handling section, if you want to import any external images. You can avoid creating duplicates by enabling options like ‘use media images if already available’ and ‘permission to overwrite existing images’.
- Map the necessary image fields here.
- Continue and in the importing section, you can schedule your import to be done later or you can import instantly using the ‘import’ button.
- To schedule, check the ‘Do you want to Schedule this import?’ option and provide the schedule date, frequency, time zone, and time. Then select ‘Schedule’.
- Now click on the ‘import’ button to import the content on the website.
Wait for a few seconds, the import will be completed. Visit the post in your WordPress to make sure your import has been done successfully.
Exporting your multilingual data
To export your WPML multilingual website data, tap the ‘Export’ menu in WP Ultimate CSV Importer.
- Choose the WordPress module that you want to export. You can see the records count shown in the top right corner.
- Select continue. Note if the selected module has no records to export then you can’t proceed to the next step.
- Add the filename to export.
- In the Advanced settings choose the export type. WP Ultimate CSV Importer allows you to export in four different file formats such as CSV, XML, XLS, and JSON.
- You can split and export your data if your website has a bunch of data to export. Check the ‘Split the Record’ option and give the value. For example, if you give the split value as 100, the first 100 records will be in 1st CSV and the next 100 records in 2nd CSV, and so on. Note that, by default, the export will be done in CSV format.
- Advanced filters like export with auto delimiters, export with a specific status, etc., are used to filter and export the required data. WP Ultimate CSV Importer provides the possibility to schedule your export. Follow the steps in the link and export your content from WordPress.
WPML Fields to add in your CSV
|Description & CSV Values
|CSV Sample values
|Mention the code of the translated language
|Provide the default post_title from where the post translated
|Anne of Green Gables
How to prepare a CSV file?
The CSV file needs to be in UTF-8 format. You can export the existing content as a CSV file for you to have an exact sample of your data. You can also refer to the documentation on how to prepare a CSV file or download free samples from the Sample CSV blog.
2. How can I validate my CSV to confirm the UTF-8 standard?
You can upload your CSV file to http://csvlint.io/ and validate it.
3. How can I debug my file if I find any errors with the format or column mismatch?
The CSV file prepared with Microsoft Excel may have column mismatch errors or some kind of formatting issues. In this case, you can upload the CSV file prepared in your Google Drive and again download it as a CSV file.
4. Can I have different header names for the WPML fields in my CSV file?
Yes, you can. WP Ultimate CSV Importer doesn’t have a restriction in naming your CSV headers. You can give your name and in mapping, carefully relate the CSV headers mentioned in CSV to its corresponding WordPress fields.
5. Does the plugin allow the import of CSV/XML from external URLs?
Yes, the plugin allows you to upload your CSV or XML file from publicly accessible external URLs such as from Google Sheets. You can schedule the import process and make any changes in your Google sheet to get those modifications automatically updated on your website with no manual interference.
The FTP import can help you upload the CSV/XML file stored on different servers.
6. Which Ultimate CSV Importer editions support WPML multilingual import?
- WP Ultimate CSV Importer Pro will update, schedule, export, and import WP all import WPML CSV/XML files. And it costs $199 with wpml lifetime FREE support & upgrade.
- WP Ultimate CSV Importer – also offers a separate package named ‘WPML Importer’ that supports the import, update, and schedule of both CSV & XML files. It costs $149 and comes with lifetime FREE support & upgrade.
7. Does the plugin support the import of translated taxonomies?
Yes, the plugin does support the import of translated taxonomies too along with any Post Type import.
WPML Alternatives Import Export
The Polylang and the qTranslate X are the alternatives to WPML.
Polylang with WP Ultimate CSV Importer helps your CSV/XML data import in various languages into WordPress effortless, populating Posts, Pages, Custom Posts, Taxonomies, Tags, Categories, and WooCommerce Products. Adding to that, you can efficiently export the imported data with this WP Ultimate CSV Importer tool.
qTranslate X Import
qTranslate X lets you import dynamic multilingual content. You can import the individual fields of your CSV in multiple languages by specifying the language code in the corresponding field with the syntax [:en].
For example, If you need the Title of the page in Japanese, you can specify it as [:ja]Title. Its output will be タイトル(title).