Data Import & Export

How to Fix Excel ZIP Code Geography Data Not Showing County in WPS Spreadsheets

Huda QurayshiHuda Qurayshi Nov 13, 2026 868 views

Question details

User needs to retrieve county information from ZIP codes after Excel's Geography data type stopped showing county data because Microsoft discontinued the underlying Wolfram data types.

How to Fix Excel ZIP Code Geography Data Not Showing County in WPS Spreadsheets
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
The user manages ZIP code data in a spreadsheet and previously relied on Excel's Geography data type to add county names; now the county field no longer appears.
Observed behavior
ZIP code Geography data no longer shows county information such as Administrative Division 2, so no reliable county value is returned.
Before you start

Download or prepare an authoritative ZIP-code-to-county lookup table with separate ZIP and County columns, and confirm that your WPS Office version supports XLOOKUP.

Solution 1Recommended

Use XLOOKUP to Pull County from an Authoritative ZIP-County Table

Use this method when the built-in Geography data type no longer returns county information, or when you need a stable and refreshable way to map ZIP codes to counties.

Excel and WPS Spreadsheets cannot repair Microsoft's discontinued Wolfram-based Geography data service. Instead, keep county data in an external lookup table so the result is transparent, updatable, and independent of online data types.

1
Create or import a ZIP-county lookup table

In WPS Spreadsheets, create a sheet named ZipCounty with at least two columns: ZIP and County. Paste or import an authoritative ZIP-to-county dataset into this sheet.

2
Convert the data range to a table

Select the lookup range, go to the Insert tab, and click Table so it can be referenced as ZipCounty[ZIP] and ZipCounty[County].

3
Enter the XLOOKUP formula

In the cell where you want the county, enter =XLOOKUP(A2,ZipCounty[ZIP],ZipCounty[County],"Not found") and press Enter.

4
Fill the formula down

Drag the fill handle down the column to apply the formula to all ZIP code rows.

Use XLOOKUP to Pull County from an Authoritative ZIP-County Table
County values restored: The formula returns the matching county for each ZIP code and shows "Not found" when a ZIP code is missing from the lookup table.
Data Import & Export fix

Use WPS Spreadsheets to Map ZIP Codes to Counties Without Excel Geography Data

Open your Excel workbook in WPS Office, add an authoritative ZIP-county lookup table, and use XLOOKUP to return county names directly. This avoids the discontinued Wolfram data service while keeping your workbook fully compatible with Excel.

  1. 1. Download and install WPS Office: Download WPS Office Free from the official WPS website, run the installer, and sign in or skip to open the spreadsheet.
  2. 2. Open your Excel workbook: In WPS Office, click Open, select the .xlsx file containing ZIP codes, and confirm the worksheet displays correctly.
  3. 3. Add the ZIP-county lookup table: Create a new sheet named ZipCounty, paste the authoritative ZIP and County data, and format it as a table from the Insert tab.
  4. 4. Apply XLOOKUP to the ZIP column: Enter =XLOOKUP(A2,ZipCounty[ZIP],ZipCounty[County],"Not found") in the county column and fill it down to populate county names.
Free desktop tool for opening, editing, and saving .xlsx workbooks without a Microsoft 365 subscriptionKeeps full Microsoft Excel format compatibility for XLOOKUP formulas, tables, and shared filesGives you a stable, offline ZIP-code-to-county mapping that does not depend on retired online data servicesFamiliar ribbon interface makes it easy to insert tables and write lookup formulas
microsoft office alternative - wps office

Frequently Asked Questions

Why did the Excel Geography data type stop returning county for ZIP codes?

Microsoft discontinued the underlying Wolfram data types in June, so Excel no longer supplies fields such as Administrative Division 2 for ZIP code geography. Existing cells may remain, but new or refreshed lookups fail.

Can WPS Spreadsheets replace the Excel Geography county field?

Yes. Use an authoritative ZIP-code-to-county lookup table and a lookup formula such as =XLOOKUP(A2,ZipCounty[ZIP],ZipCounty[County],"Not found") to return the county for each ZIP code.

Does WPS Office support XLOOKUP?

Recent versions of WPS Office support XLOOKUP. If your version does not, you can use =VLOOKUP(A2,ZipCounty,2,FALSE) for an exact match.

Where can I find an authoritative ZIP code to county dataset?

Use official or public datasets such as the U.S. Census Bureau ZIP Code Tabulation Area files, HUD USPS ZIP code crosswalk files, or equivalent authoritative sources for your region.

Will my .xlsx workbook formulas work after opening in WPS Office?

Yes. WPS Office opens and saves .xlsx files and supports common Excel functions and table references, so your lookup formulas and workbook structure remain compatible.