WordPress Multilanguage Import

The Importer supports two multilingual plugins.

  1. WPML importer
  2. q Translate 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. Importing and exporting your WordPress multilingual site’s Post, Pages, Custom Post, WooCommerce, WP eCommerce, Categories, Tags, and Custom Taxonomies in any language is possible. If you have not yet purchased the WPML plugin.

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 the ultimate all Importer plugin

  • Go to the plugin, and navigate to the ‘Import/Update’ section.
  • Upload your CSV file by browsing and locating it.
  • 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. Detailed steps are available here on how to import or update WordPress data.
  • 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_code, 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 scheduled 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 file name to export.
  • In the Advanced settings choose the export type. the plugin exporter 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. The exporter feature provides options to schedule your export in the background. Follow the steps to export your content from WordPress.

WPML Fields to add to your CSV

WPML fieldsDescription & CSV ValuesCSV Sample values
language_codeMention the code of the translated languagear
translated_post_titleProvide the default post_title from where the post translatedAnne of Green Gables

FAQ

1. 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 found any errors with the format or column mismatch?

The file prepared with Microsoft Excel as CSV for import may have column mismatch errors or some kind of formatting issues. In this case, a simple hack is to upload the Excel CSV file prepared for Import to the google drive account and download it as a new CSV file to get rid of any such issues.

4. Can I have different header names for the WPML fields in my CSV file?

Yes, you can. there is no 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 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 in different servers.

6. Which premium plugin edition support WPML multilingual import?

  • The Premium plugin supports the import, update, schedule, and export of WPML CSV/XML files. And it costs $199 with lifetime FREE support & upgrade.
  • The premium options also offer a separate package named ‘WPML Importer’ that supports the import, update, and schedule of both CSV & XML files for WPML data. It costs $149 and comes with lifetime FREE support & upgrade.

7. Does the plugin support import of translated taxonomies?

Yes, the plugin does support the import of translated taxonomies too along with any Post Type of import.

qTranslate X Import

qTranslate X Import Sample CSV File

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 as [:ja]Title. Its output will be タイトル(title)

Cookies help us deliver our services. By using our services, you agree to our use of cookies.