GPS coordinates to Location

[@janinelivingston2438]

Amazing!!! SO helpful, thank you!

[@FredericLEGUEN-Excel]

Thanks you

[@august8907]

Hi, at 4:11, you introduce a way to extract only the first item from the list, but what should I do if I only want to extract the 9th item (county)?

[@FredericLEGUEN-Excel]

I give the answer in the next video of the series. You can customize the XPATH of the function

[@MatsveiYakubovich]

Thanks for the tutorial, sir. It would be nice to know if we can also select not the first address row using "@" and then the filter command, but for example the 3rd or 4th to show, if it's possible.

[@FredericLEGUEN-Excel]

The answer is in this video kzbin.info/www/bejne/nHbbf4V-gr2NaJo

[@waleadeniji6959]

on point!.... thanx man

[@radenmasabadi7704]

where did you get the API's Key exactly ?

[@FredericLEGUEN-Excel]

Follow the playlist here to see how to create your API key and a Google developer account kzbin.info/aero/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA

[@aldissmans3859]

As far as I understand, I need to create a "Google API" account and then I can repeat all this...do I understand correctly?

[@FredericLEGUEN-Excel]

Absolutely

[@aldissmans3859]

@@FredericLEGUEN-Excel , Thanks for the reply. If the coordinates are given and there is no physical address nearby, but then "google api" gives the nearest address?

[@FredericLEGUEN-Excel]

@@aldissmans3859 Hard to repy. If you put the coordinate of the North Pole, does Google will return the address 'North Pole' probably not. But Google API will return an address close to your position. Now will it be the address you expect .... impossible to reply to that

[@basbees]

Do you have an example for the Canadian addresses?

[@FredericLEGUEN-Excel]

No (sorry) but it should work in the same way

[@dan.6398]

I have created my API key and still gets "error_message" : "This API project is not authorized to use this API.",Should we pay to create account ?

[@FredericLEGUEN-Excel]

You haven't create a key certainly

[@bryonbrill]

Make sure that there are no restrictions by IP, or website in the security for your API Key. 😊

[@unovideo2145]

Bonjour est til possible de cliquer sur une carte et d'avoir un ajout automatique des coordonnees GPS dans un tableau excel? Merci

[@FredericLEGUEN-Excel]

Non. Ce n'est pas possible depuis Excel

[@Geospatial.]

Does it work for Bangladesh?

[@FredericLEGUEN-Excel]

Yes

[@habboukrimo914]

Can i have an example to download

[@FredericLEGUEN-Excel]

Not for free. I can give you the link tomorrow

[@tobiaswhite5660]

For me, when I enter the function FILTERXML and enter formatted address, it doesn't seem to work and I get the formula error to say that something is incorrect. Anybody else having this issue?

[@FredericLEGUEN-Excel]

Have you created your Google API key? It's compulsory to use the link. Follow the sequence of the playlist kzbin.info/aero/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA

[@JosecelmoDepiante]

Perfeito!

[@Benmaluco9]

Obrigado

[@vinitkamble4068]

Respected Sir, my name is Vinit & I want to drag down addresses in Excel from longitude and latitude. Can you share your number for further discussion? Is there any free service provide from Google? related to above process

[@BokiX_TDT]

it cost 300$ bruh

[@RpgTech281]

This is a paid service only

[@FredericLEGUEN-Excel]

@@RpgTech281 Not for the first 1000 query I think

[@avinashpaudel3003]

when i tried with my api code its shows error. It say Status Request Denied. Request to this API must be over SSl. How to solve this?

[@FredericLEGUEN-Excel]

Sorry but I have no idea. You must read the developer documentation