|
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 Qualifier 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.
|
