WPML helps you create multi-language websites, stores, courses, events, etc. The problem is that you can’t translate or edit events in bulk. That’s why in this tutorial we’ll show you how to translate thousands of events quickly using a spreadsheet bulk editor for The Events Calendar. You don’t have to open and edit all events one by one, but you can create translations for all events at once.
After creating the translations, we’ll show you how to quickly edit titles, URL slugs, excerpts, etc. using the event spreadsheet. You don’t have to open hundreds of tabs, edit the products and save changes for each event either. Simply edit and save all changes with one click.
We’ll use the WP Sheet Editor plugin, which allows you to apply massive changes in seconds, do advanced searches, import/export events using CSV files, etc.
You can download the plugin here: Download Events Spreadsheet Plugin - or - Check the features
Once installed and activated, follow these simple steps to translate all your events quickly.
Step 1. Open the events spreadsheet
In this screenshot, you can see that we have 40+ events in English, but we don’t have any events for the other two languages we’ve selected in WPML, namely, Spanish and Italian.
To open the events spreadsheet, go to WP Sheet Editor > Edit Events. All your events will be displayed in the spreadsheet as rows and their fields as columns.
The content displayed in the spreadsheet will depend on the language selected in the WPML language selector. If we select English, the events displayed in the spreadsheet will be in that language.
If we select Spanish, we’ll see the Spanish events. However, in this screenshot, the spreadsheet won’t show us any events because we don’t have any translations for that language.
The same happens when we select Italian. We won’t see any events because we don’t have any translations for Italian.
Step 2. Translate all your events quickly
To translate all your events, you don’t have to open and edit them one by one. That would take you many hours.
You can do it using the Bulk Edit tool, which allows you to edit thousands of events in seconds. Open it with one click.
In this example, we’ll translate all the events into Spanish and Italian at once, so we need to select these values.
- Select all the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
- What field do you want to edit: WPML – Duplicate
- Select type of edit: Set value
- Replace existing value with this value: In this case, we’ll enter “es, it” (without quotes) because those are the codes for the two languages we’re translating our events. You can enter all the language codes you want.
- Click on Execute Now to translate all the events into all the selected languages.
After that, if you select Spanish in WPML, you’ll see the translations for that language in the spreadsheet.
Besides, if you select Italian in WPML, you’ll see the translations for that language in the spreadsheet.
Step 3. Edit the translation relationship for all the events at once
In this example, we’ll use the Italian translations.
The first thing to do after WP Sheet Editor creates the translations is to edit the Translation relationship of all the events. If we do not change the Translation relationship of all events, all changes we apply to events in the main language will be applied to all translations.
The good news is that we can easily do it with the Bulk Edit tool, so open it with one click.
After opening the Bulk Edit tool, you need to select these values to edit the Translation relationship for all the events in the selected language.
- Select all the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
- What field do you want to edit: WPML – Relationship
- Select type of edit: Set value
- Replace existing value with this value: Translate separately
- Click on Execute Now.
After selecting these values, the Translation relationship of all the events will be edited.
Step 4. Edit the translations in the spreadsheet
After changing the Translation relationship for all the events, you can proceed to translate your events. In the following subsections, we’ll show you how to edit the following fields for your events: Title, URL Slug, Content, Excerpt.
a) How to translate event titles
To translate the event titles, you just need to go to the Title column and translate them all. Once you translate them all, click on Save to apply the changes.
Something great is that you don’t need to open the events. Just edit the titles and save changes once.
b) How to translate all the URL slugs
You could translate all the URL slugs manually and still save a lot of time. But we’ll show you how to translate all the URL slugs automatically copying the content from the Title column into the URL Slug column.
Start by opening the Bulk Edit tool with one click on the toolbar.
After that, select these values to translate all the URL slugs:
- Select all the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
- What field do you want to edit: URL Slug
- Select type of edit: Copy from other columns
- Copy from this column: Title ($post_title$)
- Click on Execute Now.
After these simple steps, your slugs will be automatically translated.
c) How to translate the events’ content
To translate the events’ content, you just need to go to the Content column. You have two options:
- Edit the events’ content using Gutenberg or TinyMCE. Just click on the button that will be displayed in each cell in the Content column.
- Edit the events’ content as simple text. You may need to use HTML if you choose this option in order to give format to the texts.
This is how the Gutenberg editor will look displayed in the WP Sheet Editor.
Once you finish editing the content for all your events, click on Save to apply the changes.
d) How to edit event excerpts
The event excerpts will be displayed as simple text in the Excerpt column, so you just need to edit the texts in that column and then click on Save to apply the changes.
Translate thousands of events quickly
With these simple steps, you’ll have translated thousands of events in seconds into several languages. This way you can create multi-language event websites quickly because you don’t have to spend lots of hours opening and editing your events one by one.
WPML and WP Sheet Editor are the best integration to quickly create and manage multi-language websites, stores, events, courses, etc. You can save thousands of hours and clicks.
You can download the plugin here: Download Events Spreadsheet Plugin - or - Check the features
Click here to read other tutorials on how to manage WPML translations with WP Sheet Editor.