WPML – How to Import Post Translations Quickly

In a previous tutorial, we showed you how to export post translations to Excel or Google Sheets. This is really useful when you want to give your posts to a translator so he can translate the posts’ Titles, URL Slugs, Content, Excerpts, SEO Titles and SEO Descriptions outside WordPress.

In this tutorial, we’ll show you how to import translations quickly using WP Sheet Editor.

This is very useful because you can:

  • Save a lot of time because your translators don’t need to learn how to use WordPress
  • And this is secure because you won’t give a WordPress account to your translators. They will not break your site

This plugin allows you to translate thousands of posts, edit translations using an intuitive spreadsheet, export translations, and import thousands of translations using a CSV file.

Once installed and activated, you need to follow these steps to import post translations quickly.

Step 1. Prepare the CSV file you’ll import

You may have already prepared the CSV file. If you hired a translator to edit the CSV file, he may have edited a CSV containing the posts’ IDs, Titles, URL Slugs, Content, Excerpts, SEO Titles and SEO Descriptions.:

Now you’re ready to import all the translations into WordPress.

Step 2. Open the posts spreadsheet

You can open the posts spreadsheet by going to WP Sheet Editor > Edit posts. You’ll see all the posts displayed in the spreadsheet as rows and their complete fields displayed as columns.

As you’ll notice when you open the spreadsheet, the content displayed in it depends on the language you select in WPML. We hired a Spanish translator to edit our posts in that language, so we need to open the posts spreadsheet in Spanish.

Step 3. Open the “Import” tool

This plugin contains a powerful Import tool that you can use to create new posts or edit existing posts using CSV files edited with Excel, Google Sheets, or any other CSV file editor. You need to open it with one click on the toolbar.

Step 4. Import the post translations into WPML

After opening the Import tool, you need to select these values to import the translations.

a) Choose the CSV file

You need to choose the CSV file you’ll import from your computer or from a URL. In this case, we’ll import a CSV file from our computer, so you need to use these values:

  • Source: CSV file from my computer
  • Click Choose file and select the file from your computer.
  • Click Next.

Click Import all columns to go on.

b) Update existing items and match IDs

If the translations existed in your site previously, you can update existing translations by ID or title.

If the translations are new, you can select the option to create everything as new.

In this case, we will import information into the existing translations.

  • Do you want to update or create items: Update existing items, ignore new items
  • CSV Field: record_id
  • WordPress Field: ID
  • Click Next.

c) Start the import

Finally, you’ll be shown a preview of how the posts will look imported. If everything is OK, click The preview is fine, start import, and the translations will be imported into WordPress immediately.

Import thousands of translations easily!

With WP Sheet Editor, you can import translations for any language using CSV files edited with Excel or Google Sheets.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu