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

# Append Rows to an Existing Project

> Easily upload new data to your existing project, no need to start over or reconfigure your analysis.

Need to add more responses to your existing Caplena project? You can do this easily from the **Data View** tab.

<Note>
  As long as your existing data has already been analyzed (i.e., topics are in place), any newly added data will automatically be assigned to topics using the current setup.
</Note>

## Step 1: Go to the Data Tab

* In your project, click the **Data** icon in the left-hand navigation bar.
* Then click **Add new rows** in the top-right corner.

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/ye3a-qlnJZGOANMT/images/CleanShot-2025-07-20-at-19.30.00.gif?s=a75ea3d405d2590d80f79731146354cb" alt="Clean Shot 2025 07 20 At 19 30 00" width="800" height="209" data-path="images/CleanShot-2025-07-20-at-19.30.00.gif" />
</Frame>

## Step 2: Upload Your File

In the import screen:

* Drag and drop your file, or click to browse
* File types supported: `.xls`, `.xlsx`, `.csv`, `.sav`, `.spss`
* *(Optional)* Add a name for the data source
* Make sure your file includes column headers in the **first row**
* Click **Continue** to proceed

<Note>
  Your file **does not need to match** the previous column order or column count
</Note>

## Step 3: Match Your Columns

Caplena will guide you through matching the new file’s columns with those already in your project.

**What happens automatically:**

* Columns with the same name are matched
* Order doesn’t matter, Caplena accepts columns in any order

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/ye3a-qlnJZGOANMT/images/Screenshot-2026-05-22-at-13.02.08.png?fit=max&auto=format&n=ye3a-qlnJZGOANMT&q=85&s=de57e7e29abc303380bcbf8d55dba04b" alt="Screenshot 2026 05 22 At 13 02 08" width="3270" height="710" data-path="images/Screenshot-2026-05-22-at-13.02.08.png" />
</Frame>

**Additional options:**

* Skip columns you don’t want to import
* Create new columns for unmatched fields
* Manually match columns if needed

<iframe src="https://www.loom.com/embed/b1dbf459649b4ebc9189d6e6c84a1ef0" title="Loom video player" frameborder="0" className="w-full aspect-video rounded-xl" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen />

<Tip>
  **Tip:** Use the filters at the top of the screen to focus on specific column types (text, numeric, date, etc.)
</Tip>

## Step 4: Validate and Finalize

* Click **Validate** to confirm your column mappings
* Click **Finalize** to upload the new rows

<Check>
  Your new data will now be added to the project and analyzed automatically.
</Check>

### Auto-Translation

If you plan to use **auto-translation**, please enable it when **creating the project**.\
It cannot be activated retroactively for existing projects.

<Note>
  Learn more about auto-translation →
</Note>

### Duplicate Row Handling

To avoid importing duplicates:

* Enable the **“Skip existing rows based on matched column”** toggle
* Select the column used for deduplication, usually an \*\*ID field

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/ye3a-qlnJZGOANMT/images/Screenshot-2026-05-22-at-13.04.05.png?fit=max&auto=format&n=ye3a-qlnJZGOANMT&q=85&s=f5fc70f53897ad9e91813d6684182320" alt="Screenshot 2026 05 22 At 13 04 05" width="2960" height="1176" data-path="images/Screenshot-2026-05-22-at-13.04.05.png" />
</Frame>

This ensures that already-uploaded rows are not imported again. You can select multiple columns to match by. A row is considered a **duplicate** if **all column values are identical**.
