# Layout review — Automated Workflows

visibility Static layout preview of Automated Workflows (Pipeline Runner), shown with a file imported, a four-step pipeline configured, and a completed run (results + per-step summary). All pages →

# Automated Workflows

Run several tools in a row — save the steps once, reuse them anytime.

Import CSV or Excel file
upload_file Drag and drop file here Up to 1.5 GB · CSV, TSV, XLSX, XLS · encoding & delimiter auto-detected
customers_export.csv 2.1 MB
Preview: customers_export.csv

18,442 rows, 6 columns

| name | email | city | phone | signup_date
--- | --- | --- | --- | --- | ---
0 | Jane Doe | jane@acme.io | Austin | 512-555-0190 | 2024-01-04
1 | jane doe | JANE@ACME.IO | austin | (512) 555-0190 | 01/04/2024
2 | Bob Smith | bob@globex.com | Denver | 720.555.7781 | 2024-02-11
3 | R. Smith | bob@globex.com | — | 720-555-7781 | Feb 11 2024

Options
How would you like to define the pipeline?
Use the recommended default (text-clean → format → missing → dedup) Build interactively Import a saved pipeline JSON

Edit the table to add, remove, reorder (drag the row index), enable, or configure each step. Tool order is recommended, not enforced — violations surface as warnings below the table.

| Tool | Enabled | Options (JSON)
--- | --- | --- | ---
≡ 0 | text_clean expand_more | check | {"trim": true, "collapse_whitespace": true}
≡ 1 | format_standardize expand_more | check | {"column_types": {"phone": "phone", "signup_date": "date"}}
≡ 2 | missing expand_more | check | {"strategy": "flag", "sentinels": ["N/A", "—"]}
≡ 3 | dedup expand_more | check | {"survivor_rule": "most_complete", "merge": true}
＋ | Add row

Recommended tool order — why each step belongs where it does

text_clean before format_standardize — format parsers (phone / currency / date) fail on smart-quote-contaminated or NBSP-padded input — clean text first

text_clean before missing — sentinel detection misses cells padded with NBSP / zero-width characters — clean text first

text_clean before dedup — fuzzy matching treats NBSP-padded values as different — clean text first

format_standardize before missing — numeric imputation needs numeric dtypes; canonical phones / currencies improve sentinel detection

format_standardize before dedup — canonical phones / lowercase emails enable cross-format duplicate matching

missing before dedup — deduping rows with mixed NaN sentinels produces brittle merges — resolve missing values first

## Results

Initial rows
18,442
Final rows
18,130
Steps run
4
Elapsed
1.84 s

#### Per-step summary

step | status | elapsed_ms | summary | error
--- | --- | --- | --- | ---
text_clean | ok | 214 | {"cells_changed": 1204, "columns": ["name", "city"]} |
format_standardize | ok | 388 | {"phone": 18301, "signup_date": 17996} |
missing | ok | 121 | {"flagged_cells": 642, "sentinels_found": ["—"]} |
dedup | ok | 911 | {"input_rows": 18442, "output_rows": 18130, "duplicates_removed": 312, "groups": 147} |

#### Output preview (first 10 rows)

| name | email | city | phone | signup_date
--- | --- | --- | --- | --- | ---
0 | Jane Doe | jane@acme.io | Austin | +1 512-555-0190 | 2024-01-04
1 | Bob Smith | bob@globex.com | Denver | +1 720-555-7781 | 2024-02-11
2 | Carla Reyes | carla@initech.co | Phoenix | +1 480-555-3320 | 2024-03-02
3 | Dan Okafor | dan@umbrella.net | ⚑ missing | +1 206-555-7745 | 2024-03-18
4 | Emily Tran | emily@hooli.com | Seattle | +1 206-555-1182 | 2024-04-05