#csv

Render tabular data as an HTML table, and parse an HTML table back into data. The render endpoint turns a JSON array (of objects, or of arrays) or CSV into a clean, semantic <table> with <thead>/<tbody>, an optional caption and CSS class — every cell HTML-escaped so it is safe to embed. The parse endpoint does the reverse: give it any HTML containing a table and get back the headers, the rows and a ready-to-use JSON array of objects, with entities decoded and tags stripped from each cell. Perfect for emails and reports, dashboards and admin screens, and scraping or migrating tabular content. Pure local computation — no key, no third-party service, instant; up to 2 MB via POST. Live, nothing stored. 3 endpoints. Distinct from Markdown/ASCII table rendering and from generic HTML extraction.

api.oanor.com/htmltable-api

Turn data into a ready-to-paste table. Give it JSON — either an array of objects (columns are taken from the keys) or an array of arrays (the first row is the header) — or raw CSV, and get back a clean GitHub-flavoured Markdown table or a monospace ASCII (box-drawn) table with auto-sized columns. Markdown output supports left/center/right column alignment and escapes pipes; the CSV parser is RFC-4180 aware (quoted fields, embedded commas and newlines). Perfect for README and documentation generation, CLI and log output, changelogs, chat bots and pull-request comments. Pure local computation — no key, no third-party service, instant; send large datasets via POST. Live, nothing stored. 3 endpoints. Distinct from CSV parsing/analysis and from Markdown rendering.

api.oanor.com/table-api

Spreadsheet cell-reference maths for Excel, Google Sheets, LibreOffice and CSV tooling. Parse an A1 reference (AA10) into its column letter, 1-based column number, row and R1C1 form; build an A1 (and R1C1) reference from a row and a column given either as a letter or a number; and convert a column letter to its number and back (A→1, Z→26, AA→27, ZZ→702). Absolute markers ($A$1) are accepted. Perfect for code that generates spreadsheets, maps data to cells, builds formulas, or imports and exports ranges. Pure local computation — no key, no third-party service, instant. Live, nothing stored. 4 endpoints. Distinct from CSV parsing and from generic number-base conversion.

api.oanor.com/cellref-api

A fast, fully-local CSV data toolkit: parse CSV into typed row objects (RFC-4180), compute per-column statistics (count, unique, type and top values, and for numeric columns min, max, mean, median and sum), remove duplicate rows by all or a subset of columns, sort by a column with numeric-aware ordering, and filter rows by a condition (equals, not-equals, greater/less than, contains, starts-with, empty, not-empty). Every endpoint accepts input via the query string or the request body, up to 2 MB, and returns both row objects and a CSV string. Pure server-side compute, no third-party upstream, so responses are instant and always available. Ideal for data wrangling, ETL, analytics preparation, spreadsheet tooling and data cleaning. (For plain CSV to JSON conversion, see the oanor JSON API.)

api.oanor.com/csv-api

A fast, fully-local JSON and CSV toolkit: validate JSON (with a clear error message, type and size), pretty-print and format it (with optional deep key-sorting), minify it (reporting bytes saved), and convert between CSV and JSON — RFC-4180 CSV parsing with automatic value typing, and JSON arrays to CSV. Every endpoint accepts input via the query string or the request body (up to 1 MB). Pure server-side compute, no third-party upstream, so responses are instant and always available. Ideal for data pipelines, ETL, webhooks, config tooling and developer utilities.

api.oanor.com/json-api