The CSV Format

The CSV format (Comma Separated Values) is a file format in which the data are separated by punctuation (such as a comma or semicolon). This format is particularly well suited for the simple exchange of (terminology) tables.

Any terminology in Excel files can easily be saved as CSV files for import to Across:

To do this, click File > Save as in Excel and select CSV as the file type in the following window. This file can easily be imported to crossTerm. If your terminology contains non-Latin characters (e.g. in Cyrillic or Greek script) or other special characters, you should save the terminology as Unicode text file (*.txt). This process creates a CSV file with the file extension *.txt, which automatically uses tabs as separators. Subsequently, this file can easily be imported to crossTerm.

If there are several values for the category to be exported (e.g. several subjects), these values will be separated from each other by means of the record separators (icn_datensatztrennzeichen, 0x241e and U+241E) in the corresponding cell of the CSV file.

drittprogramm_excel_csv_datentrennsatzzeichen

When re-importing the exported CSV file, the record separators will be identified and the values will be imported correctly.

The first row of a CSV file may contain column headings with information on the content of the particular columns. It is recommended that, before you start the import, you check the CSV file to see whether the file you would like to import has column headings. To do this, open the CSV file and check if the first row of the file contains information on the content of the individual columns or whether it already contains terminology data.

CSV file with column headings
CSV file without column headings
The first row of the CSV file contains information on the content of individual columns.
The first row of the CSV file contains terminology data.
drittprogramm_ms-excel_csv_mit-spaltenueberschriften
drittprogramm_ms-excel_csv_ohne-spaltenueberschriften