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

Elapsed

1.84 s

Per-step summary

step	status	elapsed_ms	summary
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