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.

nameaddressemailage
JaneLondonjane@gmail.com42
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 a valid array of JSON documents. For example:

[
    {"name": "Jane", "address": "London", "email": "janoe@gmail.com", "age": 42},
    {"name": "Joe", "address": "New york", "email": "joe@gmail.com", "age": 28},
]

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

Video example

In our demo database, we have a Projects collection. The video shows how to quickly create a new Contact Collection by uploading an Excel document. From the database home page, the steps are:

  • Click the "Import" button
  • Drag'n drop an Excel file
  • Choose "Create collection" and decide collection name, which columns you want and the names of the columns
  • Click "Validate and finish" button
  • The import now runs in the background

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.