How to import an Excel spreadsheet into an EasyBadge database

Modified on Tue, 23 May 2023 at 12:28 PM

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)

 

cid:image001.png@01D1DC32.B015A8A0

 

2. Select Import & Export from Menu

 

cid:image002.png@01D1DC32.B015A8A0

 

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.

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article