Export to Excel File

 

The Export to Excel File is used to export data from a translation project to a Microsoft Excel spreadsheet (.xlsx) file.

 

The source text of the source language, the translations of a target language and the Unique IDs is exported at least.

Optionally, a number of target languages can be exported and further item informations/data.

 

Related topics:"Import from Excel File", "Excel not required"

 

 

File Name and Data Page

 

The Export Assistant lets you adjust the export options to suit your needs and select the target language(s) to be exported.  The Assistant has two pages: the File Name and Data page (Figure 1) and the Format page (Figure 2).

 

 

Figure 1:  The "File Name and Data" page of the export assistant.

 

Control Elements:

 

·

File Name

The name of the file for exporting the selected data.  This can be the name of an existing file or of a new one. Use the Browse button to select a file.

 

·

Data

–

Selected items (radio button)

Check this option to import translations for all items currently selected in RC-WinTrans' Text Table view.

–

Selected file (radio button)

Check this option to import translations for all the items in the file currently selected within the translation project.  The name of the active file is shown in the field next to the option element.

–

Entire project  (radio button)

Check this option to import translations for all items in the active translation project.

 

–

Selected items (radio button)

Select this option to export all items currently selected in RC-WinTrans' Text Table view.

–

Selected file  (radio button)

Used to export all items from the source file that is currently selected.  The name of the file is shown in the field below the option element.

–

Project (all files)  (radio button)

Select this option to export translations for all the items in the active translation project.

 

Use this check boxes to specify the state of the translation units that will qualify for the export operation:

®

translated

Exports items with the translation status "translated" and "final."

®

not translated

Exports translation units that do not have the translation status "translated" or "final." These are, for example, items with the translation status "new," "needs-review," or "not translated."

®

changed source

Exports items with the translation status "changed source."  These are items that have already been translated but where the source text has changed since the translation was entered.

 

·

Options

–

Remove ampersand (&) from source and target texts

Check this option to export the source and the translation without a hotkey specification character ("&").

–

Append data to end of file

Checking this box to append the exported data to the end of the file.  If it is unchecked a new file will be created.

 

·

Languages

A list of the project's target languages.  Check the boxes next to the languages for which data should be exported.

 

 

Format Page

See Figure 2 and descriptions below.

 

 

Figure 2:  The  "Format" page of the export assistant.

 

 

·

Additional Columns

–

Unique ID

The Unique ID is always export to a separate column.

The unique ID can be used to identify the item when importing translations -- as a match criterion.

–

Item name

Select to export the item name/ID.

It is not required to export this data. It is not used when importing translations.

–

Source file name

Check this option to export the name of the source resource file to which an item belongs.

It is not required to export this data. It is not used when importing translations.

–

Previous source text

Select to include the previous source text among the exported data.  "Previous source text" refers to the source text that existed for the item before the source text was modified.  A previous source text exists when the current source text is either new or changed.  In this case the item has the translation status "changed source."

–

Translation state

An item's translation status.

–

Notes

Select to export an item's note. Exported are the note for the source and the note assigned to target -- each to a separate column.

 

·

Preview  (list box)

A preview of the file data as it will appear in the exported file.