Data Import & Export

How to Prevent Excel from Changing Text to Geography Data Type

Jason MillerJason Miller Nov 2, 2026 871 views

Question details

Users need to stop Excel from automatically recognizing and converting plain text into linked Geography data types when downloading and opening workbooks.

How to Prevent Excel from Changing Text to Geography Data Type
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 you start

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.

Solution 1Recommended

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.

1
Select the affected cells

Highlight all the cells in your spreadsheet that are displaying the #VALUE! error or have the unwanted Geography icon next to the text.

2
Convert back to 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.

Revert Cells to Text and Remove Data Type Links
Free Microsoft Office alternative

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. 1. Download and Install: Get the free WPS Office installer from the official website and follow the simple setup prompts.
  2. 2. Open your Workbook: Launch WPS Spreadsheets and open your .xlsx file directly from your local drive.
  3. 3. Edit Seamlessly: Work with your text and geographical data safely without worrying about unwanted automatic conversions or #VALUE! errors.
Keeps plain text as plain text without forcing automatic online data type conversions.Fully compatible with all Microsoft Excel file formats, including .xlsx, .xls, and .csv.Lightweight desktop app that loads fast and runs smoothly on your PC without heavy background syncing.Free to use with a highly familiar, easy-to-navigate spreadsheet interface.
microsoft office alternative - wps office

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.