WPML – How to Export Posts Translations in Specific Language

In this tutorial, you’ll learn how to export WPML post translations in specific languages using WP Sheet Editor. You can create all the translations in bulk, and then export the translations in a specific language to send a CSV file to your translator.

We’ll export specific-language WPML translations using WP Sheet Editor.

This WordPress plugin allows you to edit posts, pages, and any custom post types using an intuitive spreadsheet. It contains easy-to-use tools for advanced searches, bulk changes and exporting/importing files from Excel or Google Sheets.

Once installed and activated, follow these simple steps to export all the posts from a specific language.

Step 1. Open the posts spreadsheet

To open the posts spreadsheet, please go to WP Sheet Editor > Edit Posts.

You’ll see all your posts displayed in the spreadsheet as rows and all the fields as columns.

Important

Before exporting the posts by language, you need to first create the translations.

Maybe you’ve created them already, but if you haven’t, we have a tutorial on how to translate posts in bulk:

The content displayed will depend on the language selected. For example, if you select English, the spreadsheet will show all the English posts.

wpml-export-posts-specific-language

If you select Spanish for example, the spreadsheet will display all the posts in that language.

wpml-export-posts-specific-language

If you select Italian, the posts displayed in the spreadsheet will be in that language.

wpml-export-posts-specific-language

To export all the posts in a specific language, you just need to select the language and then proceed to export all the posts in that language to a CSV file.

We’ll use the Italian language as an example, but you can apply the same steps to export the posts in any other language.

Step 2. Open the “Export” tool

The Export tool allows you to download a CSV file containing all your posts with their complete information. You need to open it with one click on the top toolbar.

wpml export post translations in a specific language

Step 3. Export all the posts in a specific language to a CSV file

Once you open the Export tool, you need to select the columns you’ll export.

wpml export post translations in a specific language

  • What columns do you want to export: You have three options:
    • Export specific columns: Useful if you just want your translator to edit the Title, Content, Description, SEO Title, and SEO Description fields.
    • Export all columns: Click on Select All.
    • Export all active columns: Click on Select active columns.
  • Tick the I understand it will export all the rows from my current search checkbox.
  • Select the app you’ll use to open the CSV file in What app will you use to edit this file? (optional)
  • Optional: Name the export for future exports.
  • Click on Start new export and the CSV will be downloaded to your computer.

After selecting and applying these values, you can open the CSV file with Excel, Google Sheets, or any other CSV editor.

wpml export post translations in a specific language

Export products in a specific languages now!

As you see, exporting all your posts in a specific language to Excel, Google Sheets, or any other spreadsheet editor software is really simple.

Now you can give that CSV to your translator so that he/she works quickly without having to use WordPress.

You can also read: How to Import Post Translations.

Click here to read other tutorials on how to manage WPML translations with WP Sheet Editor.

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.