@@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?
@@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
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.
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?
Have you created your Google API key? It's compulsory to use the link. Follow the sequence of the playlist ua-cam.com/play/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA.html
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
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)?
I give the answer in the next video of the series. You can customize the XPATH of the function
where did you get the API's Key exactly ?
Follow the playlist here to see how to create your API key and a Google developer account ua-cam.com/play/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA.html
As far as I understand, I need to create a "Google API" account and then I can repeat all this...do I understand correctly?
Absolutely
@@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?
@@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
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.
The answer is in this video ua-cam.com/video/fExNRHMXZ28/v-deo.html
Amazing!!! SO helpful, thank you!
Thanks you
Getting formula error for formatted text formula =FILTERXML(c2;"//formatted_address")
Have you checked that you have the tag "formatted_address" in the xml?
change the '';'' to a comma
Do you have an example for the Canadian addresses?
No (sorry) but it should work in the same way
Bonjour est til possible de cliquer sur une carte et d'avoir un ajout automatique des coordonnees GPS dans un tableau excel? Merci
Non. Ce n'est pas possible depuis Excel
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 ?
You haven't create a key certainly
Make sure that there are no restrictions by IP, or website in the security for your API Key. 😊
Can i have an example to download
Not for free.
I can give you the link tomorrow
on point!.... thanx man
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?
Have you created your Google API key? It's compulsory to use the link. Follow the sequence of the playlist ua-cam.com/play/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA.html
Does it work for Bangladesh?
Yes
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
Perfeito!
Obrigado
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?
Sorry but I have no idea. You must read the developer documentation
it cost 300$ bruh
This is a paid service only
@@RpgVlog281 Not for the first 1000 query I think