Data view - the home of data
The data view in Lemonado is your data hub. View, sort, filter, edit, and enhance data with computed columns.
![Data view](http://images.ctfassets.net/wl4obrmf3nbz/3FrTy3CQeoOhyYZTD2Z10j/43039f1197f637d563fc5ef31f17d3d1/SCR-20240318-plvd.png)
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.
Add data
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.
Edit data
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.
Edit columns
Click on edit columns if you want to add edit name of data type of a column
![Edit columns](http://images.ctfassets.net/wl4obrmf3nbz/qrxiz89bp87wRDpRRDP0u/f0eb813bc674ff406fd803934c3cd972/SCR-20240318-pqyj.png)
Computed columns
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
Sorting and filtering
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.
![Sort data view](http://images.ctfassets.net/wl4obrmf3nbz/2jWwxTh5R4aMTHB9e0XQvs/6ab54180885f03aab928268dc4433e9e/SCR-20240318-proq.png)
Data relations
Lemonado will automatically relate data for you - that means no more vlookups and messy spreadsheets. You can also edit relations manually. Read more
Data types
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.
![Data types](http://images.ctfassets.net/wl4obrmf3nbz/5pDeeArRVVBlFKaSQkWFbv/d65b5b400b0fc6e2d4e714d5c44923a7/Data_types.png)