> ## Documentation Index > Fetch the complete documentation index at: https://docs.iotools.cloud/llms.txt > Use this file to discover all available pages before exploring further. # CSV Profiler > Profile a CSV file column by column — inferred type, empty and distinct counts, value range, mean and the most common value — plus a data-quality report naming ragged rows, duplicate rows, mixed-type columns and candidate primary keys. Detects the delimiter automatically and runs entirely in your browser. [Try CSV Profiler in your browser →](https://iotools.cloud/tool/csv-profiler/) ## OpenAPI ````yaml https://api.iotools.cloud/v1/openapi post /v1/tool/csv-profiler openapi: 3.1.0 info: title: iotools.cloud API version: 1.0.0 description: >- Run any iotools.cloud tool over HTTP. Authenticate with `Authorization: Bearer iot_live_…`. **Only `POST /v1/tool/{slug}` costs credits.** Every GET here — the catalog, a tool's schema, your balance — is free. A tool call is charged its own weight or your plan's per-call minimum, whichever is larger; `x-iotools-credit-cost` on each operation is quoted at the free-tier minimum, and `GET /v1/tools/list` returns the exact figure for your key. `GET /v1/me/credits` reports what you have left, and `GET /v1/me/usage` reports what it went on. Failures are RFC 9457 problem documents — branch on `code`. servers: - url: https://api.iotools.cloud description: Production security: - bearerAuth: [] tags: - name: Catalog description: Find a tool and read its contract. Free. - name: Converters description: >- Convert between formats, encodings, and units — Base64, CSV and JSON, timestamps, and more. Fast, free, and processed right in your browser. - name: Formatters description: >- Format, beautify, minify, and validate code and data — JSON, HTML, CSS, SQL, and regex. Clean up messy input in one click, with nothing to upload. - name: Generators description: >- Generate exactly what you need and on demand — passwords, UUIDs, QR codes, hashes, random numbers, and more. Secure, instant, and free. - name: Calculators description: >- Crunch the numbers fast — from everyday math to specialized conversions and unit work. Free online calculators that run entirely in your browser. - name: Editors description: >- Edit and transform text, code, and images with quick, focused editors that run entirely in your browser — nothing to install, and no sign-up needed. - name: Utilities description: >- Everyday developer and web utilities — DNS and IP lookups, redirect and certificate checkers, and other quick diagnostics. Free and privacy-friendly. - name: Account description: Your key's allowance, limits and usage history. paths: /v1/tool/csv-profiler: post: tags: - Utilities summary: CSV Profiler description: >- Profile a CSV file column by column — inferred type, empty and distinct counts, value range, mean and the most common value — plus a data-quality report naming ragged rows, duplicate rows, mixed-type columns and candidate primary keys. Detects the delimiter automatically and runs entirely in your browser. [Try CSV Profiler in your browser →](https://iotools.cloud/tool/csv-profiler/) operationId: run_csv_profiler requestBody: required: false content: application/json: schema: type: object properties: csvSource: type: string description: CSV Input delimiter: enum: - auto - ',' - ; - tab - '|' description: Delimiter firstRowHeaders: type: boolean description: First row contains headers trimValues: type: boolean description: Trim whitespace around values required: [] examples: saas_customer_export_mixed_types_gaps_repeated_values: summary: SaaS customer export (mixed types, gaps, repeated values) value: csvSource: |- id,name,signup_date,plan,seats,mrr,churned 1,Acme Corp,2024-01-15,pro,25,499.00,false 2,Globex,2024-02-03,free,3,0,false 3,Initech,2024-02-28,pro,12,499.00,true 4,Umbrella,2024-03-11,enterprise,140,2400.50,false 5,Hooli,,pro,8,499.00,false 6,Vehement,2024-04-02,free,1,0,true 7,Soylent,2024-04-19,enterprise,,2400.50,false 8,Massive Dynamic,2024-05-06,pro,31,499.00,false delimiter: auto firstRowHeaders: 'true' trimValues: 'true' semicolon_delimited_file_with_a_ragged_row_and_a_duplicate: summary: Semicolon-delimited file with a ragged row and a duplicate value: csvSource: | city;country;population Paris;FR;2148000 Lyon;FR Paris;FR;2148000 Berlin;DE;3645000 delimiter: ; firstRowHeaders: 'true' trimValues: 'true' no_header_row_columns_profiled_positionally: summary: No header row — columns profiled positionally value: csvSource: | alpha,1,2024-01-01 beta,2,2024-02-01 gamma,3,2024-03-01 delimiter: ',' firstRowHeaders: '' trimValues: 'true' responses: '200': description: Tool output content: application/json: examples: saas_customer_export_mixed_types_gaps_repeated_values: summary: SaaS customer export (mixed types, gaps, repeated values) value: tool: csv-profiler tool_version: 1.0.1 outputs: overview: - metric: Rows value: '8' - metric: Columns value: '7' - metric: Delimiter value: Comma (,) (auto-detected) - metric: Header row value: 'Yes' - metric: Empty cells value: 2 of 56 (3.6%) - metric: Duplicate rows value: '0' - metric: Ragged rows value: '0' profile: - index: '1' column: id type: integer non-empty: '8' empty: '0' distinct: '8' range: 1 → 8 mean: '4.5' most-common: '' - index: '2' column: name type: text non-empty: '8' empty: '0' distinct: '8' range: 5 → 15 chars mean: 8.125 chars most-common: '' - index: '3' column: signup_date type: date non-empty: '7' empty: 1 (12.5%) distinct: '7' range: 2024-01-15 → 2024-05-06 mean: '' most-common: '' - index: '4' column: plan type: text non-empty: '8' empty: '0' distinct: '3' range: 3 → 10 chars mean: 5 chars most-common: pro (4×) - index: '5' column: seats type: integer non-empty: '7' empty: 1 (12.5%) distinct: '7' range: 1 → 140 mean: '31.4286' most-common: '' - index: '6' column: mrr type: number non-empty: '8' empty: '0' distinct: '3' range: 0 → 2400.5 mean: '849.625' most-common: 499.00 (4×) - index: '7' column: churned type: boolean non-empty: '8' empty: '0' distinct: '2' range: '' mean: '' most-common: false (6×) issues: >- • Column "id" is 100% distinct — a candidate primary key. • Column "name" is 100% distinct — a candidate primary key. • Column "signup_date" is 12.5% empty (1 of 8 rows). • Column "seats" is 12.5% empty (1 of 8 rows). credits_used: 3 credits_remaining: null semicolon_delimited_file_with_a_ragged_row_and_a_duplicate: summary: Semicolon-delimited file with a ragged row and a duplicate value: tool: csv-profiler tool_version: 1.0.1 outputs: overview: - metric: Rows value: '4' - metric: Columns value: '3' - metric: Delimiter value: Semicolon (;) - metric: Header row value: 'Yes' - metric: Empty cells value: 1 of 12 (8.3%) - metric: Duplicate rows value: '1' - metric: Ragged rows value: '1' profile: - index: '1' column: city type: text non-empty: '4' empty: '0' distinct: '3' range: 4 → 6 chars mean: 5 chars most-common: Paris (2×) - index: '2' column: country type: text non-empty: '4' empty: '0' distinct: '2' range: 2 → 2 chars mean: 2 chars most-common: FR (3×) - index: '3' column: population type: integer non-empty: '3' empty: 1 (25%) distinct: '2' range: 2148000 → 3645000 mean: '2647000' most-common: 2148000 (2×) issues: >- • 1 row does not have 3 fields — the file is ragged, which usually means an unescaped delimiter or line break. • 1 duplicate row is an exact copy of an earlier row. • Column "population" is 25% empty (1 of 4 rows). credits_used: 3 credits_remaining: null no_header_row_columns_profiled_positionally: summary: No header row — columns profiled positionally value: tool: csv-profiler tool_version: 1.0.1 outputs: overview: - metric: Rows value: '3' - metric: Columns value: '3' - metric: Delimiter value: Comma (,) - metric: Header row value: 'No' - metric: Empty cells value: 0 of 9 (0%) - metric: Duplicate rows value: '0' - metric: Ragged rows value: '0' profile: - index: '1' column: Column 1 type: text non-empty: '3' empty: '0' distinct: '3' range: 4 → 5 chars mean: 4.6667 chars most-common: '' - index: '2' column: Column 2 type: integer non-empty: '3' empty: '0' distinct: '3' range: 1 → 3 mean: '2' most-common: '' - index: '3' column: Column 3 type: date non-empty: '3' empty: '0' distinct: '3' range: 2024-01-01 → 2024-03-01 mean: '' most-common: '' issues: No data-quality issues detected. credits_used: 3 credits_remaining: null schema: type: object required: - tool - tool_version - outputs - credits_used - credits_remaining properties: outputs: type: object properties: overview: type: array description: Dataset overview items: type: object properties: metric: type: string description: Metric value: type: string description: Value x-iotools-columns: - metric - value profile: type: array description: Column profile items: type: object properties: index: type: string description: '#' column: type: string description: Column type: type: string description: Type non-empty: type: string description: Non-empty empty: type: string description: Empty distinct: type: string description: Distinct range: type: string description: Range mean: type: string description: Mean most-common: type: string description: Most common x-iotools-columns: - index - column - type - non-empty - empty - distinct - range - mean - most-common issues: type: string description: Data-quality report tool: type: string description: The tool's slug, echoing the {slug} in the request path. tool_version: type: string description: Output-contract version for this tool. credits_used: type: integer description: >- Credits this call consumed, after any settlement refund. 0 when metering is disabled. credits_remaining: type: - integer - 'null' description: >- Credits left in the current monthly allowance, or null when metering is disabled. request_id: type: string description: Correlation id, also sent as x-request-id. '400': $ref: '#/components/responses/ValidationError' '401': $ref: '#/components/responses/Unauthorized' '402': $ref: '#/components/responses/InsufficientCredits' '403': $ref: '#/components/responses/ToolNotAllowed' '404': $ref: '#/components/responses/ToolNotFound' '413': $ref: '#/components/responses/PayloadTooLarge' '429': $ref: '#/components/responses/RateLimited' '500': $ref: '#/components/responses/ToolFailed' '503': $ref: '#/components/responses/ToolDisabled' security: - bearerAuth: [] components: responses: ValidationError: description: Invalid request. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/validation_error title: type: string description: Short human-readable summary of the failure. examples: - Invalid request status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - validation_error detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. fields: type: - object - string additionalProperties: type: string description: >- What failed: a map of field name → message. Absent when the body itself is malformed; a single string when the failure isn't tied to one field. example: type: https://iotools.cloud/docs/errors/validation_error title: Invalid request status: 400 code: validation_error detail: One or more inputs are invalid — see `fields`. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 fields: inputString: Required Unauthorized: description: Missing or invalid API key. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/invalid_api_key title: type: string description: Short human-readable summary of the failure. examples: - Invalid API key status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - invalid_api_key detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. example: type: https://iotools.cloud/docs/errors/invalid_api_key title: Invalid API key status: 401 code: invalid_api_key detail: 'Provide ''Authorization: Bearer ''.' request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 InsufficientCredits: description: Monthly credit allowance exhausted. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/insufficient_credits title: type: string description: Short human-readable summary of the failure. examples: - Insufficient credits status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - insufficient_credits detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. credits_used: type: integer description: Always 0 — a refused call charges nothing. credits_remaining: type: integer description: Credits left in the allowance — fewer than this call costs. example: type: https://iotools.cloud/docs/errors/insufficient_credits title: Insufficient credits status: 402 code: insufficient_credits detail: This call costs 1 credit and 0 remain in this month's allowance. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 credits_used: 0 credits_remaining: 0 ToolNotAllowed: description: Tool exists but has no API surface. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/tool_not_allowed title: type: string description: Short human-readable summary of the failure. examples: - Tool not available over the API status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - tool_not_allowed detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. example: type: https://iotools.cloud/docs/errors/tool_not_allowed title: Tool not available over the API status: 403 code: tool_not_allowed detail: >- "Background Remover" is available on iotools.cloud but has no API endpoint. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 ToolNotFound: description: No such tool. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/tool_not_found title: type: string description: Short human-readable summary of the failure. examples: - Tool not found status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - tool_not_found detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. example: type: https://iotools.cloud/docs/errors/tool_not_found title: Tool not found status: 404 code: tool_not_found detail: No tool with that slug. See GET /v1/tools/list. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 PayloadTooLarge: description: Body too large. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/payload_too_large title: type: string description: Short human-readable summary of the failure. examples: - Payload too large status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - payload_too_large detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. example: type: https://iotools.cloud/docs/errors/payload_too_large title: Payload too large status: 413 code: payload_too_large detail: Request body exceeds this tool's size limit. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 RateLimited: description: Per-minute rate limit exceeded. headers: Retry-After: description: Seconds to wait before retrying (RFC 9110 delta-seconds). schema: type: integer content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/rate_limited title: type: string description: Short human-readable summary of the failure. examples: - Rate limit exceeded status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - rate_limited detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. retry_after: type: integer description: >- Seconds until the window resets — the same value as the `Retry-After` header. example: type: https://iotools.cloud/docs/errors/rate_limited title: Rate limit exceeded status: 429 code: rate_limited detail: Too many requests. Retry in 30s. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 retry_after: 30 ToolFailed: description: Tool failed to run. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/processing_error - https://iotools.cloud/docs/errors/internal_error title: type: string description: Short human-readable summary of the failure. examples: - Tool failed to run - Internal error status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - processing_error - internal_error detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. credits_used: type: integer description: >- Always 0 on `processing_error` — a failed run is refunded, floor included. credits_remaining: type: integer description: >- Credits left after the refund. Absent when metering is disabled. example: type: https://iotools.cloud/docs/errors/processing_error title: Tool failed to run status: 500 code: processing_error detail: The tool failed to run. Please try again. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 credits_used: 0 ToolDisabled: description: Tool temporarily disabled. content: application/problem+json: schema: type: object description: >- RFC 9457 problem document, served as application/problem+json. Branch on `code`; `title` is human prose and may be reworded without notice. Some failures add extension members — `fields` on validation errors, `retry_after` on 429s, `credits_used`/`credits_remaining` on billing-adjacent failures — documented on the responses that carry them. required: - type - title - status - code properties: type: type: string format: uri description: Stable documentation URI for this failure. examples: - https://iotools.cloud/docs/errors/tool_disabled - https://iotools.cloud/docs/errors/api_unconfigured title: type: string description: Short human-readable summary of the failure. examples: - Tool temporarily disabled - API not configured status: type: integer description: HTTP status code, matching the response's own status. code: type: string description: >- Stable machine-readable error code — branch on this, not `title`. enum: - tool_disabled - api_unconfigured detail: type: string description: Human explanation of this occurrence. request_id: type: string description: Correlation id, also sent as x-request-id. example: type: https://iotools.cloud/docs/errors/tool_disabled title: Tool temporarily disabled status: 503 code: tool_disabled detail: This tool is temporarily unavailable. Try again shortly. request_id: e4042b29-8f1e-4c7a-9b52-6f0d1a3c7e11 securitySchemes: bearerAuth: type: http scheme: bearer bearerFormat: iot_live_… ````