Shopify Translations Import / Export spreadsheet template Matrixify

Bulk Import and Export Shopify multi-language data Translations from Shopify Admin -> Settings -> Languages section.

See what each field/column from our “Translations” template means, including possible allowed values and examples.

Columns marked as “Export Only” cannot be imported/set in Shopify, but can be exported with Matrixify Export.

Excel Sheet Name

Translations

Need a quick start?

Download Translations Demo import file

Columns Available For Export And Import

Basic Columns

Column	Description / Example Value
Entity	The Shopify resource type that the Translation row belongs to. Each row in the Translations sheet describes a single translatable field of a single entity. This column tells Matrixify what type of item is being translated. Mandatory column when importing so that the app can find the correct entity in your Shopify store. Allowed Values Product Collection Page Blog Blog Post Metaobject Menu Shop Example Product
Entity ID	The Shopify internal ID of the Entity that this Translation row belongs to. When the Entity is Shop, this column can be left empty – your shop is identified automatically. Allowed Values Shopify internal ID Example 51920047631
Entity Handle	The Handle of the entity that this Translation row belongs to. Mandatory when importing Translations. Allowed Values Different structure depending on the Entity and Field the Translations belong to: `Product`: for `Variant Metafield: ...` Field, the Entity Handle is a combination of Products Handle and Variant Title (Option Values separated by `/`) as `<product_handle>.<variant title>` to identify the full variant the metafield belongs to, e.g. `natural-honey.250g / Wild raspberry`, for `Option1 Value` Field, the Entity Handle is a combination of Products Handle and Option Value as `<product_handle>.<option value>`, for example, `natural-honey.Wild raspberry`, for all other Product Fields, only a Product Handle, e.g. `natural-honey`. `Collection` – for all Collection Fields, the Entity Handle is the Collection’s Handle, e.g. `cool-looking-tshirts`. `Page` – for all Page Fields, the Entity Handle is the Page Handle, e.g. `contact-us`. `Blog` – for all Blog Fields, the Entity Handle is the Blog Handle, e.g. `summer-blog`. `Blog Post` – for all Blog Post Fields, the Entity Handle is a combination of Blog Handle and Blog Post Handle as `<blog_handle>.<blog_post_handle>`, for example, `summer-blog.best_shirts_for_summer`. `Metaobject` – for all Metaobject Fields, a combination of Metobject Definition Handle and Metaobject Entry Handle as `<definition_handle>.<entry_handle>`, e.g., `manufacturer.Robert-Jones`. `Menu`: for `Title` Field, the Entity Handle is the Menu Handle, for example, `main-menu`. for `Menu Item Title` Field, the Entity Handle is a dot-separated Menu Item hierarchy as `<menu_handle>.<Menu Item Title>`, for example, `main-menu.Compliance.Refund Policy`. `Shop`: – Entity Handle is empty for all Shop Fields.
Field	The specific translatable field of the Entity that the row applies to. The available Field values depend on the entity type. Mandatory when importing Translations. Allowed Values Different possible values depending on the Entity being translated: `Product`: `Title` `Handle` `Body HTML` `Type` `Option1 Name` `Option1 Value` `SEO Title` `SEO Description` `Metafield: <namespace.key>` `Variant Metafield: <namespace.key>` `Collection`: `Title` `Handle` `Body HTML` `SEO Description` `SEO Title` `Metafield: <namespace.key>` `Page`: `Title` `Handle` `Body HTML` `SEO Description` `SEO Title` `Metafield: <namespace.key>` `Blog`: `Title` `Handle` `SEO Description` `SEO Title` `Metafield: <namespace.key>` `Blog Post`: `Title` `Handle` `Body HTML` `Summary HTML` `SEO Description` `SEO Title` `Metafield: <namespace.key>` `Metaobject`: Metaobject Field key `Menu`: `Title` `Menu Item Title` `Shop` `SEO Description` `SEO Title` `Metafield: <namespace.key>` Example Body HTML
Original Value *Export Only*	The current value of the Field in your store’s base language. This column is provided as a reference so that you (or your translators) can see the source text side-by-side with each translation. It is ignored on Import – to change the base-language value of an entity, use the corresponding entity sheet (Products, Pages, etc.) instead of the Translations sheet.

Translations

The Translations column group contains a set of three columns for each Language enabled in your Shopify store. The locale two-letter code is appended to the end of each column header, for example, Translation Value: lv.

Column	Description / Example Value
Translation Value: <Language Code>	The translated text for the Language specified in the column header. This is the column you actually edit to translate your store. Leave it empty to remove an existing translation for that language and Field. Allowed Values Text
Translation Is Outdated: <Language Code> *Export Only*	Shopify flags a Translation as outdated when the base-language value of the Field has changed after the Translation was last saved. The Translation still shows in the storefront, but Shopify warns merchants that it may no longer match the source text. On export, this column shows TRUE for Translations that Shopify has flagged as outdated, and empty for others – useful for filtering your file down to just the Translations that need a refresh.It cannot be set or imported by a user; Shopify adjusts it automatically. Possible Values TRUE FALSE Example TRUE
Translation Updated At: <Language Code> *Export Only*	The date and time when the Translation for this Field and language was last updated in Shopify. Useful for sorting and auditing – for example, to find all translations that haven’t been touched in a year. Possible Values Date & Time Example 2026-05-22 09:51:41 +0300

Column

Description / Example Value

Translation Value: <Language Code>

The translated text for the Language specified in the column header.
This is the column you actually edit to translate your store. Leave it empty to remove an existing translation for that language and Field.

Allowed Values

Text

Translation Is Outdated: <Language Code>

Export Only

Shopify flags a Translation as outdated when the base-language value of the Field has changed after the Translation was last saved. The Translation still shows in the storefront, but Shopify warns merchants that it may no longer match the source text.
On export, this column shows TRUE for Translations that Shopify has flagged as outdated, and empty for others – useful for filtering your file down to just the Translations that need a refresh.It cannot be set or imported by a user; Shopify adjusts it automatically.

Possible Values

TRUE
FALSE

Example

TRUE

Translation Updated At: <Language Code>

Export Only

The date and time when the Translation for this Field and language was last updated in Shopify.
Useful for sorting and auditing – for example, to find all translations that haven’t been touched in a year.

Possible Values

Date & Time

Example

2026-05-22 09:51:41 +0300

Export Filters

In the Matrixify app, you can apply filters to export only specific items from your Shopify Store.
When creating a new export, select what you wish to export, and under that entity, click on the Filters button.

Note: the total displayed item count and estimated time won’t be affected by the filters applied.

Filter	Description
Entity	Limits the Export to Translations of selected Entity types only. Possible Values Product Collection Page Blog Blog Post Metaobject Menu Shop

Filter

Description

Entity

Limits the Export to Translations of selected Entity types only.

Possible Values

Product
Collection
Page
Blog
Blog Post
Metaobject
Menu
Shop

Translations

Excel Sheet Name

Need a quick start?

Columns Available For Export And Import

Basic Columns

Allowed Values

Example

Allowed Values

Example

Allowed Values

Allowed Values

Example

Translations

Allowed Values

Possible Values

Example

Possible Values

Example

Export Filters

Possible Values

Start managing your Shopify data today!