Mapping Census Tracts in Excel.
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.

Learn how to import the KML file into the 3D Map feature in Excel and make a map from it.

This video also covers:
Downloading a CSV with population by census tract from Data.Census.Gov.
Downloading a KML file by Census Tract
Importing and merging that data in Excel.

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

More questions answered in at the 8-9 minute mark:
how do i open a kml file 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 open a kml file in excel
how do i convert a kml file to excel
how to import kml to excel
how to make a kml file from excel
excel in kml
how to open a kml file in excel
how do i open a kml file in excel
how to open kml in excel