> For the complete documentation index, see [llms.txt](https://docs.powertable.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powertable.com/explore-powertable/create-table-app/enter-data-manually.md). # Enter Data Manually In previous sections, we demonstrated how to [import a CSV file into PowerTable](/explore-powertable/powertable-product-tour/build-your-first-app.md) and [connect to a database](/explore-powertable/create-table-app/connect-to-database.md) directly from PowerTable. This section explains how to manually enter data into PowerTable to build an app. **The source and destination will be the same**; we will enter data to create a table and then writeback the subsequent changes to the same database. Let us look at the steps. 1. Go to your Microsoft Fabric workspace folder. Click on **New item** to create a new item.

Create a new item

2. Select **PowerTable** from the list of items. You may want to add it to your favorites by clicking on the star icon.

Select 'PowerTable'

3. Enter a name for your PowerTable app and select the workspace. Click on **Create.**

Create PowerTable item

4. Click on **Create a New App** to create your app. You may also select 'Explore PowerTable' to [experience a sample PowerTable app](/explore-powertable/powertable-product-tour/explore-a-sample-app.md).

Create a New App

5. **Creating a new database connection:** The next step is to create a new database connection to your preferred data source. Your app synchronizes its data with this data store. Follow the steps below to create a new connection: * Click on **New Connection.** * Choose your preferred data platform. We'll connect to the Fabric SQL database. * Click **Next.**

Creating a new connection

{% hint style="info" %} If you already have shared database connections or a private connection to the required data store, skip step 5. Instead, click on the 'Existing Connection' tab, select the one you want to use, and then click **Next.** {% endhint %}

Choosing an existing connection

6. **Setup Connection:** Enter the connection type and a unique connection name. Select the workspace and the database from the list of options and click **Next.** Your new private connection is now created.

Setup Connection

7. **Choose your table where the data will be stored:** Here, you have two options: 1. Select **Existing Table** to connect to an existing table in the database (or) 2. Select **New Table** to create a new table in the database. We'll select **New Table** to create a new table and type in the data.

Create new table

8. Select the schema and enter a name for your table. Choose the option **Enter Data Manually** to manually enter the data. Click **Next.**

Enter table name

9. **Add Column Details:** Start creating your table by adding the column name, primary key, and other relevant details like length, precision, scale, etc., wherever applicable.

Add Column details

10. **Add Column:** Click on '+ Add Column' at the top to add a new field/column.

Add Column

11. You can use the bin icon to delete a column.

Deleting a column

12. Click **Finish** after entering all the column details.

click 'Finish'

The table has been successfully created using PowerTable, with the configured columns.

Table created

You can now insert rows into this table using the **Insert Row** option.

Inserting rows into the table

With this table app, you can start working on your data, adjusting it as necessary and setting up features like approvals, workflows, and access control. These are covered in the following sections. --- # 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.powertable.com/explore-powertable/create-table-app/enter-data-manually.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.