Fix Microsoft Excel Maps Not Recognizing Sandusky County, Ohio
Question details
The user needs an Excel map chart to recognize and display Sandusky County, Ohio, in a COVID-19 data visualization.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Creating an Ohio county-level map from source data that includes Sandusky County.
- Observed behavior
- Excel initially did not recognize Sandusky County despite its presence in the source data. The user reported that entering “SanDusky” worked, and the standard spelling “Sandusky” later worked as well.
Confirm that Sandusky County is included in the chart's source range and that its numeric value is valid. Keep Excel connected to the internet while testing, because map charts depend on online mapping data.
Standardize the county label and add state context
Use this first when one county is missing or Excel may be interpreting a location ambiguously.
Open the worksheet containing the map data and locate the Sandusky County row. Confirm that the county cell is populated and that the adjacent COVID-19 value is a number rather than an error or text.
Click the county cell and type “Sandusky County” without leading or trailing spaces. Use consistent county naming throughout the source column.
Add a State column containing “Ohio” and, if needed, a Country column containing “United States.” Keep the county, state, country, and value fields in separate columns.
Select the geographic columns and numeric values, then choose Insert > Maps > Filled Map. Check whether Sandusky County is now included.
Test county recognition in a new Excel workbook
Use a small test to determine whether the issue is limited to the original workbook or affects Excel more broadly.
Test Excel Safe Mode and repair Office on Windows
Use these Windows-only checks if county recognition still fails across multiple workbooks.
Use WPS Office to Review and Clean Your County Data
WPS Office is a free, lightweight alternative for reviewing the spreadsheet behind your map. Its familiar interface and Excel-format compatibility make migration straightforward for everyday data editing. It does not fix Excel's mapping service, and Excel-specific filled map behavior may not be preserved.

Frequently Asked Questions
Does Excel Maps recognize Sandusky County, Ohio?
Yes. Testing in the reported case showed that Excel recognized Sandusky County, and the user later confirmed that “Sandusky” worked. If it is missing from your chart, re-enter the county label, add an Ohio state column, and test through Insert > Maps > Filled Map.
Why did “SanDusky” work when “Sandusky” initially failed?
The exact cause was not confirmed. Re-entering the label may have prompted a fresh location lookup, or the mapping data may have had a temporary issue. Use the standard spelling rather than relying on unusual capitalization.
How can I stop Excel from confusing a county with a city?
Use “Sandusky County” as the county label and add separate State and Country columns containing “Ohio” and “United States.” Select those geographic fields along with your numeric values before choosing Insert > Maps > Filled Map.
What should I try if the county is missing only in one workbook?
Choose File > New > Blank workbook and create a small county, state, country, and value table. If a new filled map recognizes the county, inspect the original workbook's source range and labels, then create a fresh map from the corrected data.
Can WPS Office fix an Excel Maps location-recognition error?
No. WPS Office does not repair Microsoft Excel's mapping service. You can open the .xlsx file in WPS Spreadsheet to review and clean the source data, but use Excel to test the filled map and verify county recognition.




