Data Import & Export

Prevent Excel from Converting CSV Values into Formulas

Jason MillerJason Miller Nov 20, 2026 869 views

Question details

The user wants Excel to preserve CSV values as plain text rather than interpreting them as formulas or numbers.

Prevent Excel from Converting CSV Values into Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Start the import

In Excel, open a blank workbook and select Data > From Text/CSV. Choose the original CSV file and select Import.

2
Disable type detection

In the import preview, set Data Type Detection to Do not detect data types if that option is available, then select Transform Data.

3
Set columns to text

In Power Query, remove any automatic Changed Type step under Applied Steps. Select the columns you want to preserve, then choose Data Type > Text.

4
Load and check the data

Select Home > Close & Load. Check that phone numbers, leading plus signs, and other important values match the original CSV.

5
Save a workbook copy

Choose File > Save As and select Excel Workbook (.xlsx) to keep the imported text types while editing, leaving the original CSV unchanged.

Import the CSV into Excel with text column types
CSV files do not store cell types: Saving the data back to CSV does not preserve Excel's text formatting. A CSV may be converted again when opened directly, so use the import process when reopening it.
Free Microsoft Office alternative

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.

Open and work with CSV data in WPS SpreadsheetsCompatible with Microsoft Excel XLSX filesFamiliar spreadsheet interface for easier migrationFree and lightweight office suite
microsoft office alternative - wps office

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.