To import data from Excel into Slope, navigate to the Data Tables management screen and click on the Import From Excel button next to the Input Table that you want to import a table.
This will bring up a dialog where you can give a description to the new table and select an Excel file to import from. You can also import a new Excel file by clicking on the 'Add new file' link located just below the file section drop-down. Once a file has been selected, a new input box will be displayed showing all the Worksheet names within the selected Excel Workbook. Select the appropriate Worksheet name and click save to import the data.
Requirements for Data Import
Data on the worksheet must conform to the following requirements.
- Row 1 of the Worksheet must contain a header row with column names.
- There must be a unique column that exists for each column defined the Input Table definition. Slope will compare the names of the columns against the values in row 1 to determine which column matches the data it expects to import. This comparison is not case-sensitive.
- An imported worksheet may contain extra columns not required for the Input Table. Any values in these columns will be ignored during import.
- Columns do not need to appear in the same order as the input table definition. As long as there is a unique column header that matches the Input Table column name, it will identify the data properly.
- Blank columns are allowed in the worksheet, including in the header row. These will be ignored during import.
- Any blank rows on the imported worksheet will be ignored. These will not appear as blank rows in the imported Data Table.
- Formulas are allowed in imported worksheets. The resulting Value of any cell with a formula will be imported.