CSV Normalize

data.csv_normalize

ProductionBounded custom (Class B)Deterministicstrictfastv1.0.0

File inputNo network

Overview

When you send messy CSV (inline or file_ref), we detect the delimiter, normalize headers, trim whitespace, enforce column consistency, and render clean RFC 4180 output with a SHA-256 checksum and structured report. Large output can spill to file_ref automatically. Do not use this for type validation, JSON conversion, or files above your max_bytes limit.

Spreadsheet exports arrive with inconsistent delimiters and headers. We normalize deterministically and give you a checksum.

Reliability

STRICT and deterministic — identical input and options yield identical output and checksum. CSV_MALFORMED (retryable after fixing structure; unchanged broken CSV will not succeed): unparseable rows or column mismatch — inspect delimiter, quotes, and row widths, then retry. Size or row limit violations are input validation errors (not retryable until you lower max_rows/max_bytes or split the file). Output over 100KB spills to file_ref unless you set outputToFile explicitly.

Context footprint

Inline input up to default 2MB; optional file_ref read up to 5MB; output may return normalized_csv or file_ref plus download_url. A successful call costs 2 execution credits.

When to use it

When you receive messy CSV and need a canonical form before further processing.

When the file is already clean or exceeds your max_bytes setting.

Scope

Note

Canonicalizes messy CSV with delimiter detection, header cleanup, and a checksum.

Non-goals

Does not validate data types
Does not convert to JSON
Does not infer business rules

Properties

IdempotentRetry safeStreaming supportedFile input supportedRequires external service

Capabilities

data-transformationnormalizationparsing

Cost & billing

Flat rate per invocation

MetercallsBillable onsuccessCost per call2 credits

File handling

Accepts file_refProduces file_refMax input1.9 MBMax file size4.8 MB

File limits

Constraints this skill applies to your input and generated files. The “Limited by” column shows the static source of each cap; none of these can be raised by upgrading your plan.

Limit	Value	Limited by
Maximum size per input file	4.8 MiB	Skill maximum

How we handle your data

Sensitive output possible

What this means

This skill may receive sensitive content and may return submitted, transformed, extracted, or reformatted content.

Squillify guarantees

Runs inside Squillify
This skill runs inside Squillify.
Payloads are not sent to an external service by this skill.
Squillify does not permanently store submitted payloads.
Telemetry records metadata only, not submitted content.
Submitted payloads are not used for training.
Submitted payloads are not reviewed by humans.
This skill does not target sensitive data.
The response may contain submitted or transformed content.

Your responsibility

Squillify does not determine whether submitted content is sensitive. Your application is responsible for deciding what data it is allowed to submit. Your application is responsible for securing the response.

Read the Microskill Data Handling Policy

Input schema

Field	Type	Required	Description
csv	string	No	Bounded inline CSV source. Required unless file_ref is provided.
file_ref	string	No	Tenant-scoped uploaded CSV reference. Omit it to use the required inline csv; never send both.
delimiter	string	No	Input delimiter detector; omit it for auto.
output_delimiter	string	No	Output delimiter; omit it for comma.
has_header	boolean	No	Whether the first row is a header; omit it for true.
header_strategy	string	No	How header names are rewritten; omit it for normalize.
trim_whitespace	boolean	No	Whether fields are trimmed; omit it for true.
quote_policy	string	No	When fields are quoted; omit it for minimal.
empty_value_policy	string	No	How empty fields are rendered; omit it for keep_empty.
null_string	string	No	Replacement for empty fields when empty_value_policy is null_string; omit it for empty.
line_ending	string	No	Output line ending; omit it for lf.
max_rows	integer	No	Maximum data rows; omit it for 20000.
max_bytes	integer	No	Maximum input size in bytes; omit it for 2000000.
strict	boolean	No	Whether warnings fail the call; omit it for false.
outputToFile	boolean	No	Whether to store the result as a file; omit it for false, and large output still spills automatically.

Output schema

Field	Type	Required	Description
normalized_csv	string	No	Cleaned CSV as one string; omitted when the result went to storage.
file_ref	string	No	Stored cleaned file reference; omitted when the result came back inline.
download_url	string	No	Short-lived fetch URL present only alongside file_ref.
size_bytes	integer	No	Stored file size in bytes, present only alongside file_ref.
checksum_sha256	string	Yes	SHA-256 of the cleaned bytes as lowercase hex.
report	object	Yes	Closed canonicalization report covering detected delimiter, headers, row counts, and checksum.

API contract

POST /v1/execute

curl

curl -sS -X POST "$BASE/v1/execute" -H "Authorization: Bearer $KEY" -H 'Content-Type: application/json' -d '{"skillKey":"data.csv_normalize","input":{"csv":"name;age\nAlice;30"}}'

Integrations

TypeScript SDK

import { Squillify } from "@squillify/sdk";

const sq = new Squillify({ apiKey: process.env.SQUILLIFY_API_KEY });

const { output } = await sq.execute("data.csv_normalize", {"csv":"Product Name;Unit Price;Qty\n\"Widget A\";19.99;150\nWidget B;5.50;1200"});

Errors

Code	HTTP	Retryable	Description
VALIDATION_ERROR	400	No	The request payload failed schema validation.
UNAUTHORIZED	401	No	Missing or invalid API key.
SKILL_NOT_ACCESSIBLE	403	No	The API key is not granted access to this skill.
SKILL_NOT_AVAILABLE_FOR_PLAN	403	No	This skill is not included in your current plan.
PLAN_ELIGIBILITY_UNAVAILABLE	503	Yes	Plan eligibility could not be decided. Retry after backoff.
SKILL_NOT_FOUND	404	No	The requested skill or version does not exist.
TENANT_RATE_LIMITED	429	Yes	Request rate limit exceeded. Retry after backoff.
QUOTA_EXCEEDED	429	Yes	Plan quota exhausted. Retryable once the quota period resets.
EXECUTION_TIMEOUT	504	Yes	Execution exceeded the allowed time budget.
CSV_MALFORMED	400	No	The request payload failed this skill's input validation.

Other limits

Limit	Value
Recommended inline bytes	32 KiB

Limitations

Does not validate data types
Does not convert to JSON
Does not infer business rules
Schema or type validation
Files larger than max_bytes

How to call

POST /v1/execute (requires authentication)

Request bodyjson

{
  "skillKey": "data.csv_normalize",
  "input": {
    "csv": "Product Name;Unit Price;Qty\n\"Widget A\";19.99;150\nWidget B;5.50;1200"
  }
}

Examples

Semicolon export normalized to comma CSV

Inputjson

{
  "csv": "Product Name;Unit Price;Qty\n\"Widget A\";19.99;150\nWidget B;5.50;1200"
}

Expected outputjson

{
  "normalized_csv": "product_name,unit_price,qty\nWidget A,19.99,150\nWidget B,5.50,1200\n",
  "checksum_sha256": "72c8d7ab64b1df3ad32bf33ad4eac738fd08743a4100b200c4932a6dbcacca71",
  "report": {
    "detected_delimiter": "semicolon",
    "output_delimiter": "comma",
    "has_header": true,
    "header_strategy": "normalize",
    "columns": [
      "product_name",
      "unit_price",
      "qty"
    ],
    "column_count": 3,
    "row_count_in": 2,
    "row_count_out": 2,
    "skipped_rows": 0,
    "padded_rows": 0,
    "merged_rows": 0,
    "truncated": false,
    "warnings": [],
    "checksum_sha256": "72c8d7ab64b1df3ad32bf33ad4eac738fd08743a4100b200c4932a6dbcacca71"
  }
}

Tab-separated input with explicit delimiter