Note: The other languages of the website are Google-translated. Back to English
English English

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

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.


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

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.

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

quickly convert or export a range of a sheet to separate XLS/Word/PDF or other format files in once time

Normally, Excel does not support you with an option to quickly export or save a range as a CSV or Excel file. If you want to save a range of data as a CSV or workbook in Excel, you may need to use a VBA Macro for doing this or to copy the range to clipboard and paste it in a new workbook and then save the workbook as CSV or Workbook. Kutools for Excel augments Excel with Export Range to File utility for Excel users who want to quickly process the following operations:  Click for 30-day full featured free trial!
doc export cell range to file
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

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:

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:doc-csv-to-xls-5

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:

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.

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:

4. Then click Next to go to next step, then check the delimiters you need 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:

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

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


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.

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

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!
officetab bottom
Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thank you for this Great resource! I am going to give it a try. So far I have been using Websites like zamzar or for the conversions and they are great too. My best is It has such a great interface and does the job in No Time.
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations