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.

Spreadsheet data

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.

JoeNew yorkjoe@gmail.com28

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.

JSON data

You can also create new Collections from JSON. The data must be an valid array of JSON documents. For example:

    {"name": "Jane", "address": "London", "email": "", "age": 42},
    {"name": "Joe", "address": "New york", "email": "", "age": 28},

The first JSON document is used to "guess" the data type for the rest.

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.