How to import an Excel spreadsheet into an EasyBadge database

To import from an Excel (xls) spreadsheet into EasyBadge first ensure you have saved your spreadsheet as an XLS or XLSX file and only text data is contained in each cell of the spreadsheet without any functions or links.

1.  Click the options button (white box with 3 lines)

2. Select Import & Export from Menu

3. Click From Excel (xls, xlsx)

4. Browse to your Excel file ( in this example it is called EasyBadge Import) select it and click open.

5.  In the ‘To’ (the spreadsheet) Column marry up all the fields to the corresponding ‘from’ (the database) column.

6. If you are doing a one time import of data click ‘next’

7. Give your import a name and click ‘Save’

8.  Finally Click the ‘Process’ button to run the import. The Import will then run and close when complete.