In this tutorial, we will show you how to quickly import post translations for the Polylang plugin. This is very useful when you hire translators who cannot use WordPress and they deliver the translated posts in a CSV file for editing in Excel, Google Sheets, or any other CSV editor.
We will do this using Posts, Pages and Custom Post Types Spreadsheet. This plugin allows you to view and edit posts, pages, and any custom post type in WordPress using an intuitive spreadsheet.
The spreadsheet allows you to:
- Quickly do advanced searches
- Edit hundreds of posts at once with a few clicks
- Export posts, pages or any post type to a CSV file
- Import posts, pages or any post type using a CSV file
You can download the plugin here:
Once installed and activated, you need to follow these steps to import Polylang translations.
1- Open the posts spreadsheet
To open the posts spreadsheet, go to WP Sheet Editor > Edit Posts.
Once there, you’ll see all your WordPress posts displayed as rows and their fields displayed as columns.
Notice that our main Polylang language is English, and we have 20 posts.
If you right-scroll, you can see the posts’ language in the Polylang Language column.
If you select Spanish or any other language, you’ll see that we have only one post, which we’ve translated manually.
Again, if you right scroll, you’ll see the posts’ language in the Polylang Language column.
What we’ll do is to export all the English posts to a CSV file, translate the posts with Excel or Google Sheets, and then import the translations back to WordPress.
2- Prepare the translations in a CSV file
Don’t worry if you haven’t exported all the translations to a CSV file to translate them because here we show you how to do it quickly.
With the spreadsheet in English, open the Export tool with one click. It’s on the top toolbar.
Now select these values to export all the active columns to a CSV file.
- What columns do you want to export: Select all active columns
- Tick the I understand it will export all the rows from my current search checkbox.
- What app will you use to edit this file? (optional): Select any of the available apps.
- Name of this export (optional): You can enter a name for future sessions.
- Click Start export to download the CSV file to your computer.
Here’s how the posts look translated in Microsoft Excel. This is what your translator should give you after translating all the posts in Excel or any other software.
Important. Your translator must edit the Polylang Language column to be “Español”.
Now we’re ready to import the Spanish translations of our posts.
3- Import the Polylang translations quickly
To import the Spanish translations of your posts:
- Open the spreadsheet in Spanish.
- Click Import on the top toolbar.
Now select the CSV you’ll import from your computer.
- Source: CSV file from my computer
- CSV File: Click Choose file and select the CSV file from your computer.
- Click Next.
Then, click Import all the columns to go on.
Next, select how you’ll import the information; in this case, everything will be imported as new items.
- Do you want to update or create items: Import all rows as new
- Click Next
Finally, you’ll be shown a preview of how your Polylang translations will look imported. If everything’s OK, click The Preview is fine, start import.
Once the import process finishes, you’ll see all the imported translations in the spreadsheet.
If you right scroll, you’ll see the language correctly set. This is why the translator must change the translation language when preparing the CSV file.
You see! Importing Polylang translations from Excel or Google Sheets is really simple with WP Sheet Editor. You don’t need to manually create the translations in WordPress; just export the posts, hire a translator or edit the CSV yourself, and then import the translations back to WordPress.
You can download the plugin here: