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 czcams.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
@@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
on point!.... thanx man
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
Amazing!!! SO helpful, thank you!
Thanks you
Perfeito!
Do you have an example for the Canadian addresses?
No (sorry) but it should work in the same way
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.
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
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 czcams.com/play/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA.html
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 czcams.com/play/PLvGH1Mqd1ClY4q4jLffhGp7osPWpcamJA.html
Obrigado
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
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
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. 😊
Does it work for Bangladesh?
Yes
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
it cost 300$ bruh
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