Data Import & Export

Preserve 23.20 Text Values When Exporting Excel to CSV

Algirdas JasaitisAlgirdas Jasaitis Nov 12, 2026 869 views

Question details

Prevent text values such as 23.20 from being automatically interpreted and displayed as 23.2 after a CSV file is saved and reopened.

Preserve 23.20 Text Values When Exporting Excel to CSV
Product
Microsoft Excel CSV export and import
Device & OS
not provided
Scenario
The user exports worksheet data to a CSV file and needs a trailing zero to remain part of a text value.
Observed behavior
CSV files do not retain Excel cell formatting, and Excel can reopen 23.20 as a numeric value and display it as 23.2.
Before you start

A CSV is plain text and does not store Excel number formats or column data types. First, open the CSV in a text editor, such as Notepad, to determine whether 23.20 is stored correctly in the file.

Solution 1Recommended

Import the CSV column as text in Excel

Use this method when the CSV already contains values such as 23.20 and you need Excel to retain every character when loading the file.

Opening a CSV by double-clicking lets Excel automatically detect data types. Importing it through the Data tab lets you designate the affected column as Text instead.

1
Start a text/CSV import

In Excel, open a blank workbook, select the Data tab, and choose From Text/CSV.

2
Select the CSV file

Browse to the CSV file, select it, and choose Import to open the preview and import settings.

3
Set the affected column to text

In the import or transform options, select the column containing values such as 23.20 and set its data type to Text rather than a numeric or automatic type.

4
Load the data

Choose Load after confirming the column type. Excel will keep 23.20 as text instead of displaying it as 23.2.

Import the CSV column as text in Excel
Trailing zero preserved: When the column is imported as Text, Excel treats 23.20 as characters, so the trailing zero remains visible.
Keep CSV Values as Text

Import CSV Values as Text with WPS Spreadsheets

WPS Spreadsheets lets you import CSV data while controlling how individual columns are interpreted. Select the column containing values such as 23.20 and load it as text to prevent automatic numeric conversion.

  1. 1. Open the CSV import command: In WPS Spreadsheets, create or open a workbook and use the Data tab to open the CSV or text import option.
  2. 2. Choose the CSV file: Select the CSV file that contains the values you want to preserve and continue to the import preview.
  3. 3. Mark the column as text: Select the relevant column, such as the Sprint column, and set its data format to Text.
  4. 4. Load and check the values: Complete the import and confirm that values such as 23.20 remain unchanged in the worksheet.
Choose Text for CSV columns that must retain trailing zeros.Review CSV values before loading them into a worksheet.Compatible with Microsoft Excel CSV, XLS, and XLSX files.Use a familiar spreadsheet interface for editing and exporting data.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show 23.20 as 23.2 after I reopen a CSV file?

Excel automatically interprets unquoted values such as 23.20 as numbers when a CSV is opened directly. Its General number display removes insignificant trailing zeros, even if the CSV text contains 23.20.

Does a CSV file save Excel number formatting?

No. CSV files store plain values separated by delimiters; they do not retain Excel number formats, formulas, column widths, or data-type settings.

How can I check whether 23.20 is actually present in my CSV?

Open the CSV with a plain-text editor such as Notepad and locate the relevant row. If the text editor shows 23.20, the CSV stored the value correctly and Excel is only reinterpreting it on open.

What is the best way to open a CSV without losing trailing zeros in Excel?

In a blank workbook, select Data > From Text/CSV, choose the file, and set the affected column's data type to Text before loading it.

Can I use an apostrophe to force 23.20 to be text?

Yes, for manually entered source values, typing an apostrophe before 23.20 tells Excel to treat the entry as text. Check the resulting CSV in a text editor because the apostrophe may be written as a literal character depending on the export workflow.