Import of Spreadsheet data is a great way to start a database. From your imported spreadsheet it's easy to add relations and new fields etc.
With import, you can create new Collections (tables) from Excel sheets. The only requirement is that you have a first "header"-row with the column/field-names you want to use.
In the example table above, the second row with data is used to "guess" the data type for columns in all rows.
In our database, we have a Products collection that need to have a Contact. The video below shows how to create a new Contact Collection by uploading an Excel document.
Click on any collection in the dashboard. A list of records is shown. Clicking the "Download"-button in the toolbar, will download a CSV-file or a JSON-file with all the data in the collection.
If you filter the list, only the filtered records will be exported.
The export to CSV or JSON feature ensures that you can use your data in any other application.