API · /cellref-api

Cell Reference API

healthy 4,863 Subscribers

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.

#spreadsheet #excel #a1 #cell-reference #csv #developer-tools

api.oanor.com/cellref-api

Get an API key Try in playground → Contact provider

Machine-readable spec so AI agents can integrate this API.

/api/cellref-api/openapi.json

/api/cellref-api/llms.txt

Discovery: GET /api/index.json lists every API.

Cell Reference API — live data on the oanor API marketplace

API health

healthy

Uptime: 100.00%; Server probes · 24h
Avg latency: 75 ms; Server probes · 24h
Subscribers: 4,863; active
Total calls: 76; last 7 days

Full status page → · 8 probes/24h

Pricing

Pick a tier — billed monthly, cancel anytime.

Free

800 calls / month
2 requests / second
Hard cap (429 above quota, no overage)
800 calls/month
2 req/sec
Parse + to-A1 + column
No credit card

Starter

€1.30 /month

6,500 calls / month
8 requests / second
Hard cap (429 above quota, no overage)
6.5k calls/month
8 req/sec
A1 + R1C1 both ways
Email support

Pro

€19.40 /month

127,000 calls / month
20 requests / second
Hard cap (429 above quota, no overage)
127k calls/month
20 req/sec
Spreadsheet-generation pipelines
Priority support

Mega

€55.40 /month

655,000 calls / month
50 requests / second
Hard cap (429 above quota, no overage)
655k calls/month
50 req/sec
Platform scale
Dedicated SLA

Built by

PremiumApi

Related APIs

Other APIs with overlapping tags.

HTML Table API

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

Table 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

CSV 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

JSON 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

Frequently asked questions

Quick answers about pricing, quotas, and integration.

How do I get an API key for Cell Reference API?

Sign up for free at oanor.com, generate an API key from the developer dashboard, and call Cell Reference API with the x-oanor-key header. No credit card needed for the free tier.

What's the rate limit for Cell Reference API?

Free tier allows 1 request per second. Paid plans scale up to 50 requests per second on the Mega tier. Hard limits return HTTP 429 above the quota — no surprise overage charges.

How much does Cell Reference API cost?

Cell Reference API has a free tier with 100 calls / month. Paid plans start at €1.30 / month with higher quotas and faster rate limits.

Can I cancel my subscription anytime?

Yes. Plans are billed monthly and you can cancel anytime from your billing dashboard. No long-term contracts and no cancellation fee.

Is Cell Reference API GDPR-compliant?

All requests to Cell Reference API go through our EU-based gateway. Your upstream API key never leaves our server and no personal data is shared with the upstream provider beyond the request you send.

Cell Reference 3

Meta 1

Pick an endpoint from the list on the left to see its details and try it.

GET /v1/column

Column letter <-> number

Playground

Parameters

Custom headers

Language: Client:

GET /v1/parse

Parse an A1 cell reference

Playground

Parameters

Custom headers

Language: Client:

GET /v1/to-a1

Build an A1 reference

Playground

Parameters

Custom headers

Language: Client:

GET /v1/meta

Spec

Playground

Custom headers

Language: Client:

Code snippets

curl https://api.oanor.com/cellref-api/SOME_PATH \
  -H "x-oanor-key: oanor_test_..."

const res = await fetch("https://api.oanor.com/cellref-api/SOME_PATH", {
  headers: { "x-oanor-key": "oanor_test_..." }
});
const data = await res.json();

$ch = curl_init("https://api.oanor.com/cellref-api/SOME_PATH");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, ["x-oanor-key: oanor_test_..."]);
$response = curl_exec($ch);

import requests
r = requests.get(
    "https://api.oanor.com/cellref-api/SOME_PATH",
    headers={"x-oanor-key": "oanor_test_..."},
)
print(r.json())

Ratings

No reviews yet.

Discussion

Ask questions, share usage tips, get answers from the provider and other developers. Public — anyone can read.

New thread

📌 Pinned 🔒 Locked

· ·

🔒 This thread is locked — no new replies.

No threads yet — start the discussion.

Support

Private 1:1 support with the provider — billing questions, integration issues, account problems. Only you and the provider team can see these threads.

Open new ticket

Describe what you need help with. The provider team gets an email and replies on the ticket page.

No tickets yet for this API.

Subscription active — calls can start immediately.

Send your first request —

Subscription active — copy a snippet and fire off your first call.

Pick a key

Plaintext is shown once at creation — use the prefix as a reminder.

Cell Reference API

API health

Pricing

Built by

Related APIs

HTML Table API

Table API

CSV API

JSON API

Frequently asked questions

Parameters

Parameters

Parameters

Code snippets

Ratings

Discussion

New thread

📌 🔒

Support

Open new ticket

Your cookie choices