Managing a multi-language website requires good tools. Your productivity needs to be increased to the maximum because you’ll have to manage twice or thrice the content you’d normally manage with a single-language website.
One of the tools that can help you a lot is WPML. With this plugin, you easily create and run multi-language sites. It’s useful for corporate websites and multi-language blogs.
However, when you have hundreds of posts to translate into one or two other languages, you can be sure you’ll have to spend several hours adding the translations one by one, opening hundreds of browser tabs, and so on.
Fortunately, we have the solution to that problem. We’ll show you how to create thousands of translations and edit them quickly without opening a lot of tabs. You’ll edit your translations using a spreadsheet bulk editor.
Just follow these simple steps.
Step 1. Install the “WP Sheet Editor” plugin
With this plugin, you can edit any field in thousands of posts. You can filter your posts by keyword, category, tag, author, date, comment status, etc. And in this case, WP Sheet Editor will allow you to create and edit hundreds of translations quickly.
You can download the plugin here:
The plugin will automatically generate a spreadsheet for editing your posts massively.
Step 2. Open the posts spreadsheet
To open the posts spreadsheet go to WP Sheet Editor > Edit Posts or you can go to WP-Admin > Posts and click on Open in a spreadsheet.
The content shown in the spreadsheet will depend on the selected WPML language. If you select English, the spreadsheet will show you all the posts in English.
If you open the spreadsheet in Spanish for example, the spreadsheet won’t show you any translation (if you don’t have created any translation in that language previously).
Step 3. Create the post translations with the spreadsheet
Open the spreadsheet in English.
To create hundreds of post translations to several languages in seconds, go to the WPML – Duplicate column.
After that, add the language codes to each post. WP Sheet Editor allows you to auto-fill content in the cells below.
Then, add the language codes for any other languages separated by commas.
Once you add the language codes, click on Save to apply the changes.
Something really important is that you don’t have to open the posts and create the translations one by one. You can create all the translations at once. Our spreadsheet editor will automatically create copies in the languages that you entered.
Step 4. Change the translation relationship in the spreadsheet
Once you’ve created the translations, open the spreadsheet in Italian or in Spanish.
We’ll open it in Spanish.
The spreadsheet will show you the translations created.
Before editing the content of the translations, change the translation relationship because if you don’t, any changes you apply to the translation will be applied to the original post.
Go to the WPML – Relationship column and select translate_separately. You can auto-fill the content of the cells below just as you’d do in Excel or Google Sheets.
Click on Save to apply the changes.
Step 5. Edit the translations in the spreadsheet
We’re editing the Spanish translations. You can see the Spanish flag on top of the page.
Normally, you would have to open and edit all the posts one by one, which could take you many hours.
However, with WP Sheet Editor you can translate your posts completely using the spreadsheet to save a lot of time.
a. Edit the post titles
To edit the titles, go to the Title column and translate the text in that column.
b. Edit post content and descriptions
Go to the Content column, and you’ll have these two options to edit the content.
- Double-click the content in this column and edit the content using simple text/html format.
- Edit the content using the Gutenberg or the Tinymce editor. For that, you just need to click on the Pencil button and the spreadsheet will display the editor.
This is how Gutenberg looks once it’s displayed in the spreadsheet:
c. Edit SEO title and description
Depending on the SEO plugin you have, you need to search for the SEO Title and SEO Description columns.
We’re using the SEO Press plugin, so we need to go to the Seopress Titles Title and Seopress Titles Desc columns and edit their content.
Finally, click on Save to apply the changes. You can also save changes every time you edit a column if you feel that’s better.
With WP Sheet Editor you can edit edit thousands of translations, translate thousands of posts, export and import translations using CSV files. And all of this won’t take you lots of time because you can do it completely in the spreadsheet.
Integrating WPML and WP Sheet Editor is the best option to create and manage your multi-language websites and blogs.
You can download the plugin here: