How to Fix Excel Geography Data Changing Washington, D.C. to Washington
Question details
Users experience an issue where Excel's Geography data type incorrectly alters 'Washington, D.C.' to 'Washington', disrupting data accuracy in tables and slicers.

- Product
- Microsoft Excel 365
- Device & OS
- macOS
- Scenario
- Applying the Geography data type to location names in Excel for mapping or regional data analysis.
- Observed behavior
- Excel automatically changes 'Washington, D.C.' to 'Washington', treating the city as the state. This merges the data incorrectly and skews results in connected PivotTables, charts, and slicers.
Ensure your Mac has an active internet connection, as the Geography data type relies on an online connection to Bing to retrieve and update geographic information.
Report the Geographic Data Issue via Excel Feedback
Since Geography data is pulled directly from a third-party data provider (Bing), reporting the error is the most effective way to secure a permanent backend fix from Microsoft.
Geographic data changes dynamically based on the provider's algorithms. When data merges unexpectedly, the best resolution is to flag the specific entity error so the provider can correct their database mapping.
Launch Microsoft Excel and open the workbook containing the incorrect geography data.
Click on the 'Help' menu in the top macOS menu bar, then select 'Feedback' from the dropdown list.
Describe how 'Washington, D.C.' changes to 'Washington'. Be sure to include your exact Excel version, macOS version, the specific affected entries, and the steps to reproduce the problem.
Click 'Submit' to send the diagnostic information directly to Microsoft's development team.

Use Alternative Location Identifiers as a Workaround
While waiting for a provider fix, adjust your source text to force Excel to recognize the correct geographic entity.
Experience Smooth Data Management with WPS Office
If you are frustrated by automatic data conversions, online dependencies, and provider-side errors in Excel, WPS Office Spreadsheet provides a lightweight, highly compatible alternative for your data analysis needs. Enjoy complete control over your spreadsheets without unexpected data merging.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your Mac or PC.
- 2. Open your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet with zero format loss.
- 3. Manage Data Securely: Edit your tables and slicers with full manual control over your geographic data.

Frequently Asked Questions
Why does Excel change my geographic data automatically?
Excel's Geography data type relies on an online service powered by Bing. If the service's algorithm identifies 'Washington, D.C.' as a synonym or subset of 'Washington', it may automatically merge them. This usually requires a backend mapping fix from the data provider.
Can I disable automatic data type updates in Excel?
Yes. If you want to prevent Excel from automatically refreshing your geography data, you can right-click the cell, select 'Data Type', and choose 'Convert to Text'. This locks the data exactly as written but removes the interactive geography features.
Will this issue affect my existing charts and slicers?
Yes. When 'Washington, D.C.' is incorrectly merged into 'Washington', Excel combines the data points for both the city and the state into one category. This will skew the aggregated results in any connected PivotTables, charts, and slicers.




