Generating links to maps using Copilot in Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel.
I have a table that I downloaded showing meteorite landings, including latitude and longitude.
I would like to make it easy to see where the locations are on a map so I ask Copilot:
Create a column with a hyperlink to bing maps with the latitude and longitude
Looking at B2:L500, here’s 1 formula column to review and insert in Column M:
Creates a clickable link to Bing Maps for each meteorite landing site by combining the latitude and longitude coordinates.
=HYPERLINK(“https://www.bing.com/maps?q=“&[@latitude]&”,”&[@longitude],”Bing Maps”)
I click on the button to insert the formula column and my table is updated to include a column with hyperlinks for each of the locations.
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel.
I have a table that I downloaded showing meteorite landings, including latitude and longitude.
Table of Meteorite Landings including columns, Name, Meteorite ID, Recclass, Mass, Fall, Year, Latitude, Longitude.
I would like to make it easy to see where the locations are on a map so I ask Copilot:
Create a column with a hyperlink to bing maps with the latitude and longitude
Copilot in Excel Pane with the above prompt
Looking at B2:L500, here’s 1 formula column to review and insert in Column M:
Creates a clickable link to Bing Maps for each meteorite landing site by combining the latitude and longitude coordinates.
=HYPERLINK(“https://www.bing.com/maps?q=”&[@latitude]&”,”&[@longitude],”Bing Maps”)
I click on the button to insert the formula column and my table is updated to include a column with hyperlinks for each of the locations.
Table of Meteorite Landings including columns, Name, Meteorite ID, Recclass, Mass, Fall, Year, Latitude, Longitude, and new inserted formula column with Bing Maps links.
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks. Read More