Streamlined Creating Interactive Map: From Excel & Python into Embedded HTML Report
Build a streamlined interactive map from Excel or Google Sheets data in Python using folium.
Take a simple Excel or Google Sheets file of locations and routes, and turn it into:
• an interactive map with points and route lines
• a one-page HTML report that embeds the map and a summary table
all using Python, pandas, and the folium library
This workflow takes spreadsheet data and produces:
1) an interactive HTML map (points + optional routes)
2) a simple HTML report page that embeds the map + summary tables
Input files:
locations.csv (exported from Excel/Sheets): name, category, latitude, longitude, description
routes.csv (optional): route_name, route_type, seq, latitude, longitude
Output files:
locations_map.html
locations_report.html
Code & sample files: https://github.com/winswithdata/build...
Chapters:
00:00 Demo (map + report)
00:49 Jump to the code
02:39 Build the map (points + route lines)
06:39 Embedded into the Final Report
#python #folium #pandas #excel #mapping #dataviz