Docs/Skills/CSV to JSON Skill

CSV to JSON Skill

Convert CSV data to JSON format

OperationalCredits 2 per callp50 152msData Conversion

Overview

CSV to JSON Converter works by parsing CSV data and converting it into JSON objects. It automatically detects columns, handles quoted values, and supports custom delimiters. Maximum file size is 500KB.

Live Test CSV to JSON Skill Skill →

The tool

Once your client is connected to the VerveKit server, this appears in its tool list as CSVtoJSONSkill. It is read-only and open-world — it fetches and never mutates anything on your side — so most clients call it without asking you to confirm.

Tool call
{
  "name": "CSVtoJSONSkill",
  "arguments": {
    "csv": "name,age,city\nJohn,30,New York\nJane,25,Los Angeles"
  }
}

You do not name the tool yourself; the model picks it. Asking about name,age,city John,30,New York Jane,25,Los Angeles in the terms this skill covers is enough for it to reach for CSVtoJSONSkill on its own — naming it explicitly also works, and is the way to force the call.

Connecting

One server URL covers every skill in the catalog, including this one. Authorization is OAuth: the client opens a browser once, and there is no key to paste into a config file.

{
  "mcpServers": {
    "vervekit": {
      "url": "https://api.vervekit.com/v1/mcp"
    }
  }
}

Per-client setup — Claude, Cursor, VS Code, ChatGPT — is on the MCP setup page.

Arguments

These are the properties on the tool's inputSchema, so a well-behaved client validates them before the call is made. Premium arguments are accepted on every plan but only take effect on plans that include them.

ArgumentTypeDescription
csvRequiredstringThe CSV data to convert to JSON
delimiterOptionalstringThe delimiter used in the CSV
,;\t|
default ,
has_headerOptionalbooleanWhether the first row contains column headers (default: true)
default true

What the model gets back

The result carries a structuredContent object matching the tool's declared outputSchema, so a client reads fields without parsing prose. status is "ok" and error is null on success; a null field means the value was not available for that input, not that the call failed.

Result
{
  "status": "ok",
  "error": null,
  "data": {
    "row_count": 2,
    "column_count": 3,
    "columns": [
      "name",
      "age",
      "city"
    ],
    "inferredTypes": {
      "name": "string",
      "age": "integer",
      "city": "string"
    },
    "json": [
      {
        "name": "John Doe",
        "age": "30",
        "city": "New York"
      },
      {
        "name": "Jane Smith",
        "age": "25",
        "city": "Los Angeles"
      }
    ]
  }
}

Response fields

Paths are relative to data. Premium fields are absent rather than zeroed on plans that do not include them, so check for presence instead of comparing to 0.

FieldTypeExampleDescription
row_countnumber2Number of data rows in the converted JSON
column_countnumber3Number of columns detected in the CSV
columnsarray["name","age","city"]Array of column names from header or auto-generated
inferredTypesPremiumobject{…}Detected data type for each column (integer, float, boolean, date, email, string)
inferredTypes.namePremiumstringstring
inferredTypes.agePremiumstringinteger
inferredTypes.cityPremiumstringstring
jsonarray[2]The converted CSV data as an array of JSON objects
json.0.namestringJohn Doe
json.0.agestring30
json.0.citystringNew York

Failure modes

Errors come back as tool errors carrying a sentence the model can act on, not a bare status code. Error handling covers the full list.

StatusWhat it means
400 / 422The arguments did not validate. The message names the offending one.
401The OAuth session is invalid or expired — reconnect the server.
403Blocked by a key restriction or an IP allow-list. Never a bad identity.
404This skill is not part of VerveKit. Check the catalog.
429Out of credits, or a brief rate limit. The message tells them apart.

A call costs 2 credits each time the tool actually runs; a model that reasons about the tool without calling it costs nothing.

Use cases

Data Migration
Convert CSV exports from legacy systems to JSON format for modern API integration and database imports
API Integration
Transform CSV data into JSON format for RESTful API consumption and web application processing
Data Analysis
Convert CSV datasets to JSON for easier manipulation in JavaScript, Python, or data analysis tools
File Processing
Automate batch conversion of CSV files to JSON for data pipelines and ETL workflows

Other ways to use CSV to JSON Skill

Set up CSV to JSON Skill on VerveKit, or reach the same source a different way. Your VerveKit account and credits work on all of them — one key, one balance.

Call it as a REST APIOne HTTPS endpoint and an x-api-key header, with SDKs for Node, Python and .NET.APIVerve →Reference →
Google Sheets or ExcelA =VERVE() formula fills a column — no script, no export, recalculates in place.VerveSheets →Reference →

More in Data Conversion:

Was this page helpful?