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**:…

2 subscribers
8.9/10 popularity
183 ms avg latency
100% success rate
40 endpoints
The in-depth APIMemo review for this API hasn't been published yet — the data below comes straight from the public marketplace listing.

CSV & Spreadsheet Toolkit endpoints

MethodEndpointDescription
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

PlanPriceRate limitQuotas
BASIC Free
  • Requests: 500,000 / monthly
Pro $9.99 / month 20 / minute
  • Requests: 10,000 / monthly
Ultra $29.99 / month 100 / minute
  • Requests: 100,000 / monthly

More Data APIs

View all →
  • This is a VIN (Vehicle Identification Number) decoder that designed to work within North America, Asia and…

    DataFreemium139 subscribers
  • Currency Exchange is a live foreign exchange rate API that lets developers retrieve real-time conversion…

    ReviewedDataFreemium23k subscribers
  • Words API lets you retrieve information about English words, including definitions, synonyms, rhymes,…

    DataFreemium1.5k subscribers
  • Whois Lookup API in Json or Xml. Our infrastructure uses thousands of SOCKS proxies to avoid quota…

    DataFreemium3.8k subscribers
  • The Weatherbit Weather API gives developers access to current conditions, multi-day forecasts, minutely…

    ReviewedDataFreemium25k subscribers
  • GeoDB Cities is a RESTful API covering more than 800,000 towns, cities, counties, and islands worldwide,…

    ReviewedDataFreemium49.8k subscribers