How to Convert CSV File to Excel

Written by nina nixon Google
  • Share
  • Tweet
  • Share
  • Email

CSV file type (known as comma-separated values or comma delimited text files) is one reliable, conversion-friendly file format. Converting a CSV file to an Excel spreadsheet can expand the ways in which you manage your data. For example, you can create pivot tables and charts, or you can import records such as name-and-address contact lists in other software programs for further analysis. This is very useful, since these types of records are typically a continuous work in progress that require updating at various times.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Excel 2003 version or later

Show MoreHide

Instructions

    Save CSV File as Excel Spreadsheet

  1. 1

    Open Excel and click "File" and then click "Open."

  2. 2

    Click the down arrow next to "Look in" to locate the folder containing the CSV file.

  3. 3

    Use the down arrow next to "Files of type" and select "Text Files (.prn; .txt; *.csv)."

  4. 4

    Double-click the CSV file to open it.

  5. 5

    Click "File" and then select "Save As."

  6. 6

    Use the down arrow next to "Save as type" and select your desired Excel version format; click "Save."

    Import CSV File to Excel

  1. 1

    Open Excel and click "Data" and then point to "Import External Data."

  2. 2

    Click "Import Data."

  3. 3

    Use the down arrow next to "Files of type" and select "Text Files (.txt; .prn; .csv; .tab; *.asc)."

  4. 4

    Click the down arrow next to "Look in" to locate the folder containing the CSV file and then click "Open."

  5. 5

    Click "Next" three times, using the wizard default settings. Next, click "Finish" and then click "OK."

Tips and warnings

  • Since you are converting a CSV file into another format, test the new Excel file before deleting the original CSV.
  • As indicated in the section "Save CSV File as Excel Spreadsheet," in Step 3, it is important to select "Text Files (*.prn; *.txt; *.csv)," in "files of type" instead of "All Files (*.*)" to narrow down your selection and find your CSV file fast.
  • These steps apply to Excel 2003 using Windows XP.

Don't Miss

Resources

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.