Data

CSV, spreadsheets and structured data. 12 tools. Run any of them from the app, as dogubako data <tool>, over the HTTP API or as an MCP tool.

Tool	Id	Needs
CSV Viewer	data.csv_view	—
Filter & Sort CSV	data.csv_filter_sort	—
CSV to JSON	data.csv_to_json	—
JSON to CSV	data.json_to_csv	—
Spreadsheet Viewer & Export	data.spreadsheet	—
Change CSV Delimiter	data.delimiter	—
Transform Columns	data.columns	—
Validate CSV / JSON Data	data.validate	—
Find Duplicate Rows	data.duplicates	—
Column Statistics	data.stats	—
Clean CSV Data	data.clean	—
Convert Table Data	data.convert	—

CSV Viewer

nativelive

Preview a CSV/TSV file or pasted text as a table with automatic delimiter, header and column type detection.

dogubako data csv-view [file] [options]

Id data.csv_view · MCP data_csv_view · Output: structured data · Timeout 2 min

Also found by: csv, tsv, viewer, table, open csv, preview, spreadsheet

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
offset	--offset	integer ≥ 0	0	Start at row.
limit	--limit	integer 1–500	100	Rows to show.

Filter & Sort CSV

native

Filter rows by column conditions (equals, contains, regex, >, <), sort by one or more columns and choose/reorder columns.

dogubako data csv-filter-sort [file] [options]

Id data.csv_filter_sort · MCP data_csv_filter_sort · Output: structured data · Timeout 2 min

Also found by: csv, filter, sort, where, query, select columns, order by

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
filter_column	--filter-column	text
filter_op	--filter-op	choice	contains	Condition. One of: equals, not_equals (does not equal), contains, not_contains (does not contain), starts_with (starts with), ends_with (ends with), regex (matches regex), gt (>), gte (≥), lt (<), lte (≤), empty (is empty), not_empty (is not empty).
filter_value	--filter-value	text		Value.
filters	--filters	JSON		JSON list like [{“column”: “age”, “op”: “gte”, “value”: 18}]. Advanced.
case_insensitive	--case-insensitive	boolean	true	Ignore case when comparing.
sort	--sort	text		Comma-separated columns, each optionally followed by asc/desc.
columns	--columns	text		Output columns (blank = all).
output_delimiter	--output-delimiter	choice	comma	One of: comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.

CSV to JSON

nativelive

Convert CSV/TSV into a JSON array of objects, an array of arrays or NDJSON, with optional type inference.

dogubako data csv-to-json [file] [options]

Id data.csv_to_json · MCP data_csv_to_json · Output: text (application/json) · Timeout 2 min

Also found by: csv to json, tsv to json, convert, ndjson, json lines

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
shape	--shape	choice	objects	One of: objects (Array of objects), arrays (Array of arrays), ndjson (NDJSON (one object per line)).
infer_types	--infer-types	boolean	true	Detect numbers, booleans and nulls.
pretty	--pretty	boolean	true	Pretty print.

JSON to CSV

nativelive

Convert a JSON array (or NDJSON) into CSV, flattening nested objects into dotted column names.

dogubako data json-to-csv [file] [options]

Id data.json_to_csv · MCP data_json_to_csv · Output: structured data · Timeout 2 min

Also found by: json to csv, flatten, convert, export, ndjson, excel

Option	CLI	Type	Default	Description
file	positional	file		JSON file. Accepts .json .ndjson .jsonl.
text	--text	text (multi-line)		Or paste JSON.
separator	--separator	text	.	Nested key separator.
arrays	--arrays	choice	index	One of: index (Separate columns (tags.0, tags.1)), join (Join values with ;), json (Keep as JSON text).
output_delimiter	--output-delimiter	choice	comma	One of: comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |).

Spreadsheet Viewer & Export

native

Open Excel (xlsx, xls, xlsb) and OpenDocument (ods) spreadsheets: list sheets, preview a sheet and export it as CSV or JSON.

dogubako data spreadsheet <file> [options]

Id data.spreadsheet · MCP data_spreadsheet · Output: structured data · Timeout 5 min

Also found by: excel, xlsx, xls, ods, spreadsheet, sheet, xlsx to csv, excel to json

Option	CLI	Type	Default	Description
file (required)	positional	file		Spreadsheet. Accepts .xlsx .xlsm .xls .xlsb .ods.
sheet	--sheet	text		Sheet name (blank = first).
action	--action	choice	preview	One of: preview, csv (Export as CSV), json (Export as JSON), all_csv (Export every sheet as CSV).
header	--header	boolean	true	First row is a header.
offset	--offset	integer ≥ 0	0	Start at row. Only used when action is preview.
limit	--limit	integer 1–500	100	Rows to show. Only used when action is preview.

Change CSV Delimiter

nativelive

Convert between comma, tab, semicolon and pipe separated values and change the quoting style.

dogubako data delimiter [file] [options]

Id data.delimiter · MCP data_delimiter · Output: structured data · Timeout 2 min

Also found by: csv, tsv, delimiter, separator, semicolon, tab, quote, csv to tsv, tsv to csv

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
output_delimiter	--output-delimiter	choice	tab	One of: comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |).
quote	--quote	choice	necessary	Quoting. One of: necessary (Only when needed), always, non_numeric (Non-numeric fields), never.

Transform Columns

native

Rename, drop, reorder, split, merge, change case, trim or find-and-replace in CSV columns, or add a row index.

dogubako data columns [file] [options]

Id data.columns · MCP data_columns · Output: structured data · Timeout 2 min

Also found by: csv, columns, rename, drop, reorder, split column, merge columns, transform

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
operation	--operation	choice	rename	One of: rename, drop (Drop columns), select (Keep / reorder columns), split (Split a column), merge (Merge columns), upper (UPPERCASE values), lower (lowercase values), title (Title Case values), trim (Trim values), replace (Find & replace in values), index (Add row number column).
columns	--columns	text		Comma-separated column names or 1-based numbers.
mapping	--mapping	text		Renames. Only used when operation is rename.
separator	--separator	text		Only used when operation is one of split, merge.
new_names	--new-names	text		New column name(s). Only used when operation is one of split, merge, index.
find	--find	text		Only used when operation is replace.
replace	--replace	text		Replace with. Only used when operation is replace.
regex	--regex	boolean	false	Find is a regular expression. Only used when operation is replace.
keep_original	--keep-original	boolean	false	Keep the original column(s). Only used when operation is one of split, merge.
output_delimiter	--output-delimiter	choice	comma	One of: comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.

Validate CSV / JSON Data

native

Check CSV rows against rules (required columns, types, unique, regex, ranges, allowed values) or JSON against a JSON Schema; lists every error.

dogubako data validate [file] [options]

Id data.validate · MCP data_validate · Output: structured data · Timeout 2 min

Also found by: validate, csv, data quality, rules, schema, check, lint, json schema

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
required_columns	--required-columns	text
rules	--rules	JSON		JSON like {“id”: {“type”: “integer”, “required”: true, “unique”: true}, “email”: {“type”: “email”}, “age”: {“min”: 0, “max”: 130}, “status”: {“values”: [“open”, “closed”]}}. Types: integer, number, boolean, date, email, url, uuid, string.
schema	--schema	JSON		JSON Schema (for JSON input). Advanced.

Find Duplicate Rows

native

Find or remove duplicate rows in CSV data, comparing all columns or only selected ones.

dogubako data duplicates [file] [options]

Id data.duplicates · MCP data_duplicates · Output: structured data · Timeout 2 min

Also found by: duplicates, dedupe, unique rows, csv, distinct, remove duplicates

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
columns	--columns	text		Compare columns (blank = all).
ignore_case	--ignore-case	boolean	true
trim	--trim	boolean	true	Ignore surrounding whitespace.
keep	--keep	choice	first	One of: first (Keep first occurrence), last (Keep last occurrence).
output_delimiter	--output-delimiter	choice	comma	One of: comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.

Column Statistics

native

Summarize each column: count, empty values, distinct values, min/max/mean/median/standard deviation for numbers and top values for text.

dogubako data stats [file] [options]

Id data.stats · MCP data_stats · Output: structured data · Timeout 2 min

Also found by: statistics, summary, describe, profile, csv, mean, median, column stats

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
top	--top	integer 0–20	3	Top values per column. Advanced.

Clean CSV Data

native

Tidy CSV data: trim cells, normalize whitespace, blank out placeholder values, standardize dates to ISO 8601, remove empty rows and columns.

dogubako data clean [file] [options]

Id data.clean · MCP data_clean · Output: structured data · Timeout 2 min

Also found by: clean, tidy, csv, normalize, trim, dates, iso 8601, empty rows, data cleaning

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
operations	--operations	list of choices	trim,nulls,empty_rows,empty_columns	Any of: trim (Trim cells), whitespace (Collapse inner whitespace & line breaks), nulls (Blank out NULL / N/A / - / none), dates (Standardize dates to YYYY-MM-DD), empty_rows (Remove empty rows), empty_columns (Remove empty columns), headers (Clean header names (snake_case)).
day_first	--day-first	boolean	false	Ambiguous dates are day-first (31/12/2024). Advanced.
output_delimiter	--output-delimiter	choice	comma	One of: comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.

Convert Table Data

native

Convert tabular data between CSV, TSV, JSON, NDJSON, YAML, Excel XLSX, Markdown tables, HTML tables and SQL INSERT statements.

dogubako data convert [file] [options]

Id data.convert · MCP data_convert · Output: files · Timeout 2 min

Also found by: convert, csv to excel, csv to xlsx, xlsx to csv, markdown table, html table, sql insert, csv to json

Option	CLI	Type	Default	Description
file	positional	file		Accepts text/*, .csv .tsv .txt .json .ndjson .jsonl +4 more.
text	--text	text (multi-line)		Or paste CSV.
delimiter	--delimiter	choice	auto	One of: auto (Auto-detect), comma (Comma ,), tab, semicolon (Semicolon ;), pipe (Pipe |). Advanced.
header	--header	choice	auto	One of: auto (Auto-detect), yes (First row is a header), no (No header). Advanced.
to	--to	choice	xlsx	One of: xlsx (Excel (.xlsx)), csv, tsv, json, ndjson, yaml, markdown (Markdown table), html (HTML table), sql (SQL INSERT statements).
infer_types	--infer-types	boolean	true	Detect numbers and booleans.
table_name	--table-name	text	data	SQL table name. Only used when to is sql.