> ## Documentation Index
> Fetch the complete documentation index at: https://docs.caplena.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Add Additional Columns for Analysis After Upload

> Missed a TTA column during import? Here's how to bring it in later—no reupload of the full dataset needed.

Did you forget to include a column for analysis during your data upload? No worries — there are two ways to bring that column into your analysis using **Smart Columns** or **Add & Replace**.

## Option 1: Using Add & Replace

If Smart Columns are not available or preferred, you can re-import the column using the **Replace** flow.

> [!TIP]
>
> The original dataset must contain a **unique identifier** column (for example, UUID or user ID).

[Loom video player](https://www.loom.com/embed/2bee010ea36a480d84d442e4fa297b11)

**1. Prepare your file**

Include the **unique identifier** column (e.g., UUID, respondent ID) and the **column(s)** you forgot to include originally.

**2. Replace Data**

In your project, go to **Data → Replace Data** and upload your new file.

**3. Match and add columns**

Select the **identifier column** to match existing rows, then select the **new column(s)** to be added.

**4. Configure and complete**

**Check the TTA box** if the column should be treated as open text, select the option to **add as a new column**, and complete the upload.

## Option 2: Using a Smart Column (if included in your plan)

If you have **Smart Columns** enabled, you can turn an existing column into a **Text to Analyze (TTA)** column.

**1. Open Smart Columns**

Go to your project and open the **Smart Columns** panel, then click **Create Smart Column**.

**2. Select column type**

Select the column type **"Text to Analyze"**.

![Screenshot 2026 05 23 At 14 58 34](https://mintcdn.com/caplena-32172960/j8tdvVd7cDdtTO_3/images/Screenshot-2026-05-23-at-14.58.34.png?fit=max\&auto=format\&n=j8tdvVd7cDdtTO_3\&q=85\&s=e18cf93a7e6d51786b683a1b5bc2e669)

**3. Choose Formula and Variable**

Choose **Formula**, click on **Variable**, and select the column you'd like to turn into a TTA field.

![Screenshot 2026 05 23 At 14 59 29](https://mintcdn.com/caplena-32172960/j8tdvVd7cDdtTO_3/images/Screenshot-2026-05-23-at-14.59.29.png?fit=max\&auto=format\&n=j8tdvVd7cDdtTO_3\&q=85\&s=a5439402307839bc1438a2e439c9cbaf)

**4. Create & Fill**

Click **Create & Fill**.

![Screenshot 2026 05 23 At 15 00 12](https://mintcdn.com/caplena-32172960/j8tdvVd7cDdtTO_3/images/Screenshot-2026-05-23-at-15.00.12.png?fit=max\&auto=format\&n=j8tdvVd7cDdtTO_3\&q=85\&s=82d62b5aca713a677ac1bac62a3223c7)

> [!TIP]
>
> Your selected column will now behave like any other open-ended field and can be included in your analysis.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.