Skip to content
Aron Heinecke edited this page May 13, 2022 · 29 revisions

You can import vocable lists from CSV files.
See also import/export format.
Please note that your file has to be UTF8 encoded.

After you have selected your CSV file it'll be scanned to detect whether it's a multi-list, a list with meta-data (list name, column names) or raw data (see import/export format). Then you can select what you want to do in certain cases. Please note that name and column names have to match for a list to be recognized as already existing.

The following options are available when importing, based on the type of CSV file you have:

  • Raw Data (not using the special format, plain data):
    • Create a new list with your CSV data.
    • Append list data to an existing list.
  • Multi-List:
    • Replace lists when already existing
      Existing lists will be replaced with the list entries from your CSV file.
    • Append to lists when already existing
      Merge existing lists with the list in your CSV file, additive (no deduplication).
    • Ignore existing lists completely
      All existing lists won't be changed, only new lists will be imported.
  • Single-List:
    • Replace list when already existing.
    • Append data to list when it's already existing.
    • Create a new list, regardless whether it's already existing or not.

Full example - Multilist - Multimeaning

spreadsheet view
Exported as CSV File:

TABLE\,//INFO,//START//,
Test Table 1,English,German,
Chair,Stuhl,something to sit on,
TABLE\,//INFO,//START//,
Test Table 2,English,German,
run,fahren/laufen/rennen/arbeiten,using your legs,"ran, run"
drive,fahren,mit dem auto,"drove, driven"

On import:

Preview after file selection & default CSV Format:

In Editor (Test Table 2)

Clone this wiki locally