Skip to content

Import Export Format

Aron Heinecke edited this page May 13, 2022 · 21 revisions

Note: This site only documents a specific way of Vocabletrainer to note down list data.
It does not cover different CSV Formats which is the data layout that's in use.

Export & Import of lists are possible via UTF8 encoded CSV Files.

You can create and edit such files manually via any spreadsheet program (for example LibreOffice Calc) via export to CSV.

Multi/Single list notation

See also the import example.

Raw Data format

A plain CSV file of vocable entries in order of A | B | Tip. Tip being optional.

Example:

Stuhl,Chair,My Tip
Zahl,Number
Hähnchenflügel,buffalo wing,edible
...

Multi-List format

A special delimiter line is used in VTA to allow export/import of multiple lists in one CSV file.
This special line is defined as TABLE\,//INFO,//START// followed by the table meta data in order List Name,Column A Name, Column B Name.

Example:

TABLE\,//INFO,//START//
Test Table,German,English
Stuhl,Chair,My Tip
...
TABLE\,//INFO,//START//
Another Table, Col A, Col B
A1, B1, Tip1
A2, B2, Tip2
...

Single-List Format

The same as multi-list, except there's only one list specified in the CSV data.

Example:

TABLE\,//INFO,//START//
Test Table,German,English
Stuhl,Chair,My Tip
...

N:N Vocable notation

VTA supports N:N entries, one entry, multiple meanings / definitions, possibly on both columns (A,B).
Per default / is the delimiter for meanings and \ the escape char.
See options in the custom format dialog.

Example:

For locker,lose | loose,casual | My Tip
(Multi list format)

TABLE\,//INFO,//START//
Test N:N Table,German,English
locker/lose,loose/casual,My Tip
...

(Or as raw data format)

locker/lose,loose/casual,My Tip
...