From MS Excel
To import an Excel file, click the "Excel" button from the Files category as shown below
Next, locate the file. You can then select if the first row contains column names or not, and the specific Excel sheet.
You will will then be provided with a preview of the data, you can then click "Import" to complete the importing.
- First row contains column names - Selecting this will ensure you collect the column names on the first row
- Analyze data type - This will analyze the first 200 rows to determine the exact data type of each column (eg. Text, Integer, Date/Time, etc). If not selected, all columns will be TEXT only. Please use this option with caution, as in cases on larger lists if the datatypes are different within the same column, it could cause an error, in which case ensure this option is unticked.