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 Video, Contents, Want List, or any of the lookup tables (Person, Format, Genre, etc.).
This window has two tabs (three if you import video data): General and Fields (or General, Video Fields and Contents Fields when importing video data). Click the Help button for more information about the options on these tabs.
Click the Import button to start the import process.