filmov
tv
Excel 3D Map With KML Custom Regions - Episode 2556
Показать описание
Microsoft Excel Tutorial: Mapping Census Tracts in Excel.
Welcome to episode 2556 of MrExcel's YouTube channel! In this video, we will be exploring how to create a 3D map in Excel using custom KML shapes. This question was inspired by a viewer, PWRO, who asked if it was possible to use different jurisdictional boundaries other than postal codes for mapping data. Well, the answer is yes, and we will show you how to do it in this video.
The video will be divided into four parts. The first part will cover how to create the 3D map using the custom KML file. The second part will show you where to get the population data and the KML file. The third part will demonstrate how to import the data into Excel and clean it using Power Query. And finally, the fourth part will bring it all together to create the 3D map with custom regions. Don't worry, if you already have a KML file and data, you can skip to the first part and be on your way to creating a 3D map.
So, what exactly is a KML file? It is essentially an XML file with a .KML extension. It contains the boundaries for each census tract, along with other information such as latitude and longitude coordinates. However, in order to use it in our 3D map, we need to match the fields in the KML file with the fields in our data. This is where the AFFGO ID comes in. It is the key field that we will use to map the data in our 3D map.
To add the KML file to our 3D map, we will need to go to the Insert tab and select 3D Map. Then, we will need to tell Excel about our KML file by going to the Custom Regions option and importing the KML file. Once it is imported, we can add the AFFGO ID field and map it by population. We can also choose to color the map by county, which will give us different colors for each county. And just like that, we have successfully created a 3D map with custom regions using a KML file.
But wait, there's more! In the video, we will also cover where to get the population data and the KML file, as well as how to import and clean the data using Power Query. This will be helpful for those who want to create a 3D map with their own data and KML file. So, make sure to watch the entire video to learn all the steps involved in creating a 3D map with custom KML regions in Excel.
Thank you for watching this video and for stopping by MrExcel's YouTube channel. Don't forget to download the accompanying workbook in the video description for a step-by-step guide and to follow along. And if you have any questions or suggestions for future videos, please leave them in the comments below. See you next time for another net cast from MrExcel!
Excel supports mapping by county, zip code, state, country. But they don't natively support census tracts. In today's video, you will see how to download population data and a map KML file from Census.Gov.
Table of Contents
(0:00) Excel Mapping Other Jurisdictions
(0:51) Four Video Sections
(1:19) Examining KML File in Notepad++
(2:14) Opening 3D Map
(2:54) Importing KML to 3D Map
(3:30) Adding KML Field to Map
(5:06) Getting Population by Census Tract
(6:48) Where to get KML File
(7:18) Importing Population
(8:08) Importing Census Tracts
(9:01) Merging Population with KML Data
(9:58) Wrap-up
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
downloading a kml file by census tract
importing and merging census data in excel
how to open a kml file in excel
how do i convert a kml file to excel
how do i open a kml file in excel
how do i convert a kml file to excel
how to import kml to excel
how to open a kml file in excel
how to open kml in excel
Welcome to episode 2556 of MrExcel's YouTube channel! In this video, we will be exploring how to create a 3D map in Excel using custom KML shapes. This question was inspired by a viewer, PWRO, who asked if it was possible to use different jurisdictional boundaries other than postal codes for mapping data. Well, the answer is yes, and we will show you how to do it in this video.
The video will be divided into four parts. The first part will cover how to create the 3D map using the custom KML file. The second part will show you where to get the population data and the KML file. The third part will demonstrate how to import the data into Excel and clean it using Power Query. And finally, the fourth part will bring it all together to create the 3D map with custom regions. Don't worry, if you already have a KML file and data, you can skip to the first part and be on your way to creating a 3D map.
So, what exactly is a KML file? It is essentially an XML file with a .KML extension. It contains the boundaries for each census tract, along with other information such as latitude and longitude coordinates. However, in order to use it in our 3D map, we need to match the fields in the KML file with the fields in our data. This is where the AFFGO ID comes in. It is the key field that we will use to map the data in our 3D map.
To add the KML file to our 3D map, we will need to go to the Insert tab and select 3D Map. Then, we will need to tell Excel about our KML file by going to the Custom Regions option and importing the KML file. Once it is imported, we can add the AFFGO ID field and map it by population. We can also choose to color the map by county, which will give us different colors for each county. And just like that, we have successfully created a 3D map with custom regions using a KML file.
But wait, there's more! In the video, we will also cover where to get the population data and the KML file, as well as how to import and clean the data using Power Query. This will be helpful for those who want to create a 3D map with their own data and KML file. So, make sure to watch the entire video to learn all the steps involved in creating a 3D map with custom KML regions in Excel.
Thank you for watching this video and for stopping by MrExcel's YouTube channel. Don't forget to download the accompanying workbook in the video description for a step-by-step guide and to follow along. And if you have any questions or suggestions for future videos, please leave them in the comments below. See you next time for another net cast from MrExcel!
Excel supports mapping by county, zip code, state, country. But they don't natively support census tracts. In today's video, you will see how to download population data and a map KML file from Census.Gov.
Table of Contents
(0:00) Excel Mapping Other Jurisdictions
(0:51) Four Video Sections
(1:19) Examining KML File in Notepad++
(2:14) Opening 3D Map
(2:54) Importing KML to 3D Map
(3:30) Adding KML Field to Map
(5:06) Getting Population by Census Tract
(6:48) Where to get KML File
(7:18) Importing Population
(8:08) Importing Census Tracts
(9:01) Merging Population with KML Data
(9:58) Wrap-up
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
downloading a kml file by census tract
importing and merging census data in excel
how to open a kml file in excel
how do i convert a kml file to excel
how do i open a kml file in excel
how do i convert a kml file to excel
how to import kml to excel
how to open a kml file in excel
how to open kml in excel
0:04:53
Excel - Creating Custom KML Regions For Excel 3D Map - Episode 2557
0:10:12
Excel 3D Map With KML Custom Regions - Episode 2556
0:43:59
Microsoft Excel 3D Maps - A Complete Guide
0:08:46
Convert Excel Data into a Google Map
0:03:19
How To Create A Property Boundary KML/KMZ Using Google Maps
0:04:05
Importing Excel coordinates into Google Earth Pro
0:08:21
Import Latitude & Longitude Coordinates to Google Earth from CSV Excel file
0:02:44
Learn Google Earth: Importing KML, KMZ and GPS Data
0:03:41
Import your KML map data into Google Earth Web
0:04:26
Excel to kml convert in-Google Earth Pro
0:00:16
Using ForeFlight exporting kml file to Google Maps for flight reviews. Simple and Awesome!
0:06:20
Extract coordinates from Google Earth Pro to Excel
0:06:46
How to plot GPS Coordinates from excel to Google earth
0:01:55
How to add Google earth in Autocad Civil 3D 2020 || Hot! Hot!
0:04:26
TA Trimble Access How to convert KML to DXF
0:00:32
creat contour in 30 second#google Earth#kml #road #survey #how #alignment #cad #horizontal#distance
0:13:25
Extracting Elevation Data from Google Earth
0:16:14
||ED&RP|| 03 Google Earth Pro - Creating KML files from MS EXCEL (2/2)
0:01:20
Create 3D KML from Land Survey Drawing
0:00:47
Como geolocalizar en autocad / Como insertar un mapa de google earth
0:00:58
Google Earth VS SpaceEngine Earth
0:03:30
Export Data to KML tool tutorial | XTools Pro, extension for ArcGIS Desktop
0:04:37
Civil 3D Bing Maps & Google Earth Integration
0:08:32
Visualizing Contour (Topographic) Maps In Google Earth
Комментарии