CDXZipStream

Help & support

Everything you need to use CDXZipStream in Excel, Google Sheets, and LibreOffice Calc.

Getting started

CDXZipStream adds ZIP-code distance, lookup, radius, demographics, and geocoding functions to your spreadsheet. Three steps to get going:

  1. Set your API key. Open the CDXZipStream pane in your spreadsheet and paste your key. No key yet? See plans & buy ↗
  2. Type a function in any cell, e.g. =CDX.DISTANCE("10001","94105").
  3. Need a hand? Contact support ↗

Tip — point at cells & fill down. Reference cells instead of typing values, e.g. =CDX.DISTANCE(A2, B2), then copy the formula down the column to compute every row (the add-in batches the calls for you). In Google Sheets you can also pass a whole range at once: =CDXCITY(A2:A100). How cell references & filling down work ↗

Install CDXZipStream

Pick where you want to install CDXZipStream. The steps genuinely differ per host.

Excel on the web

  1. 1Download the manifest (a small .xml file). Always use this copy — it points at the live CDXZipStream servers.
  2. 2In Excel on the web, open a workbook and choose Home ▸ Add-ins.
  3. 3Click More Add-ins, then the My Add-ins tab, then Upload My Add-in (top right).
  4. 4Browse… to the manifest you downloaded and choose Upload. The CDXZipStream button appears on the Home tab.
  5. 5Open the CDXZipStream pane and paste your API key when prompted. The key is stored for this Excel install; the cell functions read the same key, so =CDX.CITY("90210") starts working immediately.

Uploading a manifest this way installs the add-in for this browser and this workbook. It stays until you clear the browser’s cached add-ins — reload the workbook and it comes back. Nothing is installed on your machine.

Excel for Windows (desktop)

  1. 1Download the manifest and save it into a folder you can share — e.g. C:\CDXZipStream.
  2. 2Right-click that folder ▸ Properties ▸ Sharing ▸ Share… and share it with yourself. Copy the full network path it shows (it looks like \\YOURPC\CDXZipStream).
  3. 3In Excel: File ▸ Options ▸ Trust Center ▸ Trust Center Settings… ▸ Trusted Add-in Catalogs.
  4. 4Paste the network path into Catalog Url, click Add catalog, tick Show in Menu, then OK. Close and reopen Excel.
  5. 5Insert ▸ My Add-ins ▸ Shared Folder → select CDXZipStream Add.
  6. 6Open the CDXZipStream pane and paste your API key when prompted. The key is stored for this Excel install; the cell functions read the same key, so =CDX.CITY("90210") starts working immediately.

The shared-folder catalog is Microsoft’s supported way to install an add-in that isn’t from the store — the folder only needs to be shared, not on a server, and it can be your own PC. Requires Microsoft 365 or Office 2021 or newer: the add-in uses a shared runtime, which older Office builds do not support.

Excel for Mac (desktop)

  1. 1Download the manifest.
  2. 2In Finder press ⇧⌘G and go to: ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef
  3. 3If the wef folder does not exist, create it. Copy the manifest into it.
  4. 4Restart Excel, then choose Insert ▸ My Add-ins and pick CDXZipStream. (If it isn’t listed, quit Excel completely — ⌘Q — and reopen.)
  5. 5Open the CDXZipStream pane and paste your API key when prompted. The key is stored for this Excel install; the cell functions read the same key, so =CDX.CITY("90210") starts working immediately.

Requires Microsoft 365 or Office 2021 or newer. The wef folder is Excel’s sideload location on macOS; files placed there are picked up at startup only, which is why the restart matters.

LibreOffice Calc

  1. 1Download the extension CDXZip.oxt, version 0.6.0. One file works on Windows, macOS and Linux.
  2. 2Double-click the file. LibreOffice opens the Extension Manager and asks you to confirm. (Equivalent: Tools ▸ Extension Manager… ▸ Add.)
  3. 3Restart LibreOffice — close every window, including any hidden Start Center, then reopen Calc.
  4. 4In Calc, choose CDXZipStream ▸ Set API key… from the menu bar and paste your key. Then CDXZipStream ▸ Check key & credits to confirm it works — that check is free and doesn’t use any credits.
  5. 5Try it: right-click a cell ▸ CDXZipStream ▸ Insert CDXZipStream function…, or type =CDXCITY("90210") directly.

Already have an older version? Install this one over the top — the Extension Manager replaces it and your API key is kept. If you are on 0.1.x this is required: 0.2.0 changed the add-in’s internal interface, so an 0.1.x copy will not load at all.

Linux only: the add-in is written in Python, and some distributions ship LibreOffice without Python support. If the functions are missing after a restart, install python3-uno (Debian/Ubuntu: sudo apt install python3-uno) and restart again. Windows and macOS builds include Python already.

List functions need a range. Unlike Excel, Calc doesn’t spill automatically — a single cell shows only the first result. Either use Insert function… and tick Fill a range for me, or select the range first and press Ctrl+Shift+Enter instead of Enter.

Cell references & filling down

Every CDX function can take its inputs from cells, not just typed-in values — so you can compute a whole sheet at once. A few details differ between Excel, Google Sheets, and LibreOffice Calc.

Reference a cell

Point an argument at a cell instead of typing a value: =CDX.DISTANCE(A2, B2) uses the ZIPs in A2 and B2. In the Insert wizard, just type a cell address (like A2) into a field. Works in all three apps.

Apply it to many rows

  • Excel — put the formula in the first row (=CDX.DISTANCE(A2, B2)), then drag the fill handle (or copy/paste) down the column. References shift per row, and the add-in automatically batches the calls — thousands of rows resolve in just a few requests.
  • Google Sheets — fill down works the same, or hand a whole range to the first argument and get the column back in one formula: =CDXCITY(A2:A1000).
  • LibreOffice Calc — fill down just like Excel. Use your locale's argument separator (often ;): =CDXDISTANCE(A2;B2).

List functions (RADIUS, ZIPLIST)

These already return a whole list, so don't fill them down. Excel and Google Sheets spill the results automatically — use List output direction in Insert defaults to choose down-a-column or across-a-row. LibreOffice fills the cells below the formula.

Canadian postal codes 🍁

The location functions accept Canadian postal codes (e.g. M5H 2N2) anywhere they take a US ZIP, and a Canadian province anywhere they take a US state. Distances and routes work cross-border — e.g. =CDX.DISTANCE("M5H 2N2", "10001") (Toronto → New York).

  • Where it applies — CITY, STATE, COUNTY, FINDZIP, ZIPLIST, DISTANCE, RADIUS, CLOSESTZIP, GEOCODE, REVGEOCODE, ROUTE, DRIVETIME, and the demographics functions (CENSUS, CITYDATA, COUNTYDATA, STATEDATA).
  • County & demographics — COUNTY returns the Census Division (Canada's county equivalent). Demographics come from Statistics Canada's census: CENSUS resolves a postal code to its Forward Sortation Area (the first 3 characters); CITYDATA, COUNTYDATA and STATEDATA use the census subdivision (municipality), census division, and province.
  • Included on every plan — Canadian data is available to all accounts, no add-on required.
  • Fields without a Canadian equivalent — a few demographic fields are US-only and return no value for Canada: per-capita income, the US race/ethnicity breakdowns, vacancy rate, and business counts. (Poverty maps to Canada's low-income measure.)
Loading function reference…

Contact support

Can't find what you need here? Our support team can help.

Go to support ↗