Convert CSV/TAB Delimited File to TMX

Follow these steps to convert a CSV or TAB delimited file to TMX.

About this task

CSV (Comma Separated Values) are plain text files that contain text organized in tabular format, using commas to separate columns and quotes to delimit column content.
TAB delimited files are similar to CSV, but using TAB characters to separate columns and usually without column delimiters.
TMXEditor allows conversion to TMX of text files with different combinations of column separators and text delimiters.
Note
Note
Text files exported from Microsoft Excel use these default settings:
  • Character Set: UTF-16LE
  • Column Separator: TAB
  • Text Delimiter: none

Procedure

  1. In main menu, select File → Convert CSV/TAB Delimited File to TMX option or click the importDelimited.svg Convert CSV to TMX button on the top toolbar.
    The following dialog appears:
    Convert CSV File to TMX Dialog
  2. Type the name of the file to be converted in the CSV File text box or use the associated Browse... button to select a file from the system.
  3. Type the name of the TMX file to generate in the TMX File text box or use the associated Browse... button to select a file name and location.
  4. Use the Character Set, Column Separator and Text Delimiter drop-down boxes to define the format of the file to be converted. Use the preview panel to check the correctness of the selected settings. Use Custom Separator and Custom Delimiter text boxes to enter values not included in the drop-down selectors.
    On success, the preview panel displays the data in a tabular format. If language codes are included in the first row of the CSV file, they will be automatically detected and will also be displayed highlighted in the panel, as shown in this picture:
    Correct Settings Example

    Troubleshooting

    Unexpected characters, like the ones shown in the picture below, indicate wrong character set selection.
    Wrong Character Set Example
    Readable text that is not displayed as a table, is a sign of incorrect selection of column separator or text delimiter. Use the preview panel to check the correct values.
    Wrong Delimiters Example
  5. Click the Set Languages button if language codes are not included in the file or you wish to change the automatically detected ones.
    The following dialog appears:
    CSV/Text Languages Dialog
  6. Use the drop-down controls in the CSV/Text Languages dialog to select the languages in the CSV file. Click the Set Languages button to confirm your selection.
  7. Check the Fix Excel Double Quotes box if the file was exported by Excel using double quote characters as text delimiter. This option ensures that quotes are not duplicated during conversion.
  8. Check the Optional Text Delimiters box if the file does not use the selected text delimiter in all cases (some tools only surround text in delimiters when the de column separator is part of the exported text).
  9. Finally, click the Convert CSV to TMX button to generate the TMX file.

Results

The CSV file is converted to TMX and automatically opened in the editor if the Open Generated TMX File checkbox is selected.