Intro to Tables

A Baserow table is similar to a table in an Excel worksheet. Baserow tables are the most powerful place to manage your data. You can create different tables for different data. Tables display many types of information at once.

They function like spreadsheets in that you can sort, filter, aggregate your data and modify many other table features. In contrast to standard spreadsheets, Baserow lets you see tables in several ways as a grid of rows and columns, forms, kanban boards, or a gallery of cards.

enter image description here

Working with Tables

In Baserow, databases are like file folders. They let you organize multiple tables into one central place. Tables make it easy to analyze and interpret your data. You can store multiple tables in a single database to outline a project or organize information.

You can group pieces of data that have some sort of commonality—for example, if you have the sales of different products in different regions. Tables allow you to customize a collection of data. A table contains data organized in columns (fields) and rows which can be customised by colours and filters.

enter image description here

Because each table resembles a spreadsheet, you have the option of editing or creating a new table within a database, each with its own set of fields. You’ll see a unique viewpoint of your work whether you’re looking at a grid, gallery, form, or kanban view.

Tip: Fully customize your table data with sorting, filtering, and your favourite view!

Use cases

Here are some examples of how tables can be used:

  1. Team Check-ins: Manage the team’s check-ins efficiently and effectively to encourage your team to share their thoughts and suggestions about the projects and tasks they’ve been given.
  2. Commercial Property Management: Create, update, and track every aspect of your property management needs, from tenant’s service request to an expiring lease, or contacting vendors.
  3. Product Roadmap: Communicate priorities and strategic plans to stakeholders and internal team members.
  4. Wedding Client Planner: Dashboard for all of your client weddings highlighting all the vendors the wedding will be using, the budget, the running cost, and all other important details that are critical to the wedding.
  5. Nonprofit Grant Tracker: Keep track of each organization offering grants, the grants the nonprofit is eligible for, the deadlines, the team members, and the application statuses.

You can import tables in bulk by adding a database from the template library. In addition, data can be imported from spreadsheets, JSON and XML files.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!