Click2Map CSV Format

Online Help - March 6, 2015

Click2Map is able to import data from external files, provided they are in a compatible format. The main import format is the CSV format: CSV is the acronym for Comma Separated Values which is a standard text file format used to exchange data between different applications. CSV files are easy to edit in standard spreadsheet applications such as MS Excel, OpenOffice or Google Spreadsheet.

CSV files are text files that can be opened in almost any text editor such as Notepad, SimpleText... They however differ from standard text files in that they are used to store organized data and have a specific structure:

  • The first line provides the general structure of the file.
  • A specific character is used to separate different elements. This character can be a comma, a semicolon or tabulation. The standard American delimiter is the comma, for example.

Structure of a Click2Map CSV

The first line of a Click2Map CSV file contains the following elements:

Name,Title,Latitude,Longitude,Description,Address,Street,City,State,Zip,Country, Icon_uri,IconSizeW,IconSizeH,Url_text,Url,Email_text,Email,Group

This first line is not as abstract as it may seem: it is a list of all the information that can be associated with each marker on a map. The order in which elements are organized is not important; you should just make sure that the same order used in the first line is also used for all markers. The first line describing the structure of you data (Name, Title, etc.) is not necessary if you use the structure described above: Click2Map will automatically associate matching columns. If this is not the case, you'll have the possibility to manually make associations during the import process.

Note: All elements are not mandatory - some can be ignored, in which case Click2Map will consider them to be empty or fill them with default values.

  • Name: The name of each marker should be unique. It is the primary information used to identify a specific marker. You can use this field to store a name in clear or a unique identification number.
  • Title: The title field can be used to provide information about a marker. Titles do not have to be unique and can be used to create categories, for example.
  • Description: This field can be used to associate a longer description with a marker. This field can contain HTML content.
  • Address: This field is designed to contain full street addresses: if your addresses are made of separate street, zip code and city fields, use the appropriate fields described below. Any street address entered in this field is automatically geocoded during the import process. This means that you do not need to know the geographical coordinates of a place to locate it on a map: Click2Map does the conversion for you. This is a great feature for real estate agents!
  • Street: This field can contain the number, type and name of a location in street address form, for example: "1428 Elm Street". It needs to be associated with the other address fields (City, State, Zip, Country) if you want Click2Map to be able to geocode its content. If your addresses are not split into different columns, your can put them in full in the Address field; in this case, leave the present field empty.
  • City: This field contains the name of the city in which the Street is located. It needs to be associated with the other address fields (City, State, Zip, Country) if you want Click2Map to be able to geocode its content. If your addresses are not split into different columns, your can put them in full in the Address field; in this case, leave the present field empty.
  • State: This field contains the name of the state in which the Street is located. It needs to be associated with the other address fields (City, State, Zip, Country) if you want Click2Map to be able to geocode its content. If your addresses are not split into different columns, your can put them in full in the Address field; in this case, leave the present field empty.
  • ZIP: This field contains the ZIP code corresponding to the specified Street. It needs to be associated with the other address fields (City, State, Zip, Country) if you want Click2Map to be able to geocode its content. If your addresses are not split into different columns, your can put them in full in the Address field; in this case, leave the present field empty.
  • Country: This field contains the name of the country in which the Street is located. It needs to be associated with the other address fields (City, State, Zip, Country) if you want Click2Map to be able to geocode its content. If your addresses are not split into different columns, your can put them in full in the Address field; in this case, leave the present field empty.
  • Latitude: If you know the geographical coordinates of a place, use this field to enter its latitude.
  • Longitude: If you know the geographical coordinates of a place, use this field to enter its longitude.
  • Url_text: If you wish to provide your visitors with a direct link to your website, use this field to store the visible hyperlink text. For example: 'Click2Map Website'. If this field is left empty, any link stored in the following Url field will appear in its original form.
  • Url: Use this field to store the desired Internet web address. For example: http://www.click2map.com
  • Email_text: If you wish to provide your visitors with a contact e-mail link, use this field to store the visible e-mail text. For example: 'Contact us'. If this field is left empty, any e-mail link stored in the following Email field will appear in its original form.
  • Email: Use this field to store the desired e-mail address. For example: info@click2map.com
  • Group: This field contains a marker's group/subgroup information. If this field is left empty, the corresponding marker will be placed at the root of the target map. If you wish to place a marker in a specific group, simply enter the corresponding group name in the 'Groupname' form. Groups can also contain subgroups: to place a marker in a specific subgroup, simply enter the corresponding subgroup name in the 'Groupname/Subgroupname' form.
  • Icon_uri: The complete Internet address of the icon associated with a marker. If this field is left blank, the target map's default icon will be used. See also: list of the Click2Map icons.
  • IconSizeW: Width of a marker's icon in pixels. Do not fill in this field unless you wish to deform the original image. When this field is left empty, Click2Map automatically resizes the image to the correct size, preserving its width/height ratio.
  • IconSizeH: Height of a marker's icon in pixels. Do not fill in this field unless you wish to deform the original image. When this field is left empty, Click2Map automatically resizes the image to the correct size, preserving its width/height ratio.

Why wait?

Start mapping now!