Data Import & Export

Import CSV Files into Excel Without Losing Columns

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

Import comma-separated fuel purchase data into separate Excel columns without misinterpreting separators or dates.

Import CSV Files into Excel Without Losing Columns
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has a CSV export containing fuel purchase records and wants to open it as a structured worksheet.
Observed behavior
Pasting CSV text directly can put all values in one column or cause separators and dates to be interpreted incorrectly.
Before you start

Locate the original CSV file and check a few rows to confirm that commas separate the fields. Identify columns, such as dates or account numbers, that need a specific format or must retain leading zeros.

Solution 1Recommended

Import the CSV with Excel's Text/CSV tool

Use this method to preview the delimiter and data types before loading the file; the resulting query can also be refreshed for repeat imports.

1
Select the CSV file

In Excel, open the Data tab and choose From Text/CSV. Select the fuel purchase CSV file and click Import.

2
Check the preview

In the import preview, set the delimiter to Comma and check that the fields appear in separate columns. Adjust File Origin if special characters are displayed incorrectly.

3
Set column types

Click Transform Data to open Power Query. Select each relevant column and use the Data Type menu to set it to Text, Date, or another appropriate type. Use Change Type > Using Locale when dates require a particular regional format.

4
Load the data

Select Home > Close & Load in Power Query to load the results into Excel. Check several dates, amounts, and identifiers against the CSV.

5
Refresh later imports

After the source file is updated, use Data > Refresh All to reload it through the same query.

Import the CSV with Excel's Text/CSV tool
Preserve identifiers: Set columns with leading zeros to Text before loading. If automatic type detection has already changed them in Power Query, remove the Changed Type step under Applied Steps and set the types manually.
Import CSV in WPS Spreadsheets

Split CSV Data into Columns with WPS Spreadsheets

Use Text to Columns in WPS Spreadsheets to separate comma-delimited fuel purchase records that are already in one column, then save the worksheet in Excel format.

  1. 1. Open your data: Open WPS Spreadsheets and use File > Open to open a workbook containing the CSV text in one column, or paste the text into a blank worksheet.
  2. 2. Select the column: Select the cells containing the comma-separated records and make sure the columns to their right are empty.
  3. 3. Split the text: Choose Data > Text to Columns, select a delimited split, and choose Comma. Check the preview and set column formats where available.
  4. 4. Save the worksheet: Finish the split, check the dates and identifiers, and choose File > Save As to save the result as an Excel workbook.
Split comma-separated fuel purchase records into separate columnsSet text or date formats during the split when availableOpen and save Microsoft Excel XLSX filesWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does my CSV appear in one Excel column?

Excel may not have recognized the comma as the delimiter, especially when text was pasted directly. Use Data > From Text/CSV and select Comma in the preview, or use Data > Text to Columns on the pasted data.

How can I stop Excel from changing dates during import?

In Data > From Text/CSV, choose Transform Data and set the relevant column's type in Power Query. Use Change Type > Using Locale to specify the date format's region, or import the column as Text.

How do I keep leading zeros in CSV fields?

Import the original file using Data > From Text/CSV, select Transform Data, and set the affected columns to Text before loading. Remove an automatic Changed Type step first if it has already altered the values.

Can I update the imported data when the CSV changes?

Yes. If you imported the file through Data > From Text/CSV, update the source file and then choose Data > Refresh All to run the query again.