To generate an import file using a spreadsheet:
-
Create a spreadsheet using Excel with column labels in the first row. Columns should be displayed in the following order:
Tag
The name of the marker.
PrimaryCategory (optional)
The name of a primary category for the marker.
Radius (optional)
The radius, in feet, of the marker.
Lat
The latitude of the location. When using latitude and longitude, do not include address information.
Lon
The longitude of the location. When using latitude and longitude, do not include address information.
Address
The street address.
City
The city.
State
The state: this can be completely spelled out or an abbreviation such as CA.
Zip
zip or postal code. For locations in the USA, use the 5 digit zip code.
Phone (optional)
A contact phone number.
Country
The country.
-
For each marker, add the data to the following rows. Important: Do not include a comma (“,”) in any of the data.
-
Click File > Save As.
-
Select CSV (Comma Delimited) (*.CSV) in the data type field.
-
Click Save.
Comments
0 comments
Please sign in to leave a comment.