Skip to main content

How to convert csv file to xls file or import/open csv in Excel?

Author: Sun Last Modified: 2024-09-19

This tutorial will tell you how to open csv file in Excel, how to convert csv file to xls file and how to import csv file to Excel.

Open csv file in Excel

Convert csv file to xls file

Import csv file to Excel


arrow blue right bubble Open csv file in Excel

To open csv file in Excel, just do as this:

1. Enable Excel, and click File/Office Button > Open.

click File > Open

In Excel 2013, you need to click File > Open > Computer > Browse. See screenshot:
click File > Open > Computer > Browse

2. Then an Open dialog popped out, and open the folder your csv file is in, and then select Text Files from the drop down list beside Filename text box, then you can select your csv file.
elect Text Files in the Open dialog

3. Click Open button. Now the csv file is opened in Excel.

Convert or Export a Range to Separate XLS, Word, PDF, and More

Typically, Excel doesn't offer a quick option to export or save a selected range directly as a CSV, Excel, or other file types. To achieve this, you would need to either use a VBA macro or manually copy the range to a new workbook before saving. Kutools for Excel simplifies this process with its Export Range to File utility, allowing you to quickly and easily handle these operations in just a few clicks.

Export Range to File interface

Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now


arrow blue right bubbleConvert csv file to xls file

To convert csv file to xls file is easy.

1. Open the csv file, then click File or Office Button > Save As. See screenshot:
click File > Save As

In Excel 2013, click File > Save As > Computer > Browse.

2. Then in the Save As dialog, select the folder you want to locate the new file, and select Excel Workbook from the Save As type drop down list. See screenshot:select Excel Workbook from Save As dialog box

3. Click Save. Then the csv file has been converted to an xls file.


arrow blue right bubbleImport csv file to Excel

If you want to import csv file to Excel workbook, you can do as this:

1. Enable the Worksheet you want to import csv file, and click Data > From Text. See screenshot:
click Data > From Text

2. In the Import Text File dialog, open the folder your csv file is in, and select Text Files from the drop down list beside the File name text box, and then select your csv file.
select Text Files in the Import Text File dialog

3. Click Import. Then a Text Import Wizard dialog is popping, and check the option you need in the Choose the file type best describes your data section. Here I check Delimited because my data is delimited by commas. See screenshot:
check Delimited option in the dialog box

4. Then click Next to go to next step, then check the delimiters you need to separate the data by in the Delimiters section.
 check the delimiters to separate the data by in the Delimiters section

5. Click Next to go to the step 3 of the Text Import Wizard, and select a column from the Data preview section, and then check the format you need to apply in this column in Column data format section. Here I want to format first column of my data as date. See screenshot:
check the format

6. Click Finish. Then an Import Data dialog popped out for you to select a location to import the data. See screenshot:
select a location to import the data

7. Click OK. Now the csv file has been imported into Excel.
the csv file has been imported into Excel

Tip:

When the original csv file’s data has been changed, you can click Data > Refresh All to select this csv file again to refresh the csv data in Excel.


Related articles:


Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!