Spreadsheet Translations icon

Spreadsheet Translations

Plugin screenshot thumbnail 1/4
Plugin screenshot thumbnail 2/4
Plugin screenshot thumbnail 3/4
Plugin screenshot thumbnail 4/4

This plugin enables non-developers to access static translations via a Google spreadsheet.


This plugin requires Craft CMS 3.1.0 or later.


To install this plugin, follow these steps:

  1. Install with Composer via internetztube/craft-spreadsheet-translations
  2. Install the plugin in the Craft Control Panel under Settings > Plugins You can also install this plugin via the Plugin Store in the Craft Control Panel.


Please report any issues you find to the Issues page.

Dynamic Strings

  • You CANNOT translate dynamic strings. Please use the message parameter.

      {{ ("Welcome back, " ~ currentUser.friendlyName ~ "!") | t }}
      {{ 'Welcome back, {name}!' | t(params = { name: currentUser.friendlyName}) }}
  • Only translations made in Twig with the {{ "..." | t }}-filter get pushed automatically into the spreadsheet.

Console Utilities

  • Pulls all translations from the spreadsheet into static files on the disk. No handles get deleted!
      php craft spreadsheet-translations/main/pull-translations
  • Pushes all missing translation handles from the templates into the spreadsheet. No handles get deleted!
      php craft spreadsheet-translations/main/push-missing-handles
  • Pushes all missing site languages into the spreadsheet. No languages get deleted!
      php craft spreadsheet-translations/main/push-missing-languages

These utilities are also available in the control panel in the Utilities section.

Setup / Settings

Google API

For this plugin a Google API token is mandatory. Here you will be shown how to create one.

  1. Go to https://console.developers.google.com/apis/library/sheets.googleapis.com.
  2. Click ENABLE.
  3. Click Credentials in the sidebar.
  4. Click Create Credentials and then select Service account key.
  5. Click Select... and create a new Service account or use an existing Service account.
  6. Just fill in a name and an eMail prefix. You will need the eMail address in a further step.
  7. Keep JSON as Key type.
  8. Click Create.
  9. This Service account DOES NOT need a special role. So click CREATE WITHOUT ROLE in the modal.
  10. A JSON file had been downloaded. The contents of this file must be copied to the Contents of the access key file-field in the plugin's settings.
  11. Go to your Spreadsheet and share it with the eMail Address of the Service account.

Google Spreadsheets

In addition to the Contents of the access key file, the Spreadsheet Id and the Sheet Name where the Translations are located is required in the settings.

Spreadsheet Id

The Spreadsheet Id is just a part of the URL.


https://docs.google.com/spreadsheets/d/11fRj44MwhGqFGpIYHGfwpA69ed-Z657WdiXex6kvuo8/edit -> 11fRj44MwhGqFGpIYHGfwpA69ed-Z657WdiXex6kvuo8

Sheet Name

This is the name of the sheet, where the translations are stored, which should be applied for this project. This string gets slugified. DEV: Translations -> dev-translations.

Brought to you by Frederic Köberl


Plus $5/year after one year.

Installation Instructions

To install this plugin, copy the command above to your terminal.

Active Installs
Craft 3, Craft 4, Craft 5
Last release
April 9, 2024
Activity (30 days)
Closed Issues
Open Issues
Merged PRs
Open PRs