This flexible parser is tailored for Excel files without specific formatting constraints. You can upload and download single-language files, maintain original formatting, handle merged cells, and enjoy various other features.

You can find more information about the capabilities of our parser below.

Source and translation strings reside in separate Excel files. When you upload existing translations for a specific language, please make sure that the Excel file contains strings in that language exclusively. Likewise, downloading a translation file from Transifex will include translations for the specified language only.

Here are some examples of excel files and the content inside that can be handled by the parser.

When an Excel file containing source content for translation is uploaded, the Transifex parser includes all extracted strings in the project's source language. If source strings reside in multiple sheets, the parser identifies and extracts these strings from all sheets, consolidating them into a single resource within Transifex.

When processing Excel files, our parser begins by parsing the names of the sheets. Subsequently, it moves through the content by starting from the first sheet and then navigating through all sheets in the order presented in the spreadsheet. Additionally, it reads the content horizontally within each sheet. This means that it processes cells in a left-to-right, top-to-bottom fashion—beginning with A1 and moving sequentially through the rows and columns.

This parsing strategy ensures that each piece of content is accurately captured and processed according to its location in the Excel file.

When strings are created in Transifex, a developer note is associated with each string, containing the name of the sheet(s) to which the specific string belongs.

When a text value results from a formula, it is not considered translatable text. After requesting a translation file export, these formulas will remain intact in the exported localized version.

An exception is made for formulas of the type: HYPERLINK("https://app.transifex.com", "transifex"). The link is treated as a translatable string (specifically, the "transifex" part). After requesting a translation file export, the formula remains intact, and the translatable text is provided in the corresponding target language.

It's important to note that utilizing LOOKUP in your sheets might result in encountering N/A values in the localized version of Excel. This discrepancy arises because the localized text may no longer align with the criteria for your lookup.

If duplicate source strings are identified across sheets, only one instance will be processed and stored in Transifex. In this case, a singular source string will be generated, with its key determined by a hash derived from the source text of the string.

When formatting is applied to source strings, it is represented using <tx> placeholders in the Transifex Web Editor. The translation should also preserve these placeholders to ensure consistent formatting across languages.

You can enable translation checks described here to make sure these tags are preserved in the translation. If the translator does not adhere to the correct number and position of these placeholders, a warning or error will be displayed in the editor.

The following table summarizes the results returned depending on download mode:

*The results are compatible with parser version 1.