Elysia Tools Docs
EN
Language
ZHESPTRUFRDEEN
Back to site
Browse tools

Development

CSV Header Alias Resolver

Map messy CSV headers onto a clean target schema. Paste a CSV whose first row holds inconsistent column names (Customer ID, user_id, customerId, CUST_ID…) plus your target schema (one column per line) and an optional "alias=target" dictionary. Each source header is resolved through four layered passes — exact, dictionary, normalized (strips case/accents/separators/camelCase), then fuzzy edit-distance — and shown in a mapping table with method and confidence, plus target coverage and an optional normalized CSV export.

html· HTML resultOpen tool

Quick start

Call this tool from your code in three languages.

cURL
curl -X POST 'https://api.elysiatools.com/en/api/tools/csv-header-alias-resolver' \
  -H 'Content-Type: application/json' \
  -d '{"csvInput":"CUST_ID,First Name,e-mail,Phone Number\n1,Ada,[email protected],+1-555\n2,Linus,[email protected],+1-556","delimiter":",","targetSchema":"customerId\nfirstName\nemail\nphone","aliasDict":"cust id=customerId\ncustomer id=customerId\nphone number=phone","threshold":"0.8","outputCsv":true}'

API reference

Send a POST request with your inputs as JSON. File parameters require a separate upload first.

Endpoint

HTTP
POST https://api.elysiatools.com/en/api/tools/csv-header-alias-resolver

Parameters

NameTypeRequiredDescription
csvInputtextareaYes—
delimiterselectNo—
targetSchematextareaYes—
aliasDicttextareaNo—
thresholdselectNo—
outputCsv

© 2026 Elysia Tools. Developer documentation.

Back to siteBrowse tools
checkbox
No
—

Response format

HTML result

JSON
{
  "result": "<div>Processed HTML content</div>",
  "error": "Error message (optional)",
  "message": "Notification message (optional)",
  "metadata": {
    "key": "value"
  }
}

MCP integration

Add this tool to your Model Context Protocol server so AI agents can list and call it.

Server configuration

Add this block to your MCP client configuration:

mcp.json
{
  "mcpServers": {
    "elysiatools-csv-header-alias-resolver": {
      "name": "csv-header-alias-resolver",
      "description": "Map messy CSV headers onto a clean target schema. Paste a CSV whose first row holds inconsistent column names (Customer ID, user_id, customerId, CUST_ID…) plus your target schema (one column per line) and an optional \"alias=target\" dictionary. Each source header is resolved through four layered passes — exact, dictionary, normalized (strips case/accents/separators/camelCase), then fuzzy edit-distance — and shown in a mapping table with method and confidence, plus target coverage and an optional normalized CSV export.",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=csv-header-alias-resolver",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

List available tools

After connecting to the SSE endpoint, list the exposed tools:

tools/list
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

Call this tool

Invoke the tool by its id, passing arguments built from its parameters:

tools/call
{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "csv-header-alias-resolver",
    "arguments": {
  "csvInput": "CUST_ID,First Name,e-mail,Phone Number\n1,Ada,[email protected],+1-555\n2,Linus,[email protected],+1-556",
  "delimiter": ",",
  "targetSchema": "customerId\nfirstName\nemail\nphone",
  "aliasDict": "cust id=customerId\ncustomer id=customerId\nphone number=phone",
  "threshold": "0.8",
  "outputCsv": true
}
  }
}
Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).

Questions or issues? Contact [email protected]

Browse tools
Open tool