
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:
- Set your API key. Open the CDXZipStream pane in your spreadsheet and paste your key. No key yet? See plans & buy ↗
- Type a function in any cell, e.g.
=CDX.DISTANCE("10001","94105"). - 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
- 1Download the manifest (a small
.xmlfile). Always use this copy — it points at the live CDXZipStream servers. - 2In Excel on the web, open a workbook and choose Home ▸ Add-ins.
- 3Click More Add-ins, then the My Add-ins tab, then Upload My Add-in (top right).
- 4Browse… to the manifest you downloaded and choose Upload. The CDXZipStream button appears on the Home tab.
- 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)
- 1Download the manifest and save it into a folder you can share — e.g.
C:\CDXZipStream. - 2Right-click that folder ▸ Properties ▸ Sharing ▸ Share… and share it with yourself. Copy the full network path it shows (it looks like
\\YOURPC\CDXZipStream). - 3In Excel: File ▸ Options ▸ Trust Center ▸ Trust Center Settings… ▸ Trusted Add-in Catalogs.
- 4Paste the network path into Catalog Url, click Add catalog, tick Show in Menu, then OK. Close and reopen Excel.
- 5Insert ▸ My Add-ins ▸ Shared Folder → select CDXZipStream → Add.
- 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)
- 1Download the manifest.
- 2In Finder press ⇧⌘G and go to:
~/Library/Containers/com.microsoft.Excel/Data/Documents/wef - 3If the
weffolder does not exist, create it. Copy the manifest into it. - 4Restart Excel, then choose Insert ▸ My Add-ins and pick CDXZipStream. (If it isn’t listed, quit Excel completely — ⌘Q — and reopen.)
- 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
- 1Download the extension —
CDXZip.oxt, version 0.6.0. One file works on Windows, macOS and Linux. - 2Double-click the file. LibreOffice opens the Extension Manager and asks you to confirm. (Equivalent: Tools ▸ Extension Manager… ▸ Add.)
- 3Restart LibreOffice — close every window, including any hidden Start Center, then reopen Calc.
- 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.
- 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.)
Contact support
Can't find what you need here? Our support team can help.
Go to support ↗