Get started with your own database.

Import and Export of Excel, CSV, JSON

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.

  • Formats supported for import are: XLSX, CSV and JSON.
  • Formats supported for export are: CSV and JSON.

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.

E.g. name=text, address=text, email=email and age=number.

Video example

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.

Exporting Data

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.