| 1.) |
Open a blank spreadsheet in Microsoft Excel. |
| 2.) |
Click on File in the main menu at top left then select Open and browse for the file you wish to import.
(Hint: in the "Files of Type:" box at the bottom of the dialogue box, select the file type you are importing, i.e. .csv files or .txt files.)
|
| 3.) |
When you have located the file you need, click to select it, then click Open. |
| 4.) |
The following Text Import Wizard will appear. |
| |
 |
| 5.) |
Under "Choose the file type that best describes your data", select Delimited and click Next.
|
| 6.) |
In step 2, under Delimiters, remove the check mark in the box that says Tab and select Comma.
|
| 7.) |
Make sure the Text Qualifer is a quotation mark(") and click Next.
|
| 8.) |
In step 3, under Column Data Format select Text and click Finish.
|
| 9.) |
The data will appear in the spreadsheet.
|
| 10.) |
Select File and then Save As.
|
| 11.) |
Choose where you want to save the file in the "Save In" box.
|
| 12.) |
Give your file a name in the box named "File Name".
|
| 13.) |
The Save as type: box should read Microsoft Excel Workbook. If it does not, click on the drop down arrow and change the file type to: Microsoft Excel Workbook.
|
| 13.) |
Click Save.
|
