1. On the top of your excel table add one row and enter data field names that are used by Handy Library Manager.
2. In this case the following names were entered into the corresponding columns: TITLE, AUTHOR, TYPE, PUBLISHER, PLACE, PUBLISHED, CATEGORY, LEVEL, FORMAT, PAGES, CALL, ISBN

1. Save your excel table as a text tab delimited file.
2. Click Save As, select Other Formats.

1. In the Save As type box select Text (Tab delimited). Your file will be saved as a text file and data will be delimited by tab character.

1. Enter your name into the File Name box. Click Save.

1. Start Handy Library Manager, on the Add Items/Patron tab click Add Library Items.

1. On the Add Items tab click Add Items From Text File.

1. Click Select.
2. Select the text file that you created in Excel.
3. Content of the selected file is displayed in the Text File Contents box.
4. Click Next.

1. Under Fields Separated By select TABs.
2. Under Fields Delimited By select Nothing.
3. In the Import Fields section check First Line Contains Field Names.
4. Click Preview On Screen, verify 3 imported records.
5. Click Next.

1. Click Start Import.

1. Verify the number of records.
2. Click Yes to continue.

1. Verify if the number of imported records is correct.
2. Click Close.

1. New items are added into the LIBRARY_NEW table.
2. Verify your items, add missing data.

When your items are ready for circulations move them to your LIBRARY main catalog.

If you want the program to generate unique barcode numbers for you, do not enter barcode values into the barcode field.