# Working with Rows

Rows are your individual records. Each row represents one person, company, lead, or contact. In TexAu, you can add rows, edit them, run bulk operations, and watch enrichment happen in real time.

## Add Rows

### Add One Row at a Time

1. **Click the "+ Add Row" button** at the bottom of your table
2. **Enter data** by typing directly into the cells that appear
3. **Use Tab to move to the next cell** for faster entry
4. **Click Save** when you are done (or press Enter)

Your new row appears at the bottom of your table and is ready for enrichment.

### Add Multiple Rows in Bulk

**Option 1: Import from CSV** (Recommended)
- Prepare a CSV file with your data
- Click **Import** in your table
- Map your columns and confirm
- All rows import at once
- [Learn more about importing](importing-data.md)

**Option 2: Copy and Paste**
- Select data in Excel, Google Sheets, or another table
- Click **Paste Data** in TexAu
- Map the columns to your TexAu columns
- Click **Paste** to add all rows instantly

**Option 3: Manual Entry**
- Use the **+ Add Row** button repeatedly
- Best for small batches (fewer than 10 rows)

> **Tip:** For any bulk operation with more than 5 rows, CSV import is usually faster and less error-prone than manual entry.

## Edit Cell Values

Click any cell and change the data:

1. **Click any cell** to edit
2. **Type or select** the new value
3. **Press Enter or Tab** to move to the next cell
4. **Click elsewhere** to save and exit edit mode

### Bulk Edit

To change the same value in multiple cells:

- **Select multiple cells** by holding Shift and clicking (or dragging)
- **Right-click and choose "Bulk Edit"**
- **Select what to do** (replace value, append text, clear, etc.)
- **Confirm** to update all selected cells at once

### Fill Down

To repeat a value in multiple rows:

1. **Click the cell** with the value you want to copy
2. **Select the range** where you want to fill it
3. **Right-click and choose "Fill Down"**
4. Selected cells now contain that value

> **Useful for:** Setting department for a batch of people, marking a batch of rows with the same source, or applying a default status to multiple records.

## Delete Rows

1. **Click the row number** on the left side to select the entire row
2. **Right-click and choose "Delete Row"**
3. **Confirm** when prompted (deletion is permanent)

To delete multiple rows:
- **Multi-select rows** by holding Shift or Ctrl and clicking row numbers
- **Right-click and choose "Delete Rows"** to remove them all at once

> **Safety feature:** TexAu asks for confirmation before permanently deleting rows. If you delete accidentally and catch it immediately, reach out to our team. We may be able to help recover it.

## Select Multiple Rows

Many actions work on multiple rows at once. Here is how to select them:

### Select All Rows
- **Click the checkbox** in the column header (top left)

### Select a Range
- **Click the first row** you want
- **Hold Shift and click the last row** in your range

### Select Specific Rows
- **Hold Ctrl (Cmd on Mac) and click** individual row numbers

### Select by Filter
- **Use filters** to show only certain rows (see Filtering below)
- **Select all visible rows** with the header checkbox

## Cell Status Indicators

When you run an enrichment, each cell shows a status indicator. Here is what each status means:

| Status | Color | Meaning |
|--------|-------|---------|
| **Pending** | Gray | Waiting to be enriched. Has not started yet. |
| **Processing** | Blue | Currently being enriched. The data provider is looking up information. |
| **Completed** | Green | Enrichment finished. Data was found and populated. |
| **Failed** | Red | Enrichment could not find data or encountered an error. |
| **Skipped** | Gray | Cell was skipped because it already had data or did not meet enrichment criteria. |
| **Not Found** | Orange | The provider searched but found no matching data for this cell. |

### What Happens During Enrichment

1. You click **Run Enrichment**
2. All cells show **Pending** status
3. TexAu starts processing and cells move to **Processing**
4. As data comes back, cells update and show **Completed**, **Not Found**, or **Failed**
5. After enrichment finishes, you see the final status for each cell

## Real-Time Updates

When enrichment runs, you see results appear cell by cell in real time. You do not need to run enrichment and check back later. You run enrichment and watch it happen.

### How It Works
1. You click **Run Enrichment**
2. TexAu connects to data providers and starts requesting information
3. As responses come back, TexAu immediately populates the cells
4. You see cells update live: email addresses appear, job titles fill in, LinkedIn URLs populate
5. Each cell's status updates as enrichment progresses

### Why This Matters
- **No waiting**: See results immediately instead of checking back later
- **Quick feedback**: Know right away if something is not working
- **Visual confirmation**: Watching data fill in confirms enrichment is running
- **Keep working**: You can continue working while enrichment runs in the background

### Can You Keep Working While Enrichment Runs?

Yes. Enrichment runs in the background. You can:
- Switch to another table
- Add more rows
- Edit existing cells
- Export data
- Use another browser tab

Everything keeps running, and your enrichment completes without interruption.

## Pagination and Sorting

### Pagination
- **View 25, 50, or 100 rows** at a time
- **Jump to a specific page** using the page number input
- **Go to last page** with the >> button
- **Search within table** to find specific rows

### Sort Rows
Click any column header to sort:
- **First click**: Sort A to Z (or low to high for numbers)
- **Second click**: Sort Z to A (or high to low)
- **Sort by multiple columns** by holding Shift while clicking

### Multi-Column Sort

1. **Right-click any column header**
2. **Select "Advanced Sort"**
3. **Add multiple sort criteria** in priority order
4. Choose ascending or descending for each

> **Useful for:** Organizing prospects by company and seniority level, or grouping leads by location and industry.

## Filter Rows

### Basic Filters
- **Click the funnel icon** next to any column
- **Select what to show** (is empty, equals "Sales", contains "texau.com", etc.)
- **See results instantly**

### Multi-Column Filters
- Apply filters to multiple columns simultaneously
- Each filter adds to the previous one (all conditions must be true)
- **Example:** Show only rows where Department = "Sales" AND Status = "Completed"

### Filter Options
- **Contains**: Text appears anywhere
- **Equals**: Exact match
- **Starts with**: Text at the beginning
- **Ends with**: Text at the end
- **Is empty**: No value in this column
- **Is not empty**: Has any value
- **Greater than / Less than**: For numbers and dates

### Save Filters
- Create a saved filter view so you can return to it later
- Useful for "Active Prospects," "Needs Enrichment," "Export Ready"

> **Example workflow:** Filter to show only rows where Email is empty. Run enrichment on those specific rows. Watch them populate in real time.

## Row Management Tips

### Before Running Enrichment
- **Review your data**: Check that key identifier columns (email, company name) are populated
- **Clean up duplicates**: Fewer rows means fewer credits used
- **Sort or filter** to the subset you want to enrich

### During Enrichment
- **Monitor progress**: Watch the status indicators or enrichment progress bar
- **Stop if needed**: You can pause enrichment at any time
- **Check for errors**: Failed cells appear in red. Investigate if something looks wrong.

### After Enrichment
- **Review results**: Spot-check a few rows to ensure data looks good
- **Re-enrich if needed**: Run enrichment again to fill remaining empty cells
- **Export or use**: Move enriched data to your CRM, email tool, etc.

---

**What's Next?**
- Learn about [running enrichments](running-enrichments.md) to populate your rows with data
- Explore [understanding columns](understanding-columns.md) to set up the right structure
- See how to [export your data](exporting-data.md) when you are ready to use it elsewhere