> ## 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.

# Data Tab Overview

> Everything you can do in Caplena's Data Tab, from editing to exporting

The **Data Tab** is where you view, clean, and manage your dataset in Caplena. Whether you are preparing data for analysis, fixing errors, or customizing the table view, you stay in control without re-uploading files.

## Accessing the Data Tab

To get started, click on **Data** in the sidebar. You'll see an interactive table showing the data you uploaded.

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/dj8GHLkhkVrSagxW/images/Screenshot-2026-05-24-at-10.47.57.png?fit=max&auto=format&n=dj8GHLkhkVrSagxW&q=85&s=7652433a5b8f0c8f63246939fdc05b42" alt="Screenshot 2026 05 24 At 10 47 57" width="3240" height="702" data-path="images/Screenshot-2026-05-24-at-10.47.57.png" />
</Frame>

The Data Tab includes:

* **Toolbar** – Filter, edit, and customize your dataset
* **Table View** – See rows (responses) and columns (data fields)
* **Checkboxes** – Select rows for bulk actions

## Viewing column details

To inspect a column's full data profile, click on any column header. A Column Details panel will open with two sections.

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/6Kgl-aXi2cWnlTE4/images/CleanShot-2026-06-08-at-17.42.08.gif?s=da3a9ee3c688f06050e1c1d5b2b37dba" alt="Clean Shot 2026 06 08 At 17 42 08" width="800" height="419" data-path="images/CleanShot-2026-06-08-at-17.42.08.gif" />
</Frame>

**Settings**

* **Name** — edit the column's display name directly
* **Favorite** — pin this column to the top of dropdowns and filter menus for faster access
* **Default score** — set this column as the primary scoring reference across your project
* **Sensitive** — mark the column as containing sensitive data (available on auxiliary columns). Only users with the **View sensitive columns** permission can see the toggle, see sensitive columns in project data, and export them. See [object-level permissions](/settings-administration/permissions-deep-dive/object-level-permissions) for details.

**Column content** *(read-only)*

* **Column Ref** — the internal ID
* **Data Type** — e.g. Numerical, Text
* **Populated rows** — how many rows have a value in this column
* **Unique Values Count** — number of distinct values
* **Last Value Added** — timestamp of the most recent entry
* **Data Source** — where the data originated
* **# of Empty Rows** — rows with no value in this column
* **Sample values** — a quick preview of actual entries

<Tip>
  If a column shows a high number of empty rows, check whether the data was imported correctly or whether a Smart Column needs to be re-run.
</Tip>

## Favoriting and hiding columns

These features help you focus on relevant fields without permanently changing your dataset.

### Favorite columns

Mark a column as a favorite to pin it to the top of dropdown menus (e.g. when selecting filters), making it quicker to find and use. This is especially helpful when working with many columns.

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/f4FlmiD764B78gVE/images/data-&-management/data-tab-sources/data-tab-favorite-columns.gif?s=87fa141ddfcdc71382f925024a403d6c" alt="Favorite columns in dropdowns" className="mx-auto" style={{ width:"80%" }} width="800" height="589" data-path="images/data-&-management/data-tab-sources/data-tab-favorite-columns.gif" />
</Frame>

When you mark a column as a favorite, it will appear at the top of dropdown menus (e.g., when selecting filters), making it quicker to find and use.

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/dj8GHLkhkVrSagxW/images/Screenshot-2026-05-24-at-10.50.28.png?fit=max&auto=format&n=dj8GHLkhkVrSagxW&q=85&s=1ea4d6686d92c7ec05be67db08859a1f" alt="Screenshot 2026 05 24 At 10 50 28" width="1940" height="1280" data-path="images/Screenshot-2026-05-24-at-10.50.28.png" />
</Frame>

### Hide columns

* Click **Show/Hide Columns**
* Uncheck any column you don't want visible
* The table updates immediately

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/f4FlmiD764B78gVE/images/data-&-management/data-tab-sources/data-tab-hide-columns.gif?s=f7f2b88c73accced39a58d9c953f8a2f" alt="Show or hide columns" className="mx-auto" style={{ width:"78%" }} width="800" height="661" data-path="images/data-&-management/data-tab-sources/data-tab-hide-columns.gif" />
</Frame>

## Marking columns as sensitive

Use **Sensitive** to restrict who can see a column's values. Sensitive columns are hidden from rows, coding views, and filters for any user who doesn't have the `Projects View Sensitive Columns` permission — even if they otherwise have access to the project.

Typical uses include hiding free-text fields that may contain personal data, internal identifiers, or commercially sensitive responses, while still letting analysts work with the rest of the dataset.

To mark a column as sensitive:

<Steps>
  <Step>
    Click the column header to open **Column Details**.
  </Step>

  <Step>
    Toggle **Sensitive** on.
  </Step>
</Steps>

To remove the sensitive flag, open the same **Column Details** panel and toggle **Sensitive** off. The column's values become visible again to all users with project access.

The toggle is only available on auxiliary columns (not on text-to-analyze columns) and only visible to users with the `Projects View Sensitive Columns` permission. See [Object-level permissions](/settings-administration/permissions-deep-dive/object-level-permissions) for how to grant it.

<Note>
  Marking a column sensitive controls visibility only. To irreversibly remove personal data from text values, use [Anonymization](/get-started/project-settings/anonymization) at upload time.
</Note>

## Editing text fields

You can edit responses or text rows directly from the table, which is helpful for fixing typos or clarifying entries.

<Steps>
  <Step>
    Click the field you want to change
  </Step>

  <Step>
    Make your edits
  </Step>

  <Step>
    Press **Enter**, or click outside the cell to save
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/f4FlmiD764B78gVE/images/data-&-management/data-tab-sources/data-tab-edit-cell.gif?s=81bcf10dd8e30fcf3b58c0053cb2c4dc" alt="Inline edit of a text cell" width="584" height="280" data-path="images/data-&-management/data-tab-sources/data-tab-edit-cell.gif" />
</Frame>

<Danger>
  Each verbatim edit uses 1 credit, as Caplena reprocesses the entry to update insights like sentiment and topics.
</Danger>

## Deleting rows and columns

Use this when you want to permanently remove data you no longer need.

### Delete rows

* Use the checkboxes to select rows
* Click **Delete Rows** in the toolbar
* Confirm deletion

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/f4FlmiD764B78gVE/images/data-&-management/data-tab-sources/data-tab-delete-rows.gif?s=1df82f56a7468a931a1e0e52c3870146" alt="Delete selected rows" width="800" height="175" data-path="images/data-&-management/data-tab-sources/data-tab-delete-rows.gif" />
</Frame>

### Delete columns

* Click **Delete Columns**
* Choose the column to remove
* Confirm the action

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/f4FlmiD764B78gVE/images/data-&-management/data-tab-sources/data-tab-delete-columns.gif?s=d6e335b7262418a12df4dc0a2a6d9e99" alt="Delete columns flow" width="800" height="749" data-path="images/data-&-management/data-tab-sources/data-tab-delete-columns.gif" />
</Frame>

<Tip>
  If you're unsure about removing something, consider hiding the column instead.
</Tip>

## Filtering the table

Use filters to focus on a specific subset of data (e.g., only 5-star reviews or responses from a certain region).

<Steps>
  <Step>
    Click **Filters** in the toolbar
  </Step>

  <Step>
    Select a column
  </Step>

  <Step>
    Choose a condition
  </Step>

  <Step>
    Apply the filter

    <Frame>
      <img src="https://mintlify.s3.us-west-1.amazonaws.com/caplena-32172960/images/CleanShot-2025-07-20-at-16.43.34-(1).gif" alt="Clean Shot 2025 07 20 At 16 43 34 (1)" />
    </Frame>
  </Step>
</Steps>

## Adding or replacing data

Keep your dataset up to date without having to re-upload everything from scratch.

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/dj8GHLkhkVrSagxW/images/Screenshot-2026-05-24-at-10.53.44.png?fit=max&auto=format&n=dj8GHLkhkVrSagxW&q=85&s=54958748c073b1205bc6b2ff201dd9b8" alt="Screenshot 2026 05 24 At 10 53 44" title="Screenshot 2026 05 24 At 10 53 44" className="mx-auto" style={{ width:"59%" }} width="694" height="636" data-path="images/Screenshot-2026-05-24-at-10.53.44.png" />
</Frame>

### Add rows

Appends new data to your existing dataset without affecting existing rows — perfect for continuously adding new feedback over time.

[Read the full article on Adding Data](/data-project-management/adding-replacing-data/append-rows-to-an-existing-project)

### Replace rows

Useful when correcting or updating existing fields.

[Read the full article on Replacing Data](/data-project-management/adding-replacing-data/add-replace-columns-in-your-dataset)

## Exporting data

Once you've cleaned or filtered your dataset, you can export it for further analysis or reporting. Options include exporting the full dataset or only the filtered data.

[Read the full article on Exporting Data](https://caplena-32172960.mintlify.app/data-project-management/data-export/exporting-your-data)
