ABCDE
1
A simple tool for finding the nearest location to a zip code from a list of locations
2
It would be more accurate with a circular distance calculation, but for now linear is much easier and is accurate enough for my purposes
3
4
After pasting data, give it time to run calculations. Depending on data set size it can take several minutes.
5
Paste in list of users and zip codes hereSet list of locations using the "Location Data" tab
6
7
PASTE IN EMAIL AND ZIPNearest Location
8
EmailZipLocation
9
useremail@email.com137216Ruffner Mountain Nature Center, Birmingham, AL, USA
10
useremail@email.com290639Topanga State Park, Topanga, CA, USA
11
useremail@email.com335227Ruffner Mountain Nature Center, Birmingham, AL, USA
12
useremail@email.com410220Rothrock State Forest, State College, PA, USA
13
useremail@email.com561188Grant Park, Chicago, IL, USA
14
useremail@email.com654629Wisconsin Interstate State Park
15
useremail@email.com770293Gulf State Park, Gulf Shores, AL, USA
16
useremail@email.com874530Little Sandy National Wildlife Refuge, Lindale, TX, USA
17
useremail@email.com934115Myakka State Forest, Englewood, FL, USA
18
useremail@email.com1022860Lantz Farm and Nature Preserve, WV, USA
19
useremail@email.com1170372Gulf State Park, Gulf Shores, AL, USA
20
useremail@email.com1286515Petrified Forest National Park
21
useremail@email.com1370689Anahuac National Wildlife Refuge, Anahuac, TX, USA
22
useremail@email.com1413311Rothrock State Forest, State College, PA, USA
23
useremail@email.com1593837Yosemite National Park, California, USA
24
useremail@email.com1661436Grant Park, Chicago, IL, USA
25
useremail@email.com1759605Yellowstone National Park, WY, USA
26
useremail@email.com1852610Grant Park, Chicago, IL, USA
27
useremail@email.com1961535Grant Park, Chicago, IL, USA
28
useremail@email.com2088938Garden of Gods, Colorado Springs, CO, USA
29
useremail@email.com2175095Little Sandy National Wildlife Refuge, Lindale, TX, USA
30
useremail@email.com2293676Kings Canyon National Park, California, USA
31
useremail@email.com2328364Kings Mountain State Park, Blacksburg, SC, USA
32
useremail@email.com2475535Little Sandy National Wildlife Refuge, Lindale, TX, USA
33
useremail@email.com2559567Yellowstone National Park, Wyoming, USA
34
useremail@email.com2666697Little Sandy National Wildlife Refuge, Lindale, TX, USA
35
useremail@email.com2724391Kings Mountain State Park, Blacksburg, SC, USA
36
useremail@email.com2844489Lantz Farm and Nature Preserve, WV, USA
37
useremail@email.com2933447Oleta River State Park, North Miami, FL, USA
38
useremail@email.com3062899Grant Park, Chicago, IL, USA
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
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