Data view - the home of data

At the core Lemonado is a relational database allowing you to work across data sources with the power of a database - without having to code. It has been designed with the familiarity of a spreadsheet but with powerful features such as data relations.

By clicking on add data you can easily connect new data sources or upload data. This can also be done by asking the AI assistant Lenny. All integrations can be found here.

It is as simple as a spreadsheet, just click on the cell you like to edit, make the changes and save by pressing enter. Some data types will provide a check box or drop down for easier editing.

Click on edit columns if you want to add edit name of data type of a column

Computed columns is a powerful feature allowing you to compute columns as the name suggest but also extract data from JSON and much more. Read more

Like a spreadsheet you can sort and filter your data. We recommend you to use the table widget to make it easier to design what should be shown and edited. Think of the data view as your raw data view.

Lemonado will automatically relate data for you - that means no more vlookups and messy spreadsheets. You can also edit relations manually. Read more

There are different data types in Lemonado to make it easier to create. When you import data types they will be automatically classified. To change head over to Edit Columns.