Geosheets Commute Map Demo
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Click here to copy this sheet and try it yourself
2
Geosheets is the simplest way to work with location data in Google Sheets
3
4
This demo spreadsheet shows sample home and office locations and lines between them, simulating a commute analysis.
5
6
Instantly create an interactive map with the GEO_MAP function, then merge multiple maps together using GEO_MAP_MERGE
7
=GEO_MAP_MERGE({A30, E30, A51}, "commutes")
8
https://www.geosheets.com/map/s:Lo6WyDJl/commutes
9
10
11
Home LocationHome AddressColorIconWork LocationWork AddressColorIcon
12
39.7684364108,-105.081138611
3700 Wadsworth Blvd, Wheat Ridge, Colorado 80033, United States
#803556
lodging
39.7450781635,-104.991016388
1615 Welton St, Denver, Colorado 80202, United States
#293038
suitcase
13
39.7977219958,-104.933166504
E 56th Ave, Commerce City, Colorado 80022, United States
#803556
lodging
39.7479818796,-104.979686737
100 Park Ave W, Denver, Colorado 80205, United States
#293038
suitcase
14
39.7061301493,-105.063972473
6075 W Center Ave, Denver, Colorado 80226, United States
#803556
lodging
39.7394023651,-104.977798462
1445 Clarkson St, Denver, Colorado 80203, United States
#293038
suitcase
15
39.6530198162,-104.958572388
2386 US-285 N, Englewood, Colorado 80113, United States
#803556
lodging
39.7378183379,-104.990844727
1345 Bannock St, Denver, Colorado 80204, United States
#293038
suitcase
16
39.6612136258,-105.025177002
3094 S Federal Blvd, Denver, Colorado 80236, United States
#803556
lodging
39.744418211,-104.984836578
1770 Sherman St, Denver, Colorado 80203, United States
#293038
suitcase
17
39.6765413702,-104.906730652
7073 E Warren Dr, Denver, Colorado 80224, United States
#803556
lodging
39.7541848631,-104.995994568
1900 Wazee St, Denver, Colorado 80202, United States
#293038
suitcase
18
39.7019039573,-104.875831604
775 S Alton Way, Denver, Colorado 80247, United States
#803556
lodging
39.7631584037,-104.978485107
3115 Lawrence St, Denver, Colorado 80205, United States
#293038
suitcase
19
39.7341221329,-104.873085022
1161 Elmira St, Aurora, Colorado 80010, United States
#803556
lodging
39.7477179105,-104.99874115
1436 Larimer St, Denver, Colorado 80202, United States
#293038
suitcase
20
39.7647418483,-104.886474609
3483 N Xanthia Ct, Denver, Colorado 80238, United States
#803556
lodging
39.7560324523,-104.980716705
2635 Stout St, Denver, Colorado 80205, United States
#293038
suitcase
21
39.7853233146,-105.017623901
4801 Alcott St, Denver, Colorado 80221, United States
#803556
lodging
39.7528651262,-104.984664917
2301 Stout St, Denver, Colorado 80205, United States
#293038
suitcase
22
39.6955641841,-104.951705933
1155 S Saint Paul St, Denver, Colorado 80210, United States
#803556
lodging
39.7465300369,-104.969387054
1724 E 20th Ave, Denver, Colorado 80218, United States
#293038
suitcase
23
39.7087713878,-104.997711182
I-25 N, Denver, Colorado 80223, United States
#803556
lodging
39.7573521286,-104.969730377
2815 Humboldt St, Denver, Colorado 80205, United States
#293038
suitcase
24
39.7436262596,-105.034103394
1638 Lowell Blvd, Denver, Colorado 80204, United States
#803556
lodging
39.7527331511,-104.989299774
2120 Arapahoe St, Denver, Colorado 80205, United States
#293038
suitcase
25
39.7687003006,-104.997711182
3788 Inca St, Denver, Colorado 80216, United States
#803556
lodging
39.7342541437,-104.976596832
1125 Emerson St, Denver, Colorado 80218, United States
#293038
suitcase
26
39.7246166956,-104.912910461
545 Monaco Street Pkwy, Denver, Colorado 80220, United States
#803556
lodging
39.7535249978,-104.964408875
2512 High St, Denver, Colorado 80205, United States
#293038
suitcase
27
39.7351782117,-104.951019287
3027 E 12th Ave, Denver, Colorado 80206, United States
#803556
lodging
39.7399303661,-104.967498779
1680 E Colfax Ave, Denver, Colorado 80218, United States
#293038
suitcase
28
39.8180298988,-104.914970398
6300 E 67th Ave, Commerce City, Colorado 80022, United States
#803556
lodging
39.7374223254,-104.996337891
Cherry Creek Trl, Denver, Colorado 80204, United States
#293038
suitcase
29
39.7396663661,-105.085945129
1450 Allison St, Denver, Colorado 80214, United States
#803556
lodging
39.752997101,-104.974536896
2440 Ogden St, Denver, Colorado 80205, United States
#293038
suitcase
30
https://www.geosheets.com/map/s:Lo6WyDJl/home-locations
https://www.geosheets.com/map/s:Lo6WyDJl/work-locations
31
32
PathDistance (miles)TypeColorLabel
33
39.7684364108,-105.081138611 | 39.7450781635,-104.991016388
5.051725line#8ac3ef
Distance from work: 5.05 miles
34
39.7977219958,-104.933166504 | 39.7479818796,-104.979686737
4.232488line#5cabe9
Distance from work: 4.23 miles
35
39.7061301493,-105.063972473 | 39.7394023651,-104.977798462
5.124157line#8ec5f0
Distance from work: 5.12 miles
36
39.6530198162,-104.958572388 | 39.7378183379,-104.990844727
6.105057line#c4e1f7
Distance from work: 6.11 miles
37
39.6612136258,-105.025177002 | 39.744418211,-104.984836578
6.135812line#c6e2f7
Distance from work: 6.14 miles
38
39.6765413702,-104.906730652 | 39.7541848631,-104.995994568
7.161515line#ffffff
Distance from work: 7.16 miles
39
39.7019039573,-104.875831604 | 39.7631584037,-104.978485107
6.90391line#f1f8fdDistance from work: 6.9 miles
40
39.7341221329,-104.873085022 | 39.7477179105,-104.99874115
5.545345line#a5d1f3
Distance from work: 5.55 miles
41
39.7647418483,-104.886474609 | 39.7560324523,-104.980716705
5.0416line#89c2ef
Distance from work: 5.04 miles
42
39.7853233146,-105.017623901 | 39.7528651262,-104.984664917
2.844855line#1c82d1
Distance from work: 2.84 miles
43
39.6955641841,-104.951705933 | 39.7465300369,-104.969387054
3.644612line#3c9ae4
Distance from work: 3.64 miles
44
39.7087713878,-104.997711182 | 39.7573521286,-104.969730377
3.671136line#3d9be5
Distance from work: 3.67 miles
45
39.7436262596,-105.034103394 | 39.7527331511,-104.989299774
2.461882line#1a75bc
Distance from work: 2.46 miles
46
39.7687003006,-104.997711182 | 39.7342541437,-104.976596832
2.631046line#1b7bc5
Distance from work: 2.63 miles
47
39.7246166956,-104.912910461 | 39.7535249978,-104.964408875
3.387605line#2d93e2
Distance from work: 3.39 miles
48
39.7351782117,-104.951019287 | 39.7399303661,-104.967498779
0.935119line#0e4067
Distance from work: 0.94 miles
49
39.8180298988,-104.914970398 | 39.7374223254,-104.996337891
7.048882line#f9fcfe
Distance from work: 7.05 miles
50
39.7396663661,-105.085945129 | 39.752997101,-104.974536896
5.989766line#beddf6
Distance from work: 5.99 miles
51
https://www.geosheets.com/map/s:Lo6WyDJl/commute-lines
52
53
54
Get the Geosheets Add-on
55
56
To see all available Geosheets functions visit:
57
https://www.geosheets.com/docs
58
59
Have feedback or questions? Email:
60
info@geosheets.com
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu