Import Locations
Import Locations allows you to import Excel spreadsheets. You can import files with a maximum of 2000 records and a file size limit of 5 MB.
- Click the Color-Coded Maps tab.
- Click the Import Location tab.
- Click Browse to select the file that you want to import.
- Click Import.
The Import Locations dialog box appears.
- Confirm the column headings that will be extracted from the selected file. You can choose from Site Name, Address, City, ZIP, State, and/or Latitude and Longitude.
- Click Next.
- Type the name of the layer in the Layer Name text box, which is required.
- Select the location symbol. You can choose from the pin symbol, a shape symbol, or import a custom symbol. The default is the pin.
- Click Import.
- Click Next.
- If any corrections are needed, for multiple matches and invalid addresses, you can make the corrections and click Find Again or click Ignore All.
- The locations successfully found appear and are all checked by default.
- Click Add Selected Locations.
The Import Locations pane appears.
Once selected, the file name appears in the Import Excel spreadsheet text box.
You can select the column for your label, which is optional.
To use the shape symbol
Click on the radio button next to the shape icon and a pop-up appears for you to choose the shape, size, and color. The shape symbol is recommended for large file sizes.
Click the shape icon to close the pop-up.
To import a custom symbol
Click on the radio button next to the Import custom symbol text box and click Browse.
Select the file to upload.
The icon appears in the Import Locations dialog box next to the radio button.
The Import Locations dialog box appears with the import progress results. Invalid addresses and multiple matches can be corrected in the following dialog box.
The symbol you chose for the selected locations appears on the map. By default the My Layers dialog box opens with the newly added layer selected.