Тёмный

How to Create a Google Map with Excel Data 

ExcelDemy
Подписаться 12 тыс.
Просмотров 13 тыс.
50% 1

Опубликовано:

 

8 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@sbolt6
@sbolt6 Месяц назад
Excellent step by step instructions. Thank you!
@exceldemy2006
@exceldemy2006 Месяц назад
Hello @sbolt6, You are most welcome. Thanks for your appreciation, it means a lot to us. Keep learning Excel with ExcelDemy. Regards ExcelDemy
@sachinbandari8225
@sachinbandari8225 2 месяца назад
Thank you for info. It helped me a lot in my line of work. easy to trace many locations in map. very helpful
@exceldemy2006
@exceldemy2006 2 месяца назад
Hello @sachinbandari8225, We are glad to hear that our video helped you in your work. Thanks for your appreciation. Please stay connected with us. Regards ExcelDemy
@Sohailabbasi93
@Sohailabbasi93 2 месяца назад
Good info.
@exceldemy2006
@exceldemy2006 2 месяца назад
Thanks for your appreciation. Stay connected with us.
@Sohailabbasi93
@Sohailabbasi93 2 месяца назад
But if we want to change location of person, how will we do?
@exceldemy2006
@exceldemy2006 2 месяца назад
Hello @Sohailabbasi93, To change a person’s location on a Google Map created with Excel data: You can follow these 3 ways: You can upload the updated Excel file. 1. Edit the Excel File: Open the Excel file containing the data. Find the row with the person’s information and update their address or coordinates. Save the changes. Update Google My Maps: 2. Open Google My Maps and go to your map. Click on the "Add layer" button, then select "Import" to upload the updated Excel file. Follow the prompts to import and replace the old data. Manual Adjust the Map Open your map in Google My Maps >> Click the marker you want to move >> Drag it to the new location. Regards ExcelDemy
@apocalypsematrix9252
@apocalypsematrix9252 Год назад
👍🏻
@golnaz.shoush
@golnaz.shoush 5 месяцев назад
Hi dear thank u v much , I’m in fact looking for an area to be colored by google map using spread sheet, is there any way to that ? (In fact polygon instead of marker)
@exceldemy2006
@exceldemy2006 5 месяцев назад
Dear, thanks for your exciting comment. Google My Maps does not allow us to create a direct polygon by importing data from spreadsheets. However, you can try using a manual approach. As mentioned in the article for Excel worksheet, import your Spread Sheet data into Google My Maps. Later, create a new layer on the map. In this new layer, manually draw polygons to represent the areas you want to color. Select the "Draw a line" tool in Google My Maps to do this. Once you have drawn the polygons, customize their appearance, including the fill color.
Далее
Import Excel data to Google Maps
3:42
Просмотров 15 тыс.
🌍 How to make interactive Excel Map charts
12:53
Просмотров 297 тыс.
Convert Excel Data into a Google Map
8:46
Просмотров 173 тыс.
How to Create an Interactive Checklist in Excel
10:28
Using Power Maps in Excel
22:39
Просмотров 9 тыс.
How to Create Leave Tracker in Excel
25:10
Просмотров 40 тыс.