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)
Publicado por TargetMapTeam en 4:39 PM
Etiquetas: ,

29 comments:

  1. JohnMarch 23, 2011 at 3:46 PM

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

    ReplyDelete
  2. TargetMapTeamMarch 23, 2011 at 4:07 PM

    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. FleetwoodMarch 26, 2011 at 5:33 PM

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

    ReplyDelete
  4. AnonymousMarch 28, 2011 at 6:34 PM

    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. Laura H.W.April 17, 2011 at 5:46 PM

    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. AnonymousAugust 25, 2011 at 4:14 PM

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

    ReplyDelete
  7. JaviAugust 25, 2011 at 6:13 PM

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

    ReplyDelete
  8. Christian CortaceroNovember 25, 2011 at 3:44 PM

    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. The TargetMap Crew - JavierNovember 26, 2011 at 10:27 AM

    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. AnonymousMarch 29, 2012 at 8:57 PM

    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. AnonymousMarch 30, 2012 at 8:32 AM

    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. info@porttackoption.comApril 5, 2012 at 11:02 AM

    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. AnonymousApril 5, 2012 at 12:21 PM

    Hi,

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

    Thanks for your interest.

    ReplyDelete
  14. Laurie BMay 31, 2012 at 6:19 PM

    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. Aloha CafeJanuary 8, 2013 at 11:50 AM

    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. AnonymousJanuary 8, 2013 at 11:52 AM

    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. AnonymousNovember 17, 2013 at 3:50 PM

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

    Thanks

    ReplyDelete
    Replies
    1. AnonymousNovember 18, 2013 at 9:39 AM

      Nope.

      Thanks for your interest in TargetMap

      Delete
  18. AnonymousMarch 18, 2014 at 9:09 AM

    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!

    ReplyDelete
  19. UnknownJanuary 25, 2015 at 3:33 AM

    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. UnknownFebruary 16, 2015 at 2:07 AM

    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. AnonymousFebruary 16, 2015 at 9:09 AM

      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. LauraDecember 31, 2015 at 11:57 PM

    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. TargetMap Team - JavierJanuary 4, 2016 at 9:13 AM

      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. Ms. LaCountJuly 29, 2016 at 9:00 AM

    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
  23. Ms. LaCountJuly 29, 2016 at 9:01 AM

    PS I will send you the file...

    ReplyDelete
  24. karinMay 10, 2017 at 5:24 PM

    hi i am trying to get targetmap to show the boundaries for my Vienna data by zipcode, but this only seems to work for the pinpoints. how can i get the boundaries to follow the zipcodes, too. (or rather, i dont really need the pinpoints.) thanks karin

    ReplyDelete
    Replies
    1. AnonymousMay 10, 2017 at 5:37 PM

      Hi, zip codes are only available in pin points. We don't have the postal areas as boundaries.
      Our apologies for the inconveniences.
      Best regards.

      Delete
  25. UnknownJuly 28, 2019 at 7:36 PM

    excel workbock <--- هل الحفظ بنوع هذا
    صحيح.؟

    ReplyDelete

Subscribe to: Post Comments (Atom)