How do I create an Excel file for import?
1. Create an Excel file where each column represents a word field. The minimum required columns are “Native language” and “Learning language”. You can also add optional columns such as “Transcription”, “Examples,” or “Genders.”
The Excel file can have one of the following formats:
a) Plain words (without categories or subcategories) (download Example)
b) Words organized into subcategories (download Example)
Subcategories and sub-subcategories in the Excel file can be denoted as follows:
– by a single asterisk (*) before the subcategory name
– by two asterisks (**) before the sub-subcategory name
2. Save the file in .xlsx or .xls format and copy it to your device.
3. Import the file through Menu → Import in the app.
4. During import, use the drop-down menus to match Excel columns to the corresponding word fields.
If the wrong column is selected, the data will be imported into the wrong fields.
Example of how categories appear in the app after import.
The sub-subcategory **Verbs 2 was placed under the subcategory *Verbs in the Excel file,
so it is imported into the Verbs subcategory in the app.
You may also find these articles helpful: