> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview.md).
# Add Columns - Overview
As your business requirements evolve, you may need to capture new types of information in your tables. Powertable allows you to add columns to an existing table at any time, making it easier to adjust your table structure as your needs change without having to rebuild the table.
Using this feature, you can:
* Add and manage database columns directly from the powertable sheet, without having to write any queries.
* Add columns only to the powertable sheet to manage additional data without affecting the source database.
* Choose from various column types such as data, formula, lookup, reference, attachment, roll up, button, and others to capture and manage information in the manner that best suits your needs.
### Adding new column
You can add a new column to a table in the following scenarios:
#### **During table creation**
Use **Add column** during the initial table configuration to create and configure additional columns alongside the imported columns.
#### **After a table has been created or connected**
After a table has been created or connected, you can add new columns at any time using **Insert Column**.
Alternatively, select **Setup** > **Columns** and use the *Add Column* options available during column configuration.
The following sections describe how to add visual columns, database columns, and formula columns to an existing table.
* [**Visual columns**](/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-visual-column.md) are inserted only within the PowerTable sheet. These are not added to the source database.\
Examples include **multi-select relationship** columns, **reference** columns, **relation** columns, **roll up**, **button**, and **attachment columns.**
* [**Database columns**](/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-database-column.md) are added to the underlying database and become part of the table schema.
* [**Formula columns**](/documentation/readme/powertable-sheets/how-tos/adding-columns-overview/add-formula-column.md) can be configured to be either visual or database columns. Use formula columns to calculate values based on formulas and display the results in the table.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/adding-columns-overview.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.