How to Prevent Excel from Changing Text to Geography Data Type
Question details
Users need to stop Excel from automatically recognizing and converting plain text into linked Geography data types when downloading and opening workbooks.

- Product
- Excel for Microsoft 365
- Device & OS
- PC
- Scenario
- Downloading an Excel workbook containing geographical location names and opening it on a desktop computer.
- Observed behavior
- Excel automatically detects geographical text and links it to the Geography data type, resulting in #VALUE! errors if the linked data cannot be properly resolved online.
Before making changes to data types, ensure you have an offline backup copy of your workbook saved locally so you do not permanently lose any previously verified geographic linkages.
Revert Cells to Text and Remove Data Type Links
Manually unlink the Geography data type to return the cells back to plain text and clear the #VALUE! errors.
When Excel incorrectly tags your text data as a Geography type, you can manually sever the online connection. This immediately returns the text to its original state and removes any resolution errors.
Highlight all the cells in your spreadsheet that are displaying the #VALUE! error or have the unwanted Geography icon next to the text.
Right-click the selected cells, navigate down to 'Data Type' in the context menu, and click on 'Convert to Text'. This removes the automatic link.

Download Directly from OneDrive on the Web
Bypass Excel's native cloud-sync downloading process by retrieving the file straight from your web browser.
Use WPS Office to Prevent Unwanted Automatic Conversions
If Excel's automatic cloud-linked data types constantly break your spreadsheets with #VALUE! errors, consider switching to WPS Office. It provides robust spreadsheet tools without aggressive auto-conversions, ensuring your data stays exactly how you formatted it.
- 1. Download and Install: Get the free WPS Office installer from the official website and follow the simple setup prompts.
- 2. Open your Workbook: Launch WPS Spreadsheets and open your .xlsx file directly from your local drive.
- 3. Edit Seamlessly: Work with your text and geographical data safely without worrying about unwanted automatic conversions or #VALUE! errors.

Frequently Asked Questions
Why does my text suddenly turn into a Geography data type in Excel?
Excel for Microsoft 365 includes a smart feature that automatically recognizes geographical names, like cities or countries. It attempts to link these names to an online database to pull in extra geographical metrics. If it fails or you are offline, it often causes formatting issues or errors.
How do I fix the #VALUE! error caused by Geography data types?
You can resolve this by selecting the cells showing the #VALUE! error, right-clicking them, highlighting 'Data Type' in the menu, and then clicking 'Convert to Text'. This removes the broken online link and restores the original text.
Can I permanently turn off all automatic data type conversions in Excel?
Yes. You can disable this by going to File > Options > Data. Look for the 'Automatic Data Conversion' section and uncheck the specific options that allow Excel to automatically convert your plain text into specialized data types.




