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.

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

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

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

Double-click the CSV file to open it.

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

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

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

Click "Import Data."

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

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

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

Most recent