Option 1- Load To
1
Click "Data"
2
Click "From Text/CSV"
3
Select the text file you would like to import.
4
Click Import.
5
If the columns are correct, you can click "Load". If they are not, or you would like to move where the data will be imported to, you can select the arrow to the right of "Load" to see other options.
6
If you click "Load To", it will allow you to move where the data will go. This returns you to the sheet you were in to select a new location.
7
Once you have chosen where the data should go, click ok.
8
The data should now show in a table as seen here.
9
Click "Sheet1"
Option 2- Transform Data
10
Like in Option 1, you will start in the data tab. Click "Data"
11
Click "From Text/CSV"
12
Select the name of the text document you would like to import.
13
Click "Import"
14
Click "Transform Data"
15
This opens a different window with far more options that allow you to edit columns, rows, formatting, and properties of the data.
16
You can also filter data within each column before it gets imported into the Excel sheet.
17
You can change the data type for each column.
18
Click "Data Type: Text"
