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" appears. Does the Bulk Add tool not allow you to import information from Excel files with multiple tabs? If not- is the only solution to create a new Excel file with one tab?
Bulk Add- can I import a list of addresses from an Excel file with multiple tabs?
- 916 Views
- Last Post 18 November 2015
Admin posted this 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.