CDXGeoStream brings postal geography into your spreadsheet. Look up the city, county or state for any U.S. ZIP code or Canadian postal code, measure straight-line or driving distance and time, find every ZIP code within a radius, verify addresses against USPS data, geocode addresses, put maps in your sheet, and pull census demographics for a ZIP code, city, county or state. CELL FUNCTIONS Type them like any other formula. The ones that return one value per row, such as CDXCITY and CDXDISTANCE, also take a whole column, so one formula can answer every row. - CDXCITY, CDXSTATE, CDXCOUNTY: the city, state or province, and county for a ZIP or postal code - CDXDISTANCE: straight-line distance between two ZIP or postal codes, cross-border included - CDXDISTANCE2WP: straight-line distance between two latitude/longitude points - CDXROUTE: driving distance or time by road - CDXRADIUS: every ZIP or postal code within a radius, with its distance - CDXCLOSESTZIP: the closest ZIP or postal code to a target, from a list you provide - CDXZIPLIST: the ZIP codes in a state, narrowed by county and city if you like - CDXGEOCODE: latitude and longitude, or a single field, for an address, ZIP or postal code - CDXREVGEOCODE: the address at a latitude/longitude - CDXVERIFY: the USPS-standardized address and ZIP+4 for a U.S. street address - CDXCENSUS: a demographic value for a ZIP code, such as population, median income or median age - CDXCITYDATA, CDXCOUNTYDATA, CDXSTATEDATA: the same values for a whole city, county or state The sidebar's Insert function wizard builds any of these for you, with dropdowns for the fields. BULK TOOLS Select a range and pick a tool from the sidebar. Lookups fill columns beside your selection; reports such as address verification, distance matrices and demographics go to a new, formatted tab. Any tool that uses more than a few credits shows the cost before it runs. - Verify addresses (USPS), and deduplicate and flag a list - Geocode selected addresses, or reverse geocode coordinates - Find ZIPs in a radius, find the closest ZIP, or list the ZIP codes in an area - Look up ZIP data, demographics and census tract FIPS codes - Build a distance matrix between two lists, straight-line or driving - Sort a list by distance, or optimize a route through a set of stops - Insert a map, plot a list, or map a set of addresses GETTING STARTED 1. Install the add-on, then choose Extensions > CDXGeoStream > Authorize add-on once. 2. Choose Extensions > CDXGeoStream > Settings. A short setup tour takes your API key and walks you through your first formula. 3. Don't have a key? The tour links to a free account at cdxgeostream.com. No credit card is required. Your API key is saved privately to your Google account and is never shared with other people who use the add-on. A sheet's formulas use the key of the sheet's owner. PLANS CDXGeoStream needs a CDXGeoStream account. The Free plan includes a monthly credit allowance for ZIP and postal code lookups, straight-line distance and radius searches, demographics, USPS address verification, and census tracts for a ZIP code or coordinates. Street-address geocoding and census tracts, reverse geocoding, driving distance and time (including driving distance matrices), maps and road route optimization need a paid plan or a credit pack. Plans and credit packs are bought at cdxgeostream.com/plans. Nothing is billed through Google. Help: app.cdxgeostream.com/help Support: cdxgeostream.com/support