Auto-populate Latitude & Longitude

%3CLINGO-SUB%20id%3D%22lingo-sub-1942911%22%20slang%3D%22en-US%22%3EAuto-populate%20Latitude%20%26amp%3B%20Longitude%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1942911%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20spreadsheet%20with%20addresses.%20I'm%20trying%20add%202x%20columns%20with%20Latitude%20%26amp%3B%20Longitude%20without%20having%20to%20manually%20type%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20classify%20my%20addresses%20as%20a%20Geography%20data%20type%2C%20Bing%20doesn't%20recognize%20the%20addresses%20in%20the%20data%20selector.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BIt%20says%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22%20%3CSTRONG%3ENo%20results%20found%20for%20%22%5Baddress%5D%3C%2FSTRONG%3E%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20put%20the%20exact%20same%20address%20on%20bing%20maps%20%3CU%3EI%20can%20find%20the%20addres%3C%2FU%3Es%20without%20any%20issues.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20now%20being%20forced%20to%20manually%20search%20and%20type%20for%20the%20addresses%20on%20maps%20on%20to%20every%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20solve%20this%20issue%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1942911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1943683%22%20slang%3D%22de-DE%22%3ESubject%3A%20Auto-populate%20Latitude%20%26amp%3B%20Longitude%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943683%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F886383%22%20target%3D%22_blank%22%3E%40BernMoreira%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20certainly%20not%20the%20most%20suitable%20to%20give%20you%20a%20solution%20to%20this%20problem%2C%20but%20with%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20an%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Add%20a%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an excel spreadsheet with addresses. I'm trying add 2x columns with Latitude & Longitude without having to manually type it. 

 

When I try to classify my addresses as a Geography data type, Bing doesn't recognize the addresses in the data selector. 

 It says:

 

" No results found for "[address]

 

If I put the exact same address on bing maps I can find the address without any issues. 

I'm now being forced to manually search and type for the addresses on maps on to every cell. 

 

Can anyone help me solve this issue? 

1 Reply

@BernMoreira 

I am certainly not the most suitable to give you a solution to this problem, but with your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Add a MS Excel file (without sensitive data) to your project. Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)