Import from Excel

• Create a database from Excel file
• Create a table from Excel file
• Excel file recommendations
• Edit table data from Excel file
• Add data into a table from an Excel file
• Import data from CSV file

Excel file recommendations

Before you upload data from your Excel file please follow this recommendations:

• The system will load only the first worksheet in the Excel file.
• The column names must be in the first row.
• Make sure you don't have two columns with the same name.
• Don't use special formatting cells.
• Make sure you don't have graphics and images.
• Make sure you don't have hidden rows or columns.
• In edit table from Excel file, make sure you don't have, in the file, the columns not listed online.
• The values of File and Formula columns will not be imported. For Formula columns, the value will be calculated automatically if the values of the columns involved in the formula changes.