To open the 'Import from Excel' window, choose Import / Excel from the File menu.
The first you need to do is to create a new import definition. In the 'Add New' window you must give the new import definition a name, and select the table you want to import data into. You can import data to any table, for example Book, Contents, Want List, or any of the lookup tables (Person, Publisher, Genre, etc.).
This window has two tabs (three if you import book data): General and Fields (or General, Book Fields and Contents Fields when importing book data). Click the Help button for more information about the options on these tabs.
Click the Import button to start the import process.