CSV checker and converter API for AI agents
TollNode gives Claude, Cursor or any AI agent a pre-import check for CSV, JSON and Excel files (bad rows, broken emails, duplicates, a score) and conversion between CSV, JSON and .xlsx, from $0.003 per file.
Ask in plain words, like 'check this export before I import it into the CRM', and get the problems with row numbers.
No subscription · Sign-up optional · From $0.003 per call · Charged only when it works · No account needed
Check this contacts CSV before I import it. Emails must be unique
TollNode · preflight$0.003 · 4 rows · 1 s
| Check | Result |
|---|---|
| Verdict | fix first (score 50 of 100) |
| invalid_email | 1 row: row 3 |
| duplicate_emails | 1 row: row 4 |
| leading_zeros in zip | info: import as text |
Real result.
What your agent gets from a data file
- from $0.003
Preflight check
CSV, JSON and Excel file checker API
Lists everything that will break an import.
- Verdict
- fix first
- Score
- 50
- Issue
- invalid_email in 'email', row 3
- Issue
- duplicate_emails in 'email', row 4
- Note
- row numbers count the header as row 1
You get
- verdict: ready, fix first or similar
- score: 0 to 100
- issues: each with severity, column and row numbers
- column profile: type, fill rate, unique count, examples
- required columns: must exist and be filled
- unique column: values must not repeat
- from $0.003
Convert
CSV, JSON and Excel, in any direction.
- From
- csv
- To
- json
- Rows
- 4
- Zip 02134
- kept as text
You get
- to: csv, json or xlsx
- content or data: CSV text, JSON records or an .xlsx data URL
- delimiter: comma, semicolon or tab for CSV output
- sheet: which Excel sheet to read
- typing: numbers typed, ZIP-style codes kept as text
Every result is structured JSON your agent can sort, filter, summarize or turn into a spreadsheet.
What people ask their AI to do with it
Operations teams
Check an export before importing
“Check this customer CSV before I import it to the CRM; emails must be unique”
preflight
Cost today$0.003
Ecommerce sellers
Clean a product feed
“Check this product feed for missing SKUs and duplicate rows”
preflight
Cost today$0.003
Marketers
Validate a list before sending
“Find broken emails and duplicates in this mailing list”
preflight
Cost today$0.003
Analysts
Turn a spreadsheet into JSON
“Convert this Excel file to JSON records”
convert
Cost today$0.003
Developers
Normalize inputs
“Convert this CSV to JSON and keep ZIP codes as text”
convert
Cost today$0.003
Finance teams
Hand-off to Excel
“Convert this JSON report into an .xlsx file”
convert
Cost today$0.003
Use it as a CSV checker MCP server in Claude, Cursor or Codex
Connect once. Then just ask.
Paste this into Claude Code, Cursor or Codex. It connects TollNode and gives your agent a small wallet. Add a few dollars of USDC and you're done.
npx agentcash add https://tollnode.comCopy for your AI agent
Paste this into your agent so it knows what this node does and how to call it.
You can use TollNode's Data file check and convert node. Call POST https://tollnode.com/api/v1/nodes/data-file with an "action" (preflight, convert) and its fields: to (optional), url (optional), text (optional), sheet (optional), format (optional), delimiter (optional), unique_column (optional), required_columns (optional). Each action has its own price and is charged only when it returns a result. Over MCP, call the "data-file" tool; use list_models to see prices. Return results as tables when I ask for lists.2 actions, one node
Send action plus the fields that action needs, to the same address. Each action has its own price, charged only when it returns a result. Leave out action and you get preflight.
- preflight$0.003
Checks a file the way an importer would and lists everything that will break. Verdict, score, issues with row numbers, and each column's type, fill rate, unique count and examples.
needs: url or text · optional: required_columns, unique_column, format, sheet
- convert$0.003
Converts between CSV, JSON and Excel (.xlsx). CSV as content, JSON as data (numbers typed, ZIP-style codes kept as text), or .xlsx as a dataUrl with a filename.
needs: url or text, to · optional: delimiter, format, sheet
{"action":"preflight","url":"https://example.com/customers.csv"}{"action":"convert","url":"https://example.com/customers.csv","to":"json"}POST either body to https://tollnode.com/api/v1/nodes/data-file. From an AI assistant you don't write this yourself: ask in plain words and it picks the action.
Charged only when a call returns a result. Failed or empty calls cost $0.
Check and convert CSV and Excel files without a script
No subscription, no credit packs
Pay per action: preflight is $0.003, convert is $0.003.
No spreadsheet software, no import trial and error
Your agent calls TollNode. You never set up billing or request access with anyone else.
Only charged when it works
If a call returns nothing or fails, it costs nothing.
One connection, much more
The same setup also gives your agent Google search, YouTube, Maps, images and video, so one prompt can chain them.
FAQ
- Is there an official tool for this?
- No. This is TollNode's own checker and converter: it reads the file the way an importer would and lists what will break.
- Can I use it as a Data file check and convert MCP server in Claude?
- Yes. Add https://tollnode.com/mcp in Claude Code, Claude Desktop or Cursor, and the "data-file" tool appears with its fields and price.
- Which files work?
- CSV, TSV, JSON or .xlsx from a public link (up to 10 MB; Excel up to 5 MB), or paste the text. Public Google Sheets share links work. Old .xls files, PDFs and Word files are not supported.
- What does preflight report?
- A verdict, a 0 to 100 score, every issue with severity, column and Excel row numbers, and a profile of each column.
- What does convert return?
- CSV as text, JSON as records with numbers typed, or an .xlsx file as a data URL with a filename.
- Do I need an account with another service?
- No. Your agent calls TollNode, and you never log in to another service or share cookies.
- What if nothing comes back?
- You're not charged. TollNode only collects payment when a usable result is returned, and your agent can try a different input.
Works well with
Ready in a minute
Connect your AIFor developers: endpoint, inputs and an example response
POST https://tollnode.com/api/v1/nodes/data-file
Input
| Field | Type | Notes |
|---|---|---|
| to | enum | convert: the format you want (csv, json, xlsx) |
| url | string | A public link to a CSV, TSV, JSON or .xlsx file (up to 10 MB; Excel up to 5 MB). Google Sheets share links work when the sheet is public |
| text | string | Or paste the CSV or JSON itself |
| sheet | string | Excel sheet name. Default: the first sheet with data |
| action* | enum | preflight checks the file; convert turns it into another format (preflight, convert) |
| format | enum | Only if detection guesses wrong (csv, tsv, json, xlsx) |
| delimiter | enum | convert to csv: the separator. Default comma (comma, semicolon, tab) |
| unique_column | string | preflight: a column whose values must not repeat, e.g. email or sku |
| required_columns | array | preflight: columns that must exist and be filled in every row |
Example response
{
"file": {
"name": "customers.csv",
"bytes": 88213,
"format": "csv",
"encoding": "UTF-8",
"delimiter": "comma"
},
"note": "Row numbers count the header as row 1, as in Excel. Each issue lists up to 20 rows; count has the total.",
"rows": 1204,
"score": 55,
"issues": [
{
"rows": [
14,
88,
301
],
"check": "invalid_email",
"count": 7,
"column": "email",
"message": "Values in 'email' that are not valid email addresses.",
"severity": "error"
},
{
"rows": [
57,
912
],
"check": "wrong_field_count",
"count": 2,
"message": "2 rows have 7 fields; the header has 6. Usually an unquoted comma or a missing value.",
"severity": "error"
},
{
"rows": [
40,
77
],
"check": "duplicate_emails",
"count": 12,
"column": "email",
"message": "The same email appears more than once in 'email' (ignoring case).",
"severity": "warning"
},
{
"rows": [
2,
3,
4
],
"check": "date_format",
"count": 1204,
"column": "signup",
"message": "Dates in 'signup' are not in YYYY-MM-DD form. Importers can swap day and month (03/04 is March or April).",
"severity": "warning"
},
{
"rows": [],
"check": "leading_zeros",
"count": 96,
"column": "zip",
"message": "'zip' has codes with leading zeros (like ZIP codes). Import it as text, or the zeros are lost.",
"severity": "info"
}
],
"columns": [
{
"name": "email",
"type": "email",
"empty": 6,
"filled": 1198,
"unique": 1186,
"examples": [
"ana@example.com",
"ben@shop.io",
"cy@mail.com"
]
},
{
"name": "zip",
"type": "text",
"empty": 0,
"filled": 1204,
"unique": 611,
"examples": [
"02134",
"10001",
"94105"
]
}
],
"summary": "1,204 rows, 6 columns. 2 errors, 3 warnings.",
"verdict": "fix first"
}Also described in the OpenAPI file and llms.txt. Setup for every app: Agents & MCP.