1. Help Center
  2. Supported formats

Excel XLSX

Everything you need to know about translating Excel XLSX spreadsheets and how to handle them in Phrase.

File Extensions .xlsx
API Extension xlsx
Import Yes
Export Yes
Pluralization supported? Yes
Descriptions supported? Yes


Excel 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 Excel XLSXs using Phrase, you need to provide at least the key name column and one translation column. By default, the content is assumed to start in the first row. Along with the keys and translation you can also import meta-information like comments, tags and the maximum characters allowed for the translations.

Params

Locale Mapping

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.

Format Options 

Key name column

Identifier key_name_column  
Type string  
Upload Yes      
Download No
Default [empty]
Description Column that contains the key name/identification.

Comment column 

Identifier comment_column  
Type string  
Upload Yes    
Download No    
Default [empty]
Description Column that contains comment/description for a key.

Tag column

Identifier tag_column
Type string  
Upload Yes  
Download No    
Default [empty]
Description Index of the column containing a tag for the key. 

       
First content row 

Identifier first_content_row
Type integer  
Upload Yes    
Download No
Default 1
Description Index of first row to contain translation content.

Enable pluralization

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.

Export tags

Identifier export_tags
Type boolean
Upload No    
Download Yes    
Default false 
Description Exports tags along with keys and translations.

Export max characters

Identifier export_max_characters_allowed
Type boolean
Upload No    
Download Yes    
Default false 
Description Exports the key character limit along with keys and translations.

Code Sample 

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

Configuration example

An example for the push section in your .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

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?