CSV profiler
Summarise each CSV column: type, blanks, distinct values, min, max, mean and top values.
Input
Result
Fill in the input and press Run.
Your input is processed in memory and then discarded. It is not stored or logged. Even so, don't paste live passwords or keys into any online tool.
Use it from code or an agent
curl -s https://setget.net/v1/tools/csv-profile \
-H 'Content-Type: application/json' \
-d '{"input":{"text":"city,temp\nOslo,4\nRome,18\nOslo,"}}'
import json, urllib.request
body = {'input': {'text': 'city,temp\nOslo,4\nRome,18\nOslo,'}}
request = urllib.request.Request("https://setget.net/v1/tools/csv-profile", json.dumps(body).encode(),
{"Content-Type": "application/json"})
print(json.load(urllib.request.urlopen(request))["result"])
const response = await fetch("https://setget.net/v1/tools/csv-profile", {
method: "POST",
headers: {"Content-Type": "application/json"},
body: JSON.stringify({"input":{"text":"city,temp\nOslo,4\nRome,18\nOslo,"}}),
});
console.log((await response.json()).result);
Tool: run_tool
Arguments:
{
"slug": "csv-profile",
"input": {
"text": "city,temp\nOslo,4\nRome,18\nOslo,"
}
}
{
"input": {
"text": "city,temp\nOslo,4\nRome,18\nOslo,"
}
}
Endpoint: POST /v1/tools/csv-profile. Over MCP: run_tool with slug: "csv-profile".
Machine-readable: input schema, Markdown. Connect an agent.
Inputs
| Name | Type | Required | What it does |
|---|---|---|---|
text |
string | yes | The CSV to profile. |
delimiter |
string | no | Column separator. "auto" detects it from the first line. One of: auto, comma, tab, semicolon, pipe. Default: "auto". |
Example
Input
{
"text": "city,temp\nOslo,4\nRome,18\nOslo,"
}Result
{
"rows": 3,
"columns": [
{
"name": "city",
"type": "text",
"blank": 0,
"distinct": 2,
"top": [
[
"Oslo",
2
],
[
"Rome",
1
]
]
},
{
"name": "temp",
"type": "number",
"blank": 1,
"distinct": 2,
"min": 4,
"max": 18,
"mean": 11.0,
"top": [
[
"4",
1
],
[
"18",
1
]
]
}
]
}Related tools
- CSV to JSONTurn CSV rows into a JSON array of objects, detecting numbers, booleans and blanks.
csv-to-json - CSV sort, filter and dedupeSort CSV by a column, keep rows containing some text, pick columns and remove duplicate rows.
csv-sort-filter-dedupe - .env to JSONParse a .env file into a JSON object, handling quotes, comments and "export" prefixes.
env-to-json - CSV to Markdown tableTurn CSV into a Markdown table ready to paste into a README, issue or chat.
csv-to-markdown-table - CSV transposeSwap the rows and columns of a CSV table.
csv-transpose - JSON diffCompare two JSON documents and get the differences as a JSON Patch (RFC 6902).
json-diff