How do I import a word list from a spreadsheet?
This lesson shows how to import word lists from tab-delimited text files created by a spreadsheet program. In steps 1 and 2, we'll see how to make sure that a list is saved in the proper format.
Create or open a word list in a spreadsheet program.
The items in each column should match: in this example column A has new vocabulary, column B has translations, column C has the names of sound files to be included, and column D has examples of usage.
Under the File menu, Choose "Save as.." Then select "Text (Tab delimited)" format and click "Save."
Open Sona List Converter.
Double-click on the Sona List Converter icon.
Check the settings for your list.
1) Since the order of columns in our German list was target word, translation, sound, and example, we'll choose those options in the popup menus. We leave items 5 and 6 set to "none."
2) Check the 'unicode' box for languages like Russian, Hindi, or Hebrew that do not use the Latin alphabet.
3) When this box is checked, List Converter will append " Sona" to the end of the file name; for example, when converting "German list.txt," a copy in Sona format will be saved as "German list Sona.txt."
4) When this box is checked, the folder where your converted list is saved will be opened in the Finder/Windows Explorer.
Click on "Convert."
This will bring a dialogue box where you can choose the list.
Choose the tab-delimited list and click "Open."
Sona List Converter creates a new list in the proper format.
List Converter copies your list, converts it list to Sona format, appends " Sona.txt" to the name, and opens the window where the new list has been saved.