CSV Cleanup and Column Mapping API analyzes, validates, maps, previews, and cleans CSV data for import preparation.
The API handles CSV structure, row count, column count, detected headers, duplicate headers, blank headers, missing expected fields, column type detection, email-like values, integer-like values, float-like values, boolean-like values, empty values, required field validation, row-level validation errors, column mapping suggestions, source-to-target field mapping, cleaned CSV output, preview rows, warnings, validation status, usage status, safety notes, and disclaimer.
The API returns CSV analysis results, row count, column count, detected columns, duplicate headers, blank headers, column type guesses, missing expected fields, validation status, row-level errors, warnings, column mapping output, cleaned CSV text, preview rows, normalized import-preparation output, and technical disclaimer.
This API is useful for SaaS builders, CRM platforms, data operations teams, marketing operations teams, sales operations teams, agencies, developers, backend teams, frontend teams, QA teams, ecommerce platforms, lead import services, customer import services, CSV import services, no-code platforms, internal tooling teams, B2B software teams, analytics teams, automation platforms, data onboarding teams, RevOps teams, business operations teams, spreadsheet-heavy teams, developer platforms, lightweight ETL services, and workflow automation services.
The API processes CSV text submitted in API requests and returns technical analysis, validation, mapping, preview, and cleanup results. It does not hack, brute force, attempt logins, scan private systems, scrape restricted content, change customer data, send emails, create calendar events, import data into third-party systems, approve or reject data, verify tax accuracy, verify accounting accuracy, verify legal accuracy, or verify compliance accuracy. It does not replace human review of cleaned data, a full ETL platform, a data warehouse, or professional data engineering review.
{"ok":true,"rowCount":2,"columnCount":3,"originalHeaders":["name","email","age"],"normalizedHeaders":["name","email","age"],"duplicateHeaders":[],"blankHeaders":[],"inferredDataTypes":{"name":"string","email":"email-like","age":"integer"},"missingExpectedFields":[],"recommendations":["CSV structure looks ready for basic import checks."],"warnings":[],"disclaimer":"This API analyzes and transforms CSV text for import preparation. Review cleaned data before using it in production systems."}
curl --location --request POST 'https://zylalabs.com/api/12804/csv+cleanup+and+column+mapping+api/25192/analyze+csv' --header 'Authorization: Bearer YOUR_API_KEY'
--data-raw '{
"csvText": "name,email,age\nAlice,[email protected],31\nBob,[email protected],42"
}'
{"ok":true,"suggestedMapping":[{"targetField":"first_name","sourceColumn":"First Name","normalizedSourceColumn":"first_name","score":1.0},{"targetField":"email","sourceColumn":"Email Address","normalizedSourceColumn":"email_address","score":0.75},{"targetField":"phone_number","sourceColumn":"Phone","normalizedSourceColumn":"phone","score":0.75}],"unmappedSourceColumns":[],"missingTargetFields":[],"warnings":[],"disclaimer":"This API analyzes and transforms CSV text for import preparation. Review cleaned data before using it in production systems."}
curl --location --request POST 'https://zylalabs.com/api/12804/csv+cleanup+and+column+mapping+api/25193/map+columns' --header 'Authorization: Bearer YOUR_API_KEY'
--data-raw '{
"csvText": "First Name,Email Address,Phone\nAlice,[email protected],555-1111",
"targetFields": [
"first_name",
"email",
"phone_number"
]
}'
{"ok":true,"validRowsCount":1,"invalidRowsCount":1,"rowErrors":[{"rowNumber":3,"column":"email","rule":"required","valuePreview":""}],"warnings":["Some rows failed validation."],"disclaimer":"This API analyzes and transforms CSV text for import preparation. Review cleaned data before using it in production systems."}
curl --location --request POST 'https://zylalabs.com/api/12804/csv+cleanup+and+column+mapping+api/25194/validate+rows' --header 'Authorization: Bearer YOUR_API_KEY'
--data-raw '{
"csvText": "name,email,age\nAlice,[email protected],31\nBob,,42",
"rules": {
"name": {
"required": true
},
"email": {
"required": true
}
}
}'
{"ok":true,"normalizedHeaders":["first_name","email"],"cleanedRows":[{"first_name":"Alice","email":"[email protected]"},{"first_name":"Bob","email":""}],"importReadyCsvText":"first_name,email\nAlice,[email protected]\nBob,\n","warnings":["Some rows failed validation during cleaning.","Row 3: email failed required"],"disclaimer":"This API analyzes and transforms CSV text for import preparation. Review cleaned data before using it in production systems."}
curl --location --request POST 'https://zylalabs.com/api/12804/csv+cleanup+and+column+mapping+api/25195/clean+csv' --header 'Authorization: Bearer YOUR_API_KEY'
--data-raw '{
"csvText": "First Name,Email Address\nAlice,[email protected]\nBob,",
"mapping": {
"First Name": "first_name",
"Email Address": "email"
},
"rules": {
"email": {
"required": true
}
}
}'
{"ok":true,"firstRows":[{"name":"Alice","email":"[email protected]"},{"name":"Bob","email":"[email protected]"},{"name":"Cara","email":"[email protected]"}],"detectedHeaders":["name","email"],"normalizedPreview":[{"name":"Alice","email":"[email protected]"},{"name":"Bob","email":"[email protected]"},{"name":"Cara","email":"[email protected]"}],"issuesSummary":{"rowCount":3,"columnCount":2,"duplicateHeaders":[],"blankHeaders":[],"hasIssues":false},"disclaimer":"This API analyzes and transforms CSV text for import preparation. Review cleaned data before using it in production systems."}
curl --location --request POST 'https://zylalabs.com/api/12804/csv+cleanup+and+column+mapping+api/25196/csv+preview' --header 'Authorization: Bearer YOUR_API_KEY'
--data-raw '{
"csvText": "name,email\nAlice,[email protected]\nBob,[email protected]\nCara,[email protected]"
}'
| Header | Description |
|---|---|
Authorization
|
[Required] Should be Bearer access_key. See "Your API Access Key" above when you are subscribed. |
No long-term commitment. Upgrade, downgrade, or cancel anytime. Free Trial includes up to 50 requests.
Each endpoint returns structured data related to CSV analysis, column mapping, validation, preview, and cleaning. Responses may include row and column counts, detected headers, duplicate headers, blank headers, column type guesses, mapping suggestions, row-level errors, cleaned CSV text, preview rows, warnings, and disclaimers.
Key fields include `rowCount`, `columnCount`, `originalHeaders`, `normalizedHeaders`, `validRowsCount`, `invalidRowsCount`, and `cleanedRows`. These fields provide insights into the CSV structure and validation status.
Parameters vary by endpoint but generally include the CSV text to analyze, mapping specifications for columns, and validation rules for rows. Users can customize requests by specifying the CSV content and desired mapping fields.
Response data is organized in JSON format, with a top-level `ok` field indicating success, followed by relevant data fields such as counts, headers, and validation results. This structure allows easy parsing and integration into applications.
Typical use cases include preparing CSV files for import, checking required fields before processing, finding duplicate or blank headers, previewing rows, and mapping source columns to target fields for CSV import workflows.
The API performs technical checks on submitted CSV text, including required field validation, type guesses, duplicate header detection, blank header detection, and row-level validation. Results may include warnings and errors for items that need review before import.
Users can review validation results, row-level errors, warnings, mapping suggestions, preview rows, and cleaned CSV output to decide what needs review before import. The returned data can support CSV import preparation, but it does not guarantee acceptance by a destination system.
Standard data patterns include row and column counts, detected headers, normalized headers, type guesses, missing expected fields, duplicate headers, blank headers, row-level validation errors, preview rows, cleaned CSV text, warnings, and disclaimers.
The Analyze CSV endpoint provides row count, column count, detected headers, duplicate headers, blank headers, inferred data types, missing expected fields, warnings, and disclaimer information for submitted CSV text.
The 'score' in the Map Columns response indicates the confidence level of the suggested mapping between source columns and target fields. A higher score suggests a better match, helping users make informed decisions on which mappings to apply.
To obtain your API key, first sign in to your account and navigate to the API you want to use. From the API's Pricing section, choose a plan and complete the subscription process. Once subscribed, return to the API page and you will see your API Access Key displayed at the top of the documentation page. You can use this key to authenticate your requests.
You can’t switch APIs during the free trial. If you subscribe to a different API, your trial will end and the new subscription will start as a paid plan.
The free trial lasts for 7 days and allows you to make up to 50 API requests.
No, the free trial is available only once, so we recommend using it on the API that interests you the most. Most of our APIs offer a free trial, but some may not include this option.
Yes. If the API offers a free trial, you will see a "Free 7-Day Trial" option in its Pricing section. The trial lasts for 7 days and allows up to 50 API requests, enabling you to evaluate the API before subscribing to a paid plan.
Zyla API Hub is like a big store for APIs, where you can find thousands of them all in one place. We also offer dedicated support and real-time monitoring of all APIs. Once you sign up, you can pick and choose which APIs you want to use. Just remember, each API needs its own subscription. But if you subscribe to multiple ones, you'll use the same key for all of them, making things easier for you.
You can monitor your API usage through the response headers included with every request:
x-zyla-api-calls-monthly-used: Shows the total number of API requests you have used during the current billing period.
x-zyla-api-calls-monthly-remaining: Shows the number of API requests you have remaining for the current billing period.
Yes, you can cancel your subscription at any time. Simply go to the Pricing section of the API you're subscribed to and click the "Unsubscribe" button.
Please note that upgrades, downgrades, and cancellations take effect immediately. Once your subscription is canceled, access to the service will end immediately, regardless of any remaining API calls in your quota.
Please have a look at our Refund Policy: https://zylalabs.com/terms#refund
Service Level:
100%
Response Time:
1,341ms
Service Level:
100%
Response Time:
568ms
Service Level:
100%
Response Time:
2,811ms
Service Level:
100%
Response Time:
3,110ms
Service Level:
100%
Response Time:
3,408ms
Service Level:
100%
Response Time:
2,109ms
Service Level:
100%
Response Time:
1,293ms
Service Level:
100%
Response Time:
4,916ms
Service Level:
100%
Response Time:
3,110ms