Is This Content Helpful?
We're glad to know this article was helpful.
When importing records from an Excel workbook only 100 records are geocoded.
The provided workflow shows how to create new Excel workbooks with only 100 records in each so that all locations can be imported.
Business Analyst Online has a limitation of importing only 100 records per Excel workbook.
The following workaround shows how to make multiple workbooks and copy the remaining records in increments of 100 into each new workbook. Business Analyst Online then imports the individual workbooks to reflect all geocoded sites.
If the first 100 records have already been imported into Business Analyst Online, Excel workbooks only need to be created for the remaining records.
Processing more than 100 locations with rings, drive times or donuts may decrease performance of the application.