Supported File Types (Strings)

.XLSX - Spreadsheet Excel (Strings)

File Extensions

.xlsx

API Extension

xlsx

Import

Yes

Export

Yes

Plural forms support

Yes

Description support

Yes

Format options

locale_mapping

key_name_column

comment_column

tag_column

first_content_row

enable_pluralization

export_tags

export_max_characters_allowed

.XLSX is a widely-used file format for localization. Though the layout of an .XLSX file may differ based on specific settings, it generally follows the one-column-per-language convention. To translate .XLSX, provide at least the key name column and one translation column. By default, content is assumed to start in the first row. Along with the keys and translation, meta-information like comments, tags and the maximum characters allowed for the translations can be imported.

Format Options

Identifier

locale_mapping

Type

hash

Upload

Yes

Download

No

Default

[empty]

Description

Hash mapping each locale name to the column name it is contained in.

Identifier

key_name_column

Type

string

Upload

Yes

Download

No

Default

[empty]

Description

Column that contains the key name/identification.

Identifier

comment_column

Type

string

Upload

Yes

Download

No

Default

[empty]

Description

Column that contains comment/description for a key.

Identifier

tag_column

Type

string

Upload

Yes

Download

No

Default

[empty]

Description

Index of the column containing a tag for the key.

Identifier

first_content_row

Type

integer

Upload

Yes

Download

No

Default

1

Description

Index of first row to contain translation content.

Identifier

enable_pluralization

Type

boolean

Upload

Yes

Download

No

Default

true

Description

Enables detection of pluralized keys. All matching keys will be persisted as pluralized keys.

Identifier

export_tags

Type

boolean

Upload

No

Download

Yes

Default

false

Description

Exports tags along with keys and translations.

Identifier

export_max_characters_allowed

Type

boolean

Upload

No

Download

Yes

Default

false

Description

Exports the key character limit along with keys and translations.

Structure example

key_name

en_US

de-DE*

comment*

tags*

max_characters*

app_title

My Project

Mein Projekt

This is the main title

app, title

30

greeting

Hi 'User'!

Hallo 'User'!

Be polite

*optional columns

The spreadsheet file needs at least the key column and one language in order to be uploaded. Apart from additional languages, the following columns can be added to add meta information:

  • comment: to add a description to the key

  • tags: to add tags to individual keys in the file

  • max_characters: to set a character limit for a key through the upload

Configuration example

An example for the push section in a .phraseapp.yml for XLSX files.

push:
    sources:
        - file: "./en.xlsx"
          params:
              file_format: xlsx
              update_translations: true
              format_options:
                  key_name_column: A
                  comment_column: C
                  first_content_row: 2
                  tag_column: D
              locale_mapping:
                  en: B
Was this article helpful?

Sorry about that! In what way was it not helpful?

The article didn’t address my problem.
I couldn’t understand the article.
The feature doesn’t do what I need.
Other reason.

Note that feedback is provided anonymously so we aren't able to reply to questions.
If you'd like to ask a question, submit a request to our Support team.
Thank you for your feedback.