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.
Zoom Saved
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.
Zoom Saved
7
Once you have chosen where the data should go, click ok.
Zoom Saved
8
The data should now show in a table as seen here.
Zoom Saved
9
Click "Sheet1"
Zoom Saved
Option 2- Transform Data
10
Like in Option 1, you will start in the data tab. Click "Data"
Zoom Saved
11
Click "From Text/CSV"
Zoom Saved
12
Select the name of the text document you would like to import.
Zoom Saved
13
Click "Import"
Zoom Saved
14
Click "Transform Data"
Zoom Saved
15
This opens a different window with far more options that allow you to edit columns, rows, formatting, and properties of the data.
Zoom Saved
16
You can also filter data within each column before it gets imported into the Excel sheet.
Zoom Saved
17
You can change the data type for each column.
Zoom Saved
18
Click "Data Type: Text"
Zoom Saved
Was this Scribe helpful? Save this document for future reference.
Save for Later
Have something to say?Create an account to leave messages for the author to see!Create an account
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe