Data Import & Export

How to Fix Excel Geography Data Changing Washington, D.C. to Washington

Maira MehtabMaira Mehtab Nov 4, 2026 868 views

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.

How to Fix Excel Geography Data Changing Washington, D.C. to Washington
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel on your Mac

Launch Microsoft Excel and open the workbook containing the incorrect geography data.

2
Navigate to the Feedback menu

Click on the 'Help' menu in the top macOS menu bar, then select 'Feedback' from the dropdown list.

3
Provide issue details

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.

4
Submit your report

Click 'Submit' to send the diagnostic information directly to Microsoft's development team.

Report the Geographic Data Issue via Excel Feedback
Data Provider Updates: In many instances, once reported, the Geography data is corrected directly by the data provider in subsequent background updates without requiring an Excel software patch.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the official website and install it on your Mac or PC.
  2. 2. Open your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet with zero format loss.
  3. 3. Manage Data Securely: Edit your tables and slicers with full manual control over your geographic data.
Completely free and lightweight office suiteSeamless format compatibility with Microsoft Excel (.xlsx) filesPrevents unexpected automatic online data overridesFamiliar user interface for a quick and easy transition
microsoft office alternative - wps office

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.