How do I import from a Microsoft Excel sheet into Byki?

Knowledge Base
	Byki 4 Deluxe
		I updated Byki and my learned items are missing!
		I would like to transfer my user data to another machine.
		My Byki lists are missing!
		What is the size of the download?
		How do I use the new Byki on my iPod / mp3 player?
		I can't hear any sound in Byki 4!
		I am having problems typing special characters in Byki 4.
		I upgrade to Byki Deluxe and can't find any of my new lists!
		I am trying to download more than one free language
		My answer is marked wrong, but I know I'm right!
	Transparent Language - Complete Edition
	Transparent Language - Premium Edition
	Kidspeak
	Everywhere Audio
	Panoramic LinguaMatch
	Lexicon Dictionary
	Transparent Language Library Edition
	Byki for iPhone / iPod Touch
	Byki Online - Library Edition
	Word of the Day

Importing Lists from Microsoft Excel

Byki allows you to import lists that were created as .xls files in Microsoft Excel. This feature can save you time if you already have lists in that format that you would like to use with Byki.

Note:This feature is only available in Byki Deluxe, not in Byki Express. This feature also requires that Microsoft Excel 2000 or higher be installed on your computer.

To import a list from a Microsoft Excel spreadsheet:

Create the list in Microsoft Excel. If you have an existing spreadsheet, check that the information is arranged properly, as described below.

Important:

Each row in the spreadsheet must contain the information for a single card. Do not skip any rows, and do not put information for more than one card in the same row. Do not include any other information in the spreadsheet outside of the text for the list.

In each row, the text should be arranged in the following order:

The side one and side two text is required. The rest of the information is optional. If your list does not require hints, card comments, or transliterations, you do not have to put in that information. You can import a list which includes just side 1 text and side 2 text in the first two columns if you prefer.

You can include some of the optional fields without including others. However, if you do so, you must make sure that the information is in the correct column. For example, a card comment must always be in the fifth column, even if the third and fourth columns are empty.

When you are typing the information, do not put extra spaces before, after, or in the middle of the text for either side of the card. Be sure to spell everything correctly, so that you can learn the information correctly.

If you are typing a list for a language that does not use the Latin alphabet, you must use an appropriate font for the foreign characters. The Arial font that comes with Windows is often a good choice. Arial contains characters for many languages. If you are working with a language that is not supported by Arial, make sure you are using a Unicode font that has more than 256 characters with the Latin characters placed first.

Your text can use any of the special formatting supported by Byki, including bold text, italics, underlines, superscript, subscript, and colors. The supported formatting will be preserved when the list is imported. Alternatively, you can import plain text and change the formatting after the list has been imported.

If you want to see an example of a .xls file with a properly formatted list, use the Export feature to export any of your Byki lists as an .xls file, then look at how the list is set up in Microsoft Excel.

After you have entered all your information, save the file with the extension .xls, then close the spreadsheet. You cannot import a spreadsheet while it is open in Microsoft Excel.

In Byki, do one of the following to open the Import screen:

Go to the Select a List screen and click Import List.
Choose List / Import List.
Press Ctrl+I.
In the Files of Type field, select word, excel files (*.doc, *.xls).
The names of any .xls that are in the same directory as Byki appear. If the spreadsheet you want to import is in a different location, such as another directory, a CD, a diskette, or a network drive, browse to that location.
When you see the name of a spreadsheet that you want to import, select it. You can select more than one list at a time if they are in the same location.
Click Open. The Import Lists screen will appear.
Choose one of the following options to indicate how you want the list to be available:
Mark the Import Only for Me option if you would like the list to be available only when you are logged in to the program.
Mark the Import For All Users option if you want the list to be available to all the users on this computer.
When you are ready to import the files, click Import.
You will be asked to select which worksheet from the file you wish to import. Select an option from the menu or type the appropriate information, then click Continue.
The List Creation Wizard will appear, so you can go through the process of creating the new list. You will need to enter a language or a subject, a list name, and all the other applicable information. When you finish, the Import List screen will reappear, and the data for the list will be imported.
When you see the status for all the lists on the Import Lists screen change to Complete, click Close to close the Import Lists screen.

Things to keep in mind about imported lists:

The next time you run Byki, you can select the imported list directly from the Select a List screen. You don't need to import the list every time you run it.

If the information for the sides of the cards in an imported list is reversed, you can use the Swap Sides button on the Edit screen to fix each card.

Lists imported from Microsoft Excel will not include sound, pictures, video, or More Content, although you can edit the cards to add such features. You can also edit any of the text on the cards as needed.

All the cards in imported lists will be given a score of zero when they are first imported. However, you can raise this score if you feel it is inappropriate. See Understanding Scores and Adjusting Scores for more details.

As with any editable document, you should verify the content of any imported lists independently. Transparent Language, Inc. is not responsible for the content of any lists created or edited by any outside sources. Transparent Language can only vouch for the unedited lists that we officially distribute.