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

Example

. | 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 Name of the column containing the key name/identification.
translation_columns hash Hash mapping each locale name to the column it is contained in.
comment_column string Name of column containing comment/description for a key.
first_content_row integer 1 Index of first row to contain translation content.
enable_pluralization boolean false Enables detection of pluralized keys. All matching keys will be persisted as pluralized keys.

Pluralization

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:
inbox.messages.notification.one
inbox.messages.notification.other

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