How to Fix Excel ZIP Code Geography Data Not Showing County in WPS Spreadsheets
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.

- 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.
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.
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.
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.
Select the lookup range, go to the Insert tab, and click Table so it can be referenced as ZipCounty[ZIP] and ZipCounty[County].
In the cell where you want the county, enter =XLOOKUP(A2,ZipCounty[ZIP],ZipCounty[County],"Not found") and press Enter.
Drag the fill handle down the column to apply the formula to all ZIP code rows.

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. 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. Open your Excel workbook: In WPS Office, click Open, select the .xlsx file containing ZIP codes, and confirm the worksheet displays correctly.
- 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. 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.

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.




