Import CSV Data into Excel Without #NAME? Errors in Receipt IDs
Question details
The user needs to import CSV data into Excel while preserving Receipt IDs and symbol-based strings as their original text values.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A CSV file contains receipt identifiers or text strings that could be mistaken for formulas, dates, or numbers during import.
- Observed behavior
- Opening the CSV directly can cause Excel to convert values unexpectedly or display errors such as #NAME?.
Close the CSV file if it is already open in Excel. Identify the columns containing Receipt IDs, codes, leading zeros, or symbol strings so they can be assigned the Text data type during import.
Import the CSV with Excel Power Query and set Receipt IDs to Text
Use this method when a CSV contains identifiers or strings that Excel may interpret as formulas, dates, or numbers.
Importing through the Text/CSV connector lets you control column data types before values are loaded into the worksheet. Avoid opening the CSV by double-clicking it.
In Excel, open a blank workbook, select the Data tab, and choose From Text/CSV.
Browse to the CSV file, select it, and click Import to open the preview window.
In the preview window, select Transform Data instead of Load so you can change data types before importing.
Select the Receipt ID or affected string column, open the data type menu on the column header, and choose Text. Confirm Replace Current if Excel asks to replace the detected type.
Select Home > Close & Load to import the CSV into the Excel worksheet with the original text values preserved.
Use the Text Import Wizard when Power Query is unavailable
Use this option in Excel versions that provide the legacy text import workflow or when you need to assign text formatting during column setup.
Preserve Receipt IDs as Text When Importing CSV Files in WPS Spreadsheets
WPS Spreadsheets provides a practical way to open and review CSV data while keeping receipt identifiers and code-like values in text format. Import the file through WPS Spreadsheets, verify the delimiter and column layout, then format the affected identifier column as Text before working with the data.
- 1. Open WPS Spreadsheets: Launch WPS Office and select Spreadsheets to start a new workbook or open the CSV file from the File menu.
- 2. Select the CSV file: Choose File > Open, select the CSV file, and review the delimiter and preview options if an import dialog appears.
- 3. Check the imported identifier column: Locate the Receipt ID or code column after the file opens and select its column header.
- 4. Apply Text formatting: On the Home tab, open the Number Format list and choose Text before entering, pasting, or correcting identifier values.
Frequently Asked Questions
Why does Excel show #NAME? when I open a CSV file?
Excel can interpret a value beginning with special characters, such as an equals sign, as a formula. If the expression is not valid, Excel may return #NAME?. Import the file through Data > From Text/CSV and set the affected column to Text.
How do I keep leading zeros in CSV receipt numbers?
Use Data > From Text/CSV, select Transform Data, select the receipt number column, and set its data type to Text before choosing Home > Close & Load.
Can I change a column to Text after opening a CSV directly in Excel?
You can select the column and choose Home > Number Format > Text, but values already converted during opening may not return to their original form. Re-importing the original CSV with the column set to Text is more reliable.
Should I use Load or Transform Data when importing a CSV?
Choose Transform Data when you need to control column types, remove unwanted conversions, or inspect the data before it reaches the worksheet. Choose Load only when the previewed values are already correct.
Which CSV columns should be imported as Text?
Import receipt IDs, account numbers, postal codes, product codes, values with leading zeros, and strings containing symbols as Text whenever their exact characters must be preserved.
