Prevent Excel from Converting CSV Values into Formulas
Question details
The user wants Excel to preserve CSV values as plain text rather than interpreting them as formulas or numbers.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a CSV file containing text values such as phone numbers that begin with a plus sign.
- Observed behavior
- Excel may automatically interpret CSV values as formulas or numbers when the file is opened directly.
Locate the original CSV file and identify the columns that must remain text. Use Excel's import process instead of double-clicking the CSV, which can trigger automatic conversion.
Import the CSV into Excel with text column types
Use Excel's data import tools to preserve values such as phone numbers and leading plus signs as text.
In Excel, open a blank workbook and select Data > From Text/CSV. Choose the original CSV file and select Import.
In the import preview, set Data Type Detection to Do not detect data types if that option is available, then select Transform Data.
In Power Query, remove any automatic Changed Type step under Applied Steps. Select the columns you want to preserve, then choose Data Type > Text.
Select Home > Close & Load. Check that phone numbers, leading plus signs, and other important values match the original CSV.
Choose File > Save As and select Excel Workbook (.xlsx) to keep the imported text types while editing, leaving the original CSV unchanged.

Work with CSV data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. It does not change Excel's import behavior; check CSV import settings and verify text values when opening files in WPS.

Frequently Asked Questions
Can I stop all CSV conversions by opening the file normally?
There is no dependable global setting that preserves every CSV value as text when opened directly. Use Data > From Text/CSV and assign text types during import.
Why should I remove the Changed Type step?
Power Query may add a Changed Type step that converts values automatically. Remove it under Applied Steps before setting the relevant columns to Text.
Will formatting cells as text restore a plus sign that Excel removed?
Changing the cell format after conversion may not restore the original value. Reimport the original CSV using Data > From Text/CSV and set the affected column to Text before loading.
Does saving as CSV preserve my text column settings?
No. CSV stores values without Excel cell types or formatting. Save an XLSX copy through File > Save As if you need to retain the imported text types.




