To design data structure for your tables you have to use Create simple app wizard, an app that is a part of n-aos Builder. Here's a quick overview on how to do it:
- Select spreadsheet file with data containing full or partial structure
- Select sheet from which to import data
- Mark row containing columns that will be represented in table
- Optionally select row containing data to assign data types for above selected columns
- Confirm or modify suggested structure
If you need more help check out our step by step guide on how to import an Excel spreadsheet.
Create data structure and mass import data from several popular data sources:
| Format | Extension | Description |
Excel Workbook | .xlsx | The default Office Excel 2007 XML-based file format. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). |
Excel Workbook (code) | .xlsm | The Office Excel 2007 XML-based and macro-enabled file format. Stores VBA macro code or Excel 4.0 macro sheets (.xlm). |
| Excel Binary Workbook | .xlsb | The Office Excel 2007 Binary file format (BIFF12). |
Excel 97- Excel 2003 Workbook | .xls | The Excel 97 - Excel 2003 Binary file format (BIFF8). |
| XML Data | .xml | XML Data format. |
| Open document spreadsheet | .ods | Open document spreadsheet format. ODS is an OASIS-formatted file used in most open source oriented environments. |
You can try to import data or build an app with n-aos Builder right now.