Thursday, January 17, 2013

How to Convert CSV File to Excel


Save CSV File as Excel Spreadsheet
1. Open Excel and click 'File' and then click 'Open.'
2. Click the down arrow next to 'Look in' to locate the folder containing the CSV file.
3. Use the down arrow next to 'Files of type' and select 'Text Files (*.prn; *.txt; *.csv).'
4. Double-click the CSV file to open it.
5. Click 'File' and then select 'Save As.'
6. Use the down arrow next to 'Save as type' and select your desired Excel version format; click 'Save.'
Import CSV File to Excel
7. Open Excel and click 'Data' and then point to 'Import External Data.'
8. Click 'Import Data.'
9. Use the down arrow next to 'Files of type' and select 'Text Files (*.txt; *.prn; *.csv; *.tab; *.asc).'
10. Click the down arrow next to 'Look in' to locate the folder containing the CSV file and then click 'Open.'
11. Click 'Next' three times, using the wizard default settings. Next, click 'Finish' and then click 'OK.'

Blogger news