In Tables, every column describes a field that all rows in the table can have. For example, every row in a table of “Team Members” represents a person who is part of your team, and every column in your table describes a piece of information that the row can have. All fields are optional, so you can have an empty or blank value in a column.
You can specify the type of data via the column settings panel, which you can find by:
- clicking the “Add column” button in the furthest right column header,
- or by double clicking on an existing column header,
- or right clicking on an existing column header and selecting “Edit column” from the menu.
When you open the column settings panel, you can:
- Edit the title of the column, column titles must be unique within the table; you can’t have two columns with the same name.
- Set or change the data type of the column.
- Configure any special settings for the column type, including selectable options (for dropdown, tags, checklist), default values, and data formats and data validation.
When using copy & paste, you can simply copy and paste directly from Google Sheets or Google Docs into a table in the Grid layout. Any tab-separated content can be pasted across multiple columns within a table. One caveat is that pasting data over Lookup columns is not supported, and pasting values that do not match the options in a Tags or Dropdown column will result in the values being dropped.