CSV & Spreadsheet Toolkit
## Overview The CSV & Spreadsheet Toolkit API provides 40 endpoints for parsing, transforming, querying, and converting tabular data. Handle CSV, TSV, and Excel-style data. ## Key Features - **Parsing**: Read CSV/TSV with configurable delimiters, quote characters, and encoding - **Querying**: Filter rows, select columns, sort, group by, aggregate (sum, avg, count) - **Transformation**:…
CSV & Spreadsheet Toolkit endpoints
| Method | Endpoint | Description |
|---|---|---|
| POST |
Parse CSV string to JSON array /parse/csv |
Parse a CSV string and return rows as a JSON array of objects (if headers present) or array of arrays. |
| POST |
Parse TSV (tab-separated) to JSON /parse/tsv |
Parse a tab-separated values string to JSON. |
| POST |
Auto-detect CSV properties /parse/detect |
Detect: delimiter, has_headers, encoding hint, row_count, column_count, column_types. |
| POST |
Validate CSV structure /parse/validate |
|
| POST |
Preview first N rows of CSV /parse/preview |
|
| POST |
Extract specific columns by name or index /parse/columns |
|
| POST |
Split CSV into chunks of N rows /parse/split |
|
| POST |
Merge/join two CSVs by a key column /transform/merge |
|
| POST |
Transpose rows and columns /transform/transpose |
|
| POST |
Filter rows by condition /transform/filter |
|
| POST |
Sort rows by column /transform/sort |
|
| POST |
Remove duplicate rows /transform/deduplicate |
|
| POST |
Rename column headers /transform/rename-columns |
|
| POST |
Add a computed column /transform/add-column |
|
| POST |
Pearson correlation between two numeric columns /analyze/correlation |
|
| POST |
Generate sample CSV with specified columns and data types /generate/sample |
|
| POST |
Reorder columns /transform/reorder-columns |
|
| POST |
Pivot — group by one column, aggregate another /transform/pivot |
|
| POST |
Unpivot/melt — wide to long format /transform/unpivot |
|
| POST |
CSV to SQL INSERT statements /convert/csv-to-sql |
|
| POST |
Trim whitespace from all values /transform/trim |
|
| POST |
Fill empty cells with a default value /transform/fill-empty |
|
| POST |
CSV to JSON array of objects /convert/csv-to-json |
|
| POST |
JSON array to CSV string /convert/json-to-csv |
|
| POST |
CSV to XML /convert/csv-to-xml |
|
| POST |
Data quality score (completeness, consistency, validity) /analyze/quality |
|
| POST |
CSV to YAML-like format /convert/csv-to-yaml |
|
| POST |
CSV to HTML table /convert/csv-to-html |
|
| POST |
CSV to Markdown table /convert/csv-to-markdown |
|
| POST |
Column-level statistical summary /analyze/summary |
|
| POST |
Detect column types /analyze/types |
|
| POST |
Detect numeric outliers using IQR method /analyze/outliers |
|
| POST |
Value frequency distribution for a column /analyze/frequency |
|
| POST |
Report missing/empty values per column /analyze/missing |
|
| GET |
API information / |
|
| POST |
Generate CSV template with headers and example rows /generate/template |
|
| POST |
Generate sequential data (dates, IDs, increments) /generate/sequence |
|
| GET |
Return a demo CSV dataset (25 rows of fake person data) /generate/demo |
|
| POST |
Convert SQL CREATE TABLE to CSV header template /generate/sql-to-csv |
|
| GET |
Health check /health |
CSV & Spreadsheet Toolkit pricing
| Plan | Price | Rate limit | Quotas |
|---|---|---|---|
| BASIC | Free | — |
|
| Pro | $9.99 / month | 20 / minute |
|
| Ultra | $29.99 / month | 100 / minute |
|