Skip to content
POWR Help Center home
InboxAsk a human

How to Import Locations to Map

You can add multiple locations to a POWR Map all at once by uploading a CSV file. Here's how...

Navigate on over to your map app with your properly formatted CSV file. Then click the upload link! The screenshot should provide some guidance on where to find this feature.

Select the CSV File

After clicking the "Upload" link, you should be presented with a file selection menu. Select the file you wish to upload.

Let POWR do the rest

Now all you have to do is wait until your Map App populates itself with all of the (properly formatted) addresses, names, and descriptions in your (properly formatted) CSV file.

Scroll down for the required format structure. 

The Format You Need For POWR!

  • Proper Heading

    Address,Name,Description Heading

    Address1,Name1,Description1

    Address2,Name2,Description2

    Address3,Name3,Description3`

    Your CSV file needs to have a header that contains at minimum an address section. The example above contains address, name, and description sections. The name and descriptions are highly recommended!

    Order and Casing

    address,description,Name

    Address1,Description1,Name1 Fields

    Address2,Description2,Name2 Fields

    Address3,Description3,Name3 Fields

    Upper and lower case letters in the header do not matter nor does the order in which the header fields appears as long as their respective fields are in that same order. The example above contains address, description, and Name sections - in a different order from the previous example.

    Additional Fields

    address,description,Name,Address Duplicate

    Address1,Description1,Name1,FinalAddressValue

    Address2,Description2,Name2,FinalAddressValue

    Address3,Description3,Name3,FinalAddressValue

    Any additional fields outside of the mentioned Address, Description, and Name fields will be ignored. They will not cause errors or change the outcome of the upload. Duplicate header values will result in the last mentioned header taking precendence over the previous

A Brief Introduction to the CSV format...

  • 1. The First Line

    The first line is typically a series of field delimiters. A good example (especially if you're using the map app) is to have the first line contain the words Address,Name,Description. Uppercase/Lowercase letters do not matter, nor does the order of the delimiters so long as as they match with their respective fields beneath them.

    Address,Name,Description

    is the same as...

    name,address,description

  • 2. Separate Entries

    Each record is one line - This means that every entry should have its own line ending with a return/new line character.

    Address,Name,Description

    Address1,Name1,Description1 One line

    Address2,Name2,Description2 One line

    Address3,Name3,Description3 One line (Notice how there's multiple lines?)

  • 3. Separate Fields

    Fields are separated with commas. You can enclose fields with double quotes! This allows you to have have fields containing commas.

    "I'm a little tea pot","Short, and, stout".

    Field 1: "I'm a little tea pot"

    Field 2:"Short, and, stout".

  • 4. White Space

    Leading and trailing white-space is ignored - Unless the field is delimited with double-quotes in that case the white-space is preserved. This means that a field containing

    "[space 1][space 2][space3]Tip me over"

    will contain 3 white space characters in the beginning (Trust me, there's 3 spaces in the beginning of that field) while that same field without the quotes would have the 3 white spaces ignored.

    [space 1][space 2][space3]Tip me over, I'm a tea pot

  • 5. Double-Quotes in values

    Embedded double-quote characters must be doubled, and the field must be delimited with double-quotes. This is a little weird, but here's an example!

    If you wanted a field to have the following text:

    He said: "and poor me out"

    you would need to have the quotes surrounding "and poor me out"

    each be preceded by an additional double quote giving you the final field of:

    "He said: ""and poor me out."""

Attached below is a template that you can use for creating your own CSV file.