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
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.
Hiding & Favoriting Columns
These features help you focus on relevant fields without permanently changing your dataset.
Hide Columns:
-
Click Show/Hide Columns
-
Uncheck any column you don’t want to see
-
The table updates automatically
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.
-
Click the ⭐ icon on a column header
-
Favorites appear at the top of dropdowns and filters
-
Helpful for frequently used fields
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.
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