Home Tables Working with Rows

Working with Rows

Last updated on Apr 06, 2026

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

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?