Monday, September 16, 2013

How to Convert CSV Files to Excel 2007


1. Open Excel 2007.
2. Click the circular Microsoft Office button in the upper left corner. Select Open.
3. Click the 'All files (*.*)' drop-down box and select Text Files.
4. Locate your CSV file and click 'Open.'
5. Click the Delimited radio button if the CSV file's data is separated by commas, semicolons or similar characters. Click the 'Fixed width' radio button if the CSV data is arranged in columns. Click 'Next.'
6. Check the check box indicating the delimiter that separates the values, such as commas, semicolons or tabs. Click 'Next.'
7. Click a column to select it. Click the General, Text or Date radio buttons to select a text type for the column. Repeat for the remaining columns and click 'Finish.'
8. Click the circular Microsoft Office button and select 'Save as.'
9. Click the 'Save as type' drop-down box and select 'Excel workbook (*.xlsx).' Type in a file name and click 'Save.'  

Blogger news