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.
You can download the plugin here:
Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Check the features
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.
If you select Spanish for example, the spreadsheet will display all the posts in that language.
If you select Italian, the posts displayed in the spreadsheet will be in that 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.
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.
- 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.
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.
You can download the plugin here:
Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Check the features
Click here to read other tutorials on how to manage WPML translations with WP Sheet Editor.