Fix CSV Data Importing into Wrong Columns in Excel
Question details
The user needs to import CSV data into the correct Excel columns and investigate unexpected wrapping.
- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A user imports a CSV file into an Excel worksheet and expects each field to appear in its intended column.
- Observed behavior
- Some data appears in incorrect columns or wraps unexpectedly, depending on the file format and import method.
Open the CSV file in a text editor to check whether fields are separated by commas, semicolons, tabs, or another delimiter. Check whether the file instead uses fixed-width fields and whether text containing delimiters is enclosed in quotes.
Import the CSV with Power Query and set the delimiter
Use Power Query when a delimited file opens with fields in the wrong columns or with incorrect data types.
In Excel, select Data > From Text/CSV, choose the CSV file, and select Import.
In the import preview, choose the delimiter used in the file and check that the fields appear in the expected columns.
Select Transform Data to open Power Query. Select each column and use its data type control to set the appropriate type, such as Text for identifiers with leading zeros.
Select Home > Close & Load to place the imported data in a worksheet. Check the resulting columns against the source file.
Import fixed-width data with the Text Import Wizard
Use the legacy Text Import Wizard when fields are aligned by character position rather than separated by delimiters.
Check wrapping and test the import in a new worksheet
Use these checks if the columns appear correct but cell contents still look wrapped or the issue continues.
Import CSV data into WPS Spreadsheets
Use the text import options in WPS Spreadsheets to preview a CSV file, select its delimiter, and place fields in separate columns.
- 1. Open a spreadsheet: Launch WPS Spreadsheets and open a new workbook.
- 2. Start the import: Go to the Data tab and choose the text or data import option, then select your CSV file. The option name may vary by WPS version.
- 3. Review the fields: In the import wizard, select the delimiter used by the file and check the column preview. Set column formats where needed.
- 4. Finish and save: Complete the import, check the worksheet, and use File > Save As to save it in a format such as XLSX.
Frequently Asked Questions
Why does my CSV open in the wrong columns?
Excel may have detected the wrong delimiter, or the file may contain inconsistent quoting. Open the file in a text editor, then use Data > From Text/CSV and choose the delimiter that matches the file.
How can I keep leading zeros when importing a CSV?
In Data > From Text/CSV, select Transform Data. In Power Query, set the relevant column's data type to Text before choosing Close & Load.
How do I stop imported text from wrapping in a cell?
Select the affected cells and toggle Home > Wrap Text off. If the text still contains line breaks, check the source field for actual line-break characters.
Can Excel import a file with fixed-width fields?
Where available, enable From Text (Legacy) under File > Options > Data, then select Data > Get Data > Legacy Wizards > From Text (Legacy). Choose Fixed width and set the column breaks in the wizard.
