How to Export Emirates ID data to Excel

To Export card holder’s data to Excel, follow these steps:

1. Create an Excel file with the first row containing names of the fields you have selected in the Data tab. Ready example of such an Excel file can be downloaded HERE.

Order of the Fields to Export must match the Excel header like on the example shown below:

2. Go to the Excel tab in Options and check the Export to Excel. Select the Excel file from step 1 and provide a name of the sheet you want to save the data to. To ensure that numerical data like an Emirates ID card number are displayed correctly either check the Number as String or set the cell format in Excel to number.

With this configuration, the data from each ID card you scan will be saved to a new row in the Excel file.

Copyright © 2022 Glass-Spider