Excel XLSX

Excel spreadsheet file format. You have to provide at least the key name column and one translation column. By default the content is assumed to start in the first row.

File Extensions .xlsx
API Extension xlsx
Format Options key_name_column, translation_columns, comment_column, first_content_row, enable_pluralization
Import Yes
Export Yes
Pluralization supported? Yes
Descriptions/Comments supported? Yes


. | A (Key name) | B (English)             | C (German)                | D (Comment)             |
1 | app_title    | My Software Project     | Mein Software Projekt     | This is the main title  |
2 | greeting     | Hello 'User' ! Welcome  | Hallo 'User' ! Willkommen | Be polite               |
3 | ...          |  ...                    |  ...                      |  ...                    |

Format Options

Option Type Upload Download Default Description
key_name_column string check close Name of the column containing the key name/identification.
translation_columns hash check close Hash mapping each locale name to the column it is contained in.
comment_column string check close Name of column containing comment/description for a key.
first_content_row integer check close 1 Index of first row to contain translation content.
enable_pluralization boolean check close false Enables detection of pluralized keys. All matching keys will be persisted as pluralized keys.


This format uses named categories to identify the different pluralizations of a key. The following categories are reserved for pluralization:

.zero | .one | .two | .few | .many | .other

Example key names:

This way pluralized keys can be identified, persisted and marked accordingly.
Learn more about pluralization?