Intro to Tables

In this section, you’ll learn how to input data into Baserow either by starting from scratch and adding data as you go or by importing data from another source.

Everyone, including Admins and Members, can modify 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

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.

Add a new blank table

There are several simple ways to make a new table with Baserow. Baserow allows you to create a new empty table in seconds and add columns and/or rows as needed. To manually enter your task information into the table, you need to have at least one table within the base to select the database.

Start with a new table

To select a database, use the sidebar to create one.

  1. Within your database in the sidebar, click ‘+ Create table’
  2. Input a name for the new table. When you create a new table, you should give it a distinctive name that’s not the same as any other table name in the current database.
  3. Select ‘Start with a new table’
  4. Click ‘Add table’

This will create a new table for you with a few default fields and rows.

enter image description here

Paste table data

Baserow has a number of supported fields, each has its own set of formatting rules. Always make sure the data you are importing into Baserow has been formatted properly in order to get the right content into the right fields.

  1. Within your Database in the sidebar, click ‘+ Create table’
  2. Input a name for the new table
  3. Select ‘Paste table data’. You can copy the cells from a spreadsheet and paste them.
  4. If the first row copied is a header, the checkbox is ticked by default.
  5. Click ‘Add table’

enter image description here

Adding a new table via import

Tip: Want to take your data outside of Baserow? Learn how to export out of a Table!

Baserow allows you to import a file as a new table into an already-existing database.

You can easily import your data from almost anywhere into Baserow from a data file. We’ll get you up and running in no time! The importing feature makes it easy to transfer your data in bulk from another platform.

The following file types are supported when you import a table into your database:

  • Comma-separated values (CSV)
  • Extensible Markup Language (XML)
  • JavaScript Object Notation (JSON)

Once the data file is ready, you can import it into your database.

Note that you are limited to importing up to a maximum of 5000 rows.

Import a CSV file into an existing database

You can import an existing CSV by uploading the .CSV file with tabular data. Most spreadsheet applications will allow you to export your spreadsheet as a .CSV file.

  1. Within your database in the sidebar, click ‘+ Create table’

  2. Input a name for the new table

  3. Select ‘Import CSV file’.

  4. Click ‘Choose CSV file’ to browse and upload a file from your computer

    enter image description here

  5. Confirm the Column separator and Encoding format from the drop-down menus.

  6. Check ‘yes’ to confirm the first row is a header if you want the top row of your spreadsheet to be included in your import, or unclick to go without a header.

    While we recommend you have header rows in your tables, it is not required. If you do include a header row, each column needs a different header. A header row gives your readers a visual reference for each column’s content.

  7. In the preview box, double-check that your data looks good.

  8. Click ‘Add table’

    enter image description here

Import an XML file into a database

  1. Within your Database in the sidebar, click ‘+ Create table’
  2. Input a name for the new table
  3. Select ‘Import an XML file’.
  4. Click ‘Choose XML file’ to browse and upload a file from your computer
  5. In the preview box, double-check that your data looks good.
  6. Click ‘Add table’

enter image description here

Import a JSON file into a database

You can import an existing JSON file by uploading the .json file with tabular data, i.e.:

[
  {
    "to": "Tove",
    "from": "Jani",
    "heading": "Reminder",
    "body": "Don't forget me this weekend!"
  },
  {
    "to": "Bram",
    "from": "Nigel",
    "heading": "Reminder",
    "body": "Don't forget about the export feature this week"
  }
]
  1. Within your Database in the sidebar, click ‘+ Create table’
  2. Input a name for the new table
  3. Select ‘Import a JSON file’.
  4. Click ‘Choose JSON file’ to browse and upload a file from your computer
  5. Confirm the Encoding format from the drop-down menus.
  6. In the preview box, double-check that your data looks good.
  7. Click ‘Add table’ button to import the file to Baserow.

enter image description here

Each cell has a distinct type that might or might not correspond to a corresponding field type in Baserow. When you import a file, the data will be converted to their equivalent Baserow fields.

Move and Reorder tables

You can rearrange the order of the tables in your sidebar by clicking and dragging the table to move.

enter image description here

Webhooks

Webhooks allow you to receive real-time notifications about changes in your database, like new rows, updates to existing rows, or rows moving in or out of views.

To get more details about webhooks and how they work, read this section.

Multiple cell paste

You can copy and paste multiple cells. Hit the Cmd/Ctrl + V command and voila, data is inserted in seconds.

enter image description here

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!