Remove duplicate rows
API · /csv-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 health
healthy- Uptime
- 100.00%
- Server probes · 24h
- Avg latency
- 66 ms
- Server probes · 24h
- Subscribers
- 4,621
- active
- Total calls
- 25
- last 7 days
Pricing
Pick a tier — billed monthly, cancel anytime.
Free
Free
- 11,000 calls / month
- 2 requests / second
- Hard cap (429 above quota, no overage)
- 11,000 requests/month, 2 req/s
- All endpoints: parse, stats, dedupe, sort, filter
- No credit card
Basic
€4.00 /month
- 190,000 calls / month
- 8 requests / second
- Hard cap (429 above quota, no overage)
- 190,000 requests/month, 8 req/s
- Per-column stats + numeric-aware sort/filter
- Commercial use, up to 2 MB input
- Email support
Pro
€15.00 /month
- 1,100,000 calls / month
- 25 requests / second
- Hard cap (429 above quota, no overage)
- 1,100,000 requests/month, 25 req/s
- Full parse + stats + dedupe + sort + filter pipeline
- Priority email support
- Commercial use allowed
Mega
€38.00 /month
- 5,500,000 calls / month
- 80 requests / second
- Hard cap (429 above quota, no overage)
- 5,500,000 requests/month, 80 req/s
- Max throughput for ETL & data-cleaning pipelines
- Priority support
- Commercial use allowed
Built by
Related APIs
Other APIs with overlapping tags.
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
Exercises API
A complete exercise and workout database covering 870+ exercises: search and filter by target muscle, required equipment, category, difficulty level, force type and mechanic, fetch a single exercise with step-by-step instructions, primary and secondary muscles and demonstration images, pull a random exercise matching any filter, and read all available facet values to build filter UIs. Every endpoint accepts input via the query string or the request body and returns lean, predictable JSON. Pure server-side data (no third-party upstream), so responses are instant and always available. Ideal for fitness and gym apps, workout planners, personal-trainer tools and health platforms.
api.oanor.com/exercises-api
Breweries API
Search, filter and locate breweries worldwide — a fast, clean wrapper over Open Brewery DB covering thousands of breweries across the US and beyond. Filter by city, state, country, name, postal code or brewery type (micro, nano, regional, brewpub, large, bar, contract and more), sort results nearest-first from any latitude/longitude, autocomplete brewery names for typeahead, pull random breweries, fetch a single brewery by id and read aggregate counts. Every endpoint accepts input via the query string or the request body and returns lean, predictable JSON with normalized address, coordinates, phone and website fields. Ideal for beer and travel apps, store locators, maps and directory features.
api.oanor.com/beer-api
Wikipedia API
A fast, clean wrapper over the official Wikimedia APIs covering every Wikipedia language: full-text article search with snippets, lead-section summaries (extract, short description, thumbnail and canonical URL), "on this day" historical events, births, deaths and holidays for any calendar day, and a random-article endpoint. Every endpoint takes a "lang" parameter (en, de, fr, es, simple, zh and any other Wikipedia language) and accepts input via the query string or the request body. Returns lean, predictable JSON with HTML stripped and entities decoded — no scraping, no rate-limit juggling, no client-side parsing. Ideal for chatbots and RAG pipelines, trivia and "this day in history" apps, knowledge panels, education and research tools.
api.oanor.com/wiki-api
Frequently asked questions
Quick answers about pricing, quotas, and integration.
How do I get an API key for CSV API?
What's the rate limit for CSV API?
How much does CSV API cost?
Can I cancel my subscription anytime?
Is CSV API GDPR-compliant?
Pick an endpoint from the list on the left to see its details and try it.
Code snippets
Sign up to get an API key, then call any path under your slug.
curl https://api.oanor.com/csv-api/SOME_PATH \
-H "x-oanor-key: oanor_test_..."
const res = await fetch("https://api.oanor.com/csv-api/SOME_PATH", {
headers: { "x-oanor-key": "oanor_test_..." }
});
const data = await res.json();
$ch = curl_init("https://api.oanor.com/csv-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/csv-api/SOME_PATH",
headers={"x-oanor-key": "oanor_test_..."},
)
print(r.json())
Ratings
Sign in to rate.
No reviews yet.
Discussion
Ask questions, share usage tips, get answers from the provider and other developers. Public — anyone can read.
Sign in to start a thread or reply.
Sign inNew thread
·
-
Provider answer
🔒 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.
Sign in to open a support ticket.
Sign inOpen new ticket
Describe what you need help with. The provider team gets an email and replies on the ticket page.
-
·
Urgent - No tickets yet for this API.