How to Convert CSV File to Excel

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.

Shot in the UK, businessman wokring at computer
credit: Polka Dot RF/Polka Dot/Getty Images

Save CSV File as Excel Spreadsheet

Step

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

Step

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

Step

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

Step

Double-click the CSV file to open it.

Step

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

Step

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

Import CSV File to Excel

Step

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

Step

Click "Import Data."

Step

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

Step

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

Step

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