In the upper-right corner of the page, select Create New, and then, depending on the type of file that you want to import, select Excel, XML, or Text.
A new page appears, displaying the Select File section. Depending on the type of file that you are importing, to continue the operation, proceed to the appropriate drop-down section below.
Select Choose File, and then select the file that you want to import.
In the Choose File box, the file name of the selected file appears.
Select Next.
The Choose Worksheet section appears.
In the Worksheet Name box, select the worksheet that you want to import.
If the first row in the worksheet should be used as column names in the dataset, select the First row contains header definition check box.
If you want to import values only from certain cells in the worksheet, select the Import specific range values check box, and then, in the Start and End boxes, enter the values that define the range that you want (e.g., A2 to E20).
Note: At any time, you can select See Preview to view a preview of the dataset based on your current selections.
Select Next.
The Modify Columns section appears, displaying a grid.
As needed, in the boxes in the Column Name column, modify the column names.
Note: You can only modify these column names if, in step 6, you did not select the First row contains header definition check box.
As needed, in the boxes in the Data Type column, select the type of data that will be allowed in the column.
For any columns in which you want each cell in that column to contain a unique value, in the row representing that column, select the check box in the Unique Value column.
Select Next.
The Preview section appears, displaying a preview of the dataset.
Select Choose File, and then select the file that you want to import.
In the Choose File box, the file name of the selected file appears.
Select Next.
The Modify Columns section appears, displaying a grid.
As needed, in the boxes in the Data Type column, select the type of data that will be allowed in the column.
For any columns in which you want each cell in that column to contain a unique value, in the row representing that column, select the check box in the Unique Value column.
Select Next.
The Preview section appears, displaying a preview of the dataset.
Select Choose File, and then select the file that you want to import.
In the Choose File box, the file name of the selected file appears.
Select Next.
The Column Delimiter section appears.
In the Column Delimiter box, select the delimiter that separates values withing the selected file.
If the first row in the worksheet should be used as column names in the dataset, select the First row contains header definition check box.
Note: At any time, you can select See Preview to view a preview of the dataset based on your current selections.
Select Next.
The Modify Columns section appears, displaying a grid.
As needed, in the boxes in the Column Name column, modify the column names.
Note: You can only modify these column names if, in step 6, you did not select the First row contains header definition check box.
As needed, in the boxes in the Data Type column, select the type of data that will be allowed in the column.
For any columns in which you want each cell in that column to contain a unique value, in the row representing that column, select the check box in the Unique Value column.
Select Next.
The Preview section appears, displaying a preview of the dataset.
