What is required in my CSV file?

When you build your CSV file for import to Mapply, you need to include the required info. This info includes Name, Address, Address 2, City, Province/State, Country, Postal/Zip Code. If you don't include this information, the upload won't work.

Here is a detailed explanation of each column:

  • Address: should be the physical location (i.e., 123 Easy Street) and have no other info.

    Examples of other info:

    • PO Box addresses will not work, they are mailing addresses not physical locations, you need a physical location to appear on a map.
    • Locations that are in malls/shopping centers should just be the Mall address.
    • Addresses that look like "At the corner of _____ and _____" will not work.
    • Make sure you have the correct address. Just because the location has its address on the website, make sure to confirm it either by plugging it into Google maps or by contacting them.
    • No special characters. Having special characters in the address or any field can often cause issues in the geolocation of the stores. Special characters include: !@#$%^&*()_+=-<>{}[]. This issue can sometimes, unfortunately, affect other languages which use non-Latin characters. 
    • Online only stores should be excluded from your CSV file since they don't have physical locations and can't appear on a map. To address this, most people include these places in the footer below the map. Any text added to this area will be visible below the map.
  • Address 2: This is used for including things like unit number, buzzer codes, other useful information that would not be considered address info but is still pertinent to accessing/finding the location.
  • City, Province/State, Country: Pretty self-explanatory, but must be there. Best practice when entering these is to use the full spelling of each; it makes things easier.
    • If the location you are entering is part of a country that doesn't have or use provinces/states then leave this spot blank.
  • Postal/Zip Codes: Make sure you have the correct one for each address. There is also formatting you can set (in most software) for this column, so it retains the Postal Code or Zip Code format correctly. Do not include any other text in this section.
  • All other info is not required as it will not affect the geolocation of the store, you can fill these fields in, just ensure the information is correct and be advised this will be visible to your customers.

 Here is an example of what this will look like:

Name Address Address 2 City Province/State Country Postal/Zip Code
Bold HQ 50 Fultz Blvd   Winnipeg Manitoba Canada R3Y 0L6
Guy's House of Hair  123 Fake St Unit 10 Beverly Hills California USA 90210

Once the fields are populated, save the file in CSV format. Once saved, you can start the upload from the app. There is a limit of 1,000 stores geolocated per day. If you have 3,000 stores in your file, it will take about three days or so to geolocate all the stores. If for some reason there are problems you will be emailed a list of the stores that failed. 

Failed Geolocations: if this happens, you will receive an emailed list of locations that failed to geolocate. You will need to verify the address info of these locations. If for some reason the address is correct, but the location is in the wrong place or near Africa, visit Stores are Displaying near Africa or Otherwise Incorrectly

Was this article helpful?
0 out of 0 found this helpful