I am trying to import a list of addresses from an Excel file, using the Bulk Add form. Many of the Excel files I have, contain multiple tabs, all with different address information. I have tried to use 2 important columns- "PointName and Address" in the first tab only. After choosing the file and clicking Import, "Your Data File is missing the 2 main column names" appea
Bulk Add- can I import a list of addresses from an Excel file with multiple tabs?
- 876 Views
- Last Post 18 November 2015
That's a good question. I haven't tried an Excel file with multiple tabs so I don't know.
I know for sure that the system will only import from 1 tab and that is the first tab.
Yo cannot have spaces between rows and the first row is the headings.
The address has to be in one cell only (or column if you will)
I would put the data in just one tab.