Wednesday, September 22, 2010

Common issues with Excel files

There are some usual questions that arise when talking about excel files formats and its content before uploading them in TargetMap.
If you follow these guidelines, there is a big chance of getting your excel file shown on Googlemaps without any problem.
  • Data must be in the 1st sheet of your excel file
  • All excels must contain a column with territory names or zip/postal codes. Excels with zip/postal codes create more accurate ReportMaps. From zip/postal codes you can create county, region, province... maps
  • 1rst row of your spreadsheet is used for column titles. Use the 1rst row (A) of your excel file to describe columns.
  • It is better if your zip/postal code column is in text format. If your zip/postal codes column is in number format all codes beggining with a 0 (zero) wil not be detected.
  • Be sure your columns with quantities are in numeric format (or currency). Otherwise TargetMap will not be able to operate with those columns.
If your excel can not be uploaded, it usually is because the excel file contains corrupted cell formats. An easy solution is to copy the spreadsheet cells and paste into a new one (special paste - values)

27 comments:

  1. How do you make zip codes into territories instead of points or how do you create custom territories?

    ReplyDelete
  2. Hi John, data from zipcodes is also shown in boundaries. If you do not want to see the pinpoints just disable the pinpoint layer. (the eye in the icon) To create custom territories you can use the "paint a map option" or the Territory Manager in the private version Feel free to ask anything you need at crew@targetmap.com

    ReplyDelete
  3. You dont seem to except Excel 2007 file formats (.xlsx or .xlsb). That would be helpful info to add here.

    ReplyDelete
  4. Hi Fletwood,
    Excel 2007 files are supported, maybe is an issue with a concrete Excel file.
    Could you send us to crew-AT-targetmap.com this file, to check what is happening?

    Thanks.

    ReplyDelete
  5. Can exact addresses be mapped or just zip codes and counties? I am part of a social club and we would like to map out our favorite restaurants/places we've visited as a group.

    ReplyDelete
  6. Can you upload excel data without zip codes? i only have the State

    ReplyDelete
  7. Yes, you can! You can use State or even County or Division if you want!
    Thanks for using TargetMap

    ReplyDelete
  8. Hi,

    I cannot upload a file, Territories is in the first column, tittles in the first row, is a plain excel with no formats, but I cannot upload it. Could I send the file to you to help me?
    Thanks

    ReplyDelete
  9. Hi Christian,

    We've already sent you an e-mail. It seems to be your excel filetype. We've saved it in an older filetype and it works fine and we've sent it to you. We will look at this problem carefully on Monday to improve our compatibility.

    Thanks for using TargetMap

    ReplyDelete
  10. HI, I DID EVERYHTING ACCORDING TO THE INSTRUCTIONS BUT I STILL CANNOT UPLOAD. I HAVE WINDOWS 2010, IS THIS THE PROBLEM?
    THANK YOU!

    ReplyDelete
  11. Hi,

    For now, our application is not compatible with Excel 2010, maybe it is the problem. Save it as an Excel 2007 and you will be able to upload it.

    ReplyDelete
  12. I have an excel file set up as you specify. The first column as postal codes (canada) but only the first 3 leters/number... not the whole thing as I'm try to map regions not addresses.

    Will that work? I can't get the excel file to load.

    ReplyDelete
  13. Hi,

    No. Codes only work with Zip Codes. You will have to map your regions using the nomenclator.

    Thanks for your interest.

    ReplyDelete
  14. I purchased access to TargetMap, followed all of the directions and am having an issue with my map of Brazil. 3 states keep appearing in grey with no data even though I have Excel data populated for the states. What can I do to fix this?

    ReplyDelete
  15. Hi,

    I do have the same problem as Laurie B mentioned but I am doing to make a Thailand's map. The map has shown in grey for many provinces in the southern region.

    ReplyDelete
  16. Hi,

    Can you send us an e-mail to crew(at)targetmap.com with an accurate explanation of your problem and the Excel file as an example? Do you have a Not to share account?

    Best regards

    ReplyDelete
  17. Hi, I was just wondering if it is possible to create maps with GPS points instead of zip codes or countries?

    Thanks

    ReplyDelete
  18. Hi I am having a problem similar to laurie B and aloha cafe above. I am building a world map with data for each country. However some countries appear in grey. the map says no data for those countries even though the data is right there in the excel and can be seen in the table below the map.

    ReplyDelete
    Replies
    1. Hi!
      If you are using a Not to share account you will be able to see the 80% of your records in the map. You must be receiving a message in the application that explains you that.
      Thanks for using TargetMap!

      Delete
  19. Let's say neither column contains a numeric value.
    For example: Assume I want to create a world map that will display the name of the presidents of each country around the world. The first column (A) will have the country [United States], and the second column (B) will have the president's name [Barack Obama].
    How do I display the name of the country AND the president's name onto the LEGEND when moving the cursor over the country? Right now it shows the name of the country and Value 1"?
    Thank you!
    Melvin.

    ReplyDelete
  20. I have tried uploading multiple spreadsheets, I keep gettin errors. I have reformatted the fields as text and left them as is. Eventually I need to color code my categories, physicians, case managers, guardians, etc.

    Nothing will load. I have Excel 2010 and have a premium target map account.

    ReplyDelete
    Replies
    1. Hi,

      Please send us an e-mail to crew(at)targetmap.com with the Excel file you are trying to upload and we will help you with that.

      Delete
  21. Hi. I've tried to upload about 20 different spreadsheets and none of them are working!!! I've uploaded files using microsoft office 2010 and office 2007, while following the exact instructions you provide on the website.

    Please help!!

    ReplyDelete
    Replies
    1. We have tested your excel files you sent us by e-mail and they worked for us. We'll keep in touch by e-mail.

      Delete
  22. HI,
    My excel file is not working. I tried copying and pasting. It has a postal column. It is for worldwide, however - could that be a problem? Or is it a problem that some rows within the sheet are blank? Thanks for your help.
    n

    ReplyDelete