You’ve hired a new translator for Italian or any other language, but the problem is that you have to wait for him to learn WordPress to sign in, open the posts one by one, and translate them.
The solution is to give him/her the translations of the posts in a CSV file so that he/she can work in Excel, Google Sheets or any other CSV file editor. That way he/she won’t waste time learning unnecessary things for him/her and your investment will be better used because you will have your posts translated soon.
In this tutorial, we will show you how to quickly export all the translations from a specific language to a CSV file that can be edited in Excel, Google Sheets, or any other CSV file editor.
We’ll do it using WP Sheet Editor. This WordPress plugin allows you to edit posts, pages, and any custom post type using an intuitive spreadsheet that 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:
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.
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 quickly, so you can follow the steps in that tutorial to create the translations.
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.
How simple it is to export products in a specific language!
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 download the plugin here: