Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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


goodExport Range to File

Kutools for Excel's Export Range to File function can export or save a range to separate file as
workbook, pdf, text, csv or text.
Click Enterprise > Import/Export > Export Range to File.
doc export cell range to file


arrow blue right bubble Open csv file in Excel


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

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

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

doc-csv-to-xls-1

In Excel 2013, you need to click File > Open > Computer > Browse. See screenshot:
doc-csv-to-xls-2

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.doc-csv-to-xls-3

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


arrow blue right bubbleConvert csv file to xls file

To convert csv file to xls file is easy.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

1. Open the csv file, then click File or Office Button > Save As. See screenshot:
doc-csv-to-xls-4

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:

formula Never need to worry about long long formulas in Excel anymore! Kutools for Excel's Auto Text can add all formulas to a group
as auto text, and liberate your brain! Click here to know Auto Text     Click here to get free trial

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

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

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:

doc-csv-to-xls-8

Split Workbook

Kutools for Excel's Split Workbok help you split all sheets from a workbook and save them as separate workbooks, texts, csv files or pdf files.
doc split workbook

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

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

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

7. Click OK. Now the csv file has been imported into Excel.
doc-csv-to-xls-12

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.

pay attention1If you are interested in Kutools for Excel, download the 60-days free trial.


doc KTE


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Zoya · 2 years ago
    Thank you for this Great resource! I am going to give it a try.

    So far I have been using Websites like zamzar or Convert.world for the conversions and they are great too. My best is Convert.world. It has such a great interface and does the job in No Time.