I need bing data application to import excel data.

Asked By Dorothy Gallardo 30 points N/A Posted on - 04/04/2013

Hi! I have a lot of information in an excel sheet that I have gathered from different sources. I would like to create bing maps using the data so that I can easily share it online. I need bing data excel application or procedure that I can use to import excel data into bing. Any help with this will be highly appreciated.

• Status: Open
• Question Views: 699
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: dBase

Answered By Sandra R Butters 30 points N/A #139751

I need bing data application to import excel data.

Hello Dorothy,

To get the Excel sheets into Bing, you need to make sure few things. You must have three columns “Latitude” and “Longitude” and the third one is “EntityID”. EntityID” column is a unique identifier for each record which you have to create. An easy solution to create this column is to give the first record an id of 1 and then the second record of 2 and so on. From here you can save your file by using the Save as option. If you are geocoding the data source then you can leave the Latitude and Longitude columns empty. For geocode you will need few columns which contain address information. Now go to the Bind Maps Data Uploader. After that you can use these tools to upload the data into Bing. Then to query your data source you can use query API of this service.

Good luck

About Sandra R Butters

Questions
12

Answers
102

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 04/21/2013
• Question Category: dBase