The Data Tab is where you can view, clean, and manage your dataset in Caplena. Whether you're preparing data for analysis, fixing errors, or customizing the table view, this section gives you full control without needing to re-upload 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.
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 in the Data Tab. A Column Details panel will open with two sections.
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
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.
Favoriting & Hiding Columns
These features help you focus on relevant fields without permanently changing your dataset.
Favorite Columns:
Favorite Columns let you quickly access your most-used columns when working with data in Caplena. This feature is especially helpful when you’re dealing with many columns and want to streamline your view and filtering options.
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.
Hide Columns:
-
Click Show/Hide Columns
-
Uncheck any column you don’t want to see
-
The table updates automatically
Editing Text Fields
You can edit responses or text rows directly from the table, which is helpful for fixing typos or clarifying entries.
To edit:
-
Click the field you want to change
-
Make your edits
-
Press
Enter, or click outside to save
Each verbatim edit uses 1 credit, as Caplena reprocesses the entry to update insights like sentiment and topics.
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
Delete Columns:
-
Click Delete Columns
-
Choose the column to remove
-
Confirm the action
Tip: If you're unsure about removing something, consider hiding the column instead.
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).
To apply a filter:
-
Click Filters in the toolbar
-
Select a column
-
Choose your condition
-
Apply the filter
Adding or Replacing Data
Keep your dataset up to date without having to re-upload everything from scratch.
Add Rows
-
Appends new data to your existing dataset
-
Existing data stays unchanged
-
Perfect for continuously adding new feedback over time
Read the full article on Adding Data→
Replace Rows
-
Useful when correcting or updating existing fields
Read the full article on Replacing Data →
Exporting Data
Once you’ve cleaned or filtered your dataset, you can export it for further analysis or reporting.
Options:
-
Export the full dataset
-
Export only filtered data