WPML – How to Bulk Translate Events Quickly

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.

wpml translate events

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.

wpml translate events

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.

wpml translate events

The same happens when we select Italian. We won’t see any events because we don’t have any translations for Italian.

wpml translate events

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.

wpml translate events

In this example, we’ll translate all the events into Spanish and Italian at once, so we need to select these values.

wpml translate events

  • 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.

wpml translate events

Besides, if you select Italian in WPML, you’ll see the translations for that language in the spreadsheet.

wpml translate events

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.

wpml-translate-events

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.

wpml translate events

  • 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 SlugContentExcerpt.

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.

wpml translate events

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.

wpml translate events

After that, select these values to translate all the URL slugs:

wpml translate events

  • 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:

wpml translate events

  • 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.

wpml translate events

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.

wpml translate events

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.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.