Convert CSV to clean, typed JSON by URL or raw text. Auto-detects numbers, booleans, and nulls; handles quoted fields, embedded commas, and custom delimiters (RFC-4180). Fast, stateless, and MCP-ready for AI agents.
Run in Postman
{"ok":true,"rowCount":50,"fields":["code","state","category","total exports","beef","pork","poultry","dairy","fruits fresh","fruits proc","total fruits","veggies fresh","veggies proc","total veggies","corn","wheat","cotton"],"data":[{"code":"AL","state":"Alabama","category":"state","total exports":1390.63,"beef":34.4,"pork":10.6,"poultry":481,"dairy":4.06,"fruits fresh":8,"fruits proc":17.1,"total fruits":25.11,"veggies fresh":5.5,"veggies proc":8.9,"total veggies":14.33,"corn":34.9,"wheat":70,"cotton":317.61},{"code":"AK","state":"Alaska","category":"state","total exports":13.31,"beef":0.2,"pork":0.1,"poultry":0,"dairy":0.19,"fruits fresh":0,"fruits proc":0,"total fruits":0,"veggies fresh":0.6,"veggies proc":1,"total veggies":1.56,"corn":0,"wheat":0,"cotton":0},{"code":"AZ","state":"Arizona","category":"state","total exports":1463.17,"beef":71.3,"pork":17.9,"poultry":0,"dairy":105.48,"fruits fresh":19.3,"fruits proc":41,"total fruits":60.27,"veggies fresh":147.5,"veggies proc":239.4,"total veggies":386.91,"corn":7.3,"wheat":48.7,"cotton":423.95},{"code":"AR","state":"Arkansas","category":"state","total exports":3586.02,"beef":53.2,"pork":29.4,"poultry":562.9,"dairy":3.53,"fruits fresh":2.2,"fruits proc":4.7,"total fruits":6.88,"veggies fresh":4.4,"veggies proc":7.1,"total veggies":11.45,"corn":69.5,"wheat":114.5,"cotton":665.44},{"code":"CA","state":"California","category":"state","total exports":16472.88,"beef":228.7,"pork":11.1,"poultry":225.4,"dairy":929.95,"fruits fresh":2791.8,"fruits proc":5944.6,"total fruits":8736.4,"veggies fresh":803.2,"veggies proc":1303.5,"total veggies":2106.79,"corn":34.6,"wheat":249.3,"cotton":1064.95},{"code":"CO","state":"Colorado","category":"state","total exports":1851.33,"beef":261.4,"pork":66,"poultry":14,"dairy":71.94,"fruits fresh":5.7,"fruits proc":12.2,"total fruits":17.99,"veggies fresh":45.1,"veggies proc":73.2,"total veggies":118.27,"corn":183.2,"wheat":400.5,"cotton":0},{"code":"CT","state":"Connecticut","category":"state","total exports":259.62,"beef":1.1,"pork":0.1,"poultry":6.9,"dairy":9.49,"fruits fresh":4.2,"fruits proc":8.9,"total fruits":13.1,"veggies fresh":4.3,"veggies proc":6.9,"total veggies":11.16,"corn":0,"wheat":0,"cotton":0},{"code":"DE","state":"Delaware","category":"state","total exports":282.19,"beef":0.4,"pork":0.6,"poultry":114.7,"dairy":2.3,"fruits fresh":0.5,"fruits proc":1,"total fruits":1.53,"veggies fresh":7.6,"veggies proc":12.4,"total veggies":20.03,"corn":26.9,"wheat":22.9,"cotton":0},{"code":"FL","state":"Florida","category":"state","total exports":3764.09,"beef":42.6,"pork":0.9,"poultry":56.9,"dairy":66.31,"fruits fresh":438.2,"fruits proc":933.1,"total fruits":1371.36,"veggies fresh":171.9,"veggies proc":279,"total veggies":450.86,"corn":3.5,"wheat":1.8,"cotton":78.24},{"code":"GA","state":"Georgia","category":"state","total exports":2860.84,"beef":31,"pork":18.9,"poultry":630.4,"dairy":38.38,"fruits fresh":74.6,"fruits proc":158.9,"total fruits":233.51,"veggies fresh":59,"veggies proc":95.8,"total veggies":154.77,"corn":57.8,"wheat":65.4,"cotton":1154.07},{"code":"HI","state":"Hawaii","category":"state","total exports":401.84,"beef":4,"pork":0.7,"poultry":1.3,"dairy":1.16,"fruits fresh":17.7,"fruits proc":37.8,"total fruits":55.51,"veggies fresh":9.5,"veggies proc":15.4,"total veggies":24.83,"corn":0,"wheat":0,"cotton":0},{"code":"ID","state":"Idaho","category":"state","total exports":2078.89,"beef":119.8,"pork":0,"poultry":2.4,"dairy":294.6,"fruits fresh":6.9,"fruits proc":14.7,"total fruits":21.64,"veggies fresh":121.7,"veggies proc":197.5,"total veggies":319.19,"corn":24,"wheat":568.2,"cotton":0},{"code":"IL","state":"Illinois","category":"state","total exports":8709.48,"beef":53.7,"pork":394,"poultry":14,"dairy":45.82,"fruits fresh":4,"fruits proc":8.5,"total fruits":12.53,"veggies fresh":15.2,"veggies proc":24.7,"total veggies":39.95,"corn":2228.5,"wheat":223.8,"cotton":0},{"code":"IN","state":"Indiana","category":"state","total exports":5050.23,"beef":21.9,"pork":341.9,"poultry":165.6,"dairy":89.7,"fruits fresh":4.1,"fruits proc":8.8,"total fruits":12.98,"veggies fresh":14.4,"veggies proc":23.4,"total veggies":37.89,"corn":1123.2,"wheat":114,"cotton":0},{"code":"IA","state":"Iowa","category":"state","total exports":11273.76,"beef":289.8,"pork":1895.6,"poultry":155.6,"dairy":107,"fruits fresh":1,"fruits proc":2.2,"total fruits":3.24,"veggies fresh":2.7,"veggies proc":4.4,"total veggies":7.1,"corn":2529.8,"wheat":3.1,"cotton":0},{"code":"KS","state":"Kansas","category":"state","total exports":4589.01,"beef":659.3,"pork":179.4,"poultry":6.4,"dairy":65.45,"fruits fresh":1,"fruits proc":2.1,"total fruits":3.11,"veggies fresh":3.6,"veggies proc":5.8,"total veggies":9.32,"corn":457.3,"wheat":1426.5,"cotton":43.98},{"code":"KY","state":"Kentucky","category":"state","total exports":1889.15,"beef":54.8,"pork":34.2,"poultry":151.3,"dairy":28.27,"fruits fresh":2.1,"fruits proc":4.5,"total fruits":6.6,"veggies fresh":0,"veggies proc":0,"total veggies":0,"corn":179.1,"wheat":149.3,"cotton":0},{"code":"LA","state":"Louisiana","category":"state","total exports":1914.23,"beef":19.8,"pork":0.8,"poultry":77.2,"dairy":6.02,"fruits fresh":5.7,"fruits proc":12.1,"total fruits":17.83,"veggies fresh":6.6,"veggies proc":10.7,"total veggies":17.25,"corn":91.4,"wheat":78.7,"cotton":280.42},{"code":"ME","state":"Maine","category":"state","total exports":278.37,"beef":1.4,"pork":0.5,"poultry":10.4,"dairy":16.18,"fruits fresh":16.6,"fruits proc":35.4,"total fruits":52.01,"veggies fresh":24,"veggies proc":38.9,"total veggies":62.9,"corn":0,"wheat":0,"cotton":0},{"code":"MD","state":"Maryland","category":"state","total exports":692.75,"beef":5.6,"pork":3.1,"poultry":127,"dairy":24.81,"fruits fresh":4.1,"fruits proc":8.8,"total fruits":12.9,"veggies fresh":7.8,"veggies proc":12.6,"total veggies":20.43,"corn":54.1,"wheat":55.8,"cotton":0},{"code":"MA","state":"Massachusetts","category":"state","total exports":248.65,"beef":0.6,"pork":0.5,"poultry":0.6,"dairy":5.81,"fruits fresh":25.8,"fruits proc":55,"total fruits":80.83,"veggies fresh":8.1,"veggies proc":13.1,"total veggies":21.13,"corn":0,"wheat":0,"cotton":0},{"code":"MI","state":"Michigan","category":"state","total exports":3164.16,"beef":37.7,"pork":118.1,"poultry":32.6,"dairy":214.82,"fruits fresh":82.3,"fruits proc":175.3,"total fruits":257.69,"veggies fresh":72.4,"veggies proc":117.5,"total veggies":189.96,"corn":381.5,"wheat":247,"cotton":0},{"code":"MN","state":"Minnesota","category":"state","total exports":7192.33,"beef":112.3,"pork":740.4,"poultry":189.2,"dairy":218.05,"fruits fresh":2.5,"fruits proc":5.4,"total fruits":7.91,"veggies fresh":45.9,"veggies proc":74.5,"total veggies":120.37,"corn":1264.3,"wheat":538.1,"cotton":0},{"code":"MS","state":"Mississippi","category":"state","total exports":2170.8,"beef":12.8,"pork":30.4,"poultry":370.8,"dairy":5.45,"fruits fresh":5.4,"fruits proc":11.6,"total fruits":17.04,"veggies fresh":10.6,"veggies proc":17.2,"total veggies":27.87,"corn":110,"wheat":102.2,"cotton":494.75},{"code":"MO","state":"Missouri","category":"state","total exports":3933.42,"beef":137.2,"pork":277.3,"poultry":196.1,"dairy":34.26,"fruits fresh":4.2,"fruits proc":9,"total fruits":13.18,"veggies fresh":6.8,"veggies proc":11.1,"total veggies":17.9,"corn":428.8,"wheat":161.7,"cotton":345.29},{"code":"MT","state":"Montana","category":"state","total exports":1718,"beef":105,"pork":16.7,"poultry":1.7,"dairy":6.82,"fruits fresh":1.1,"fruits proc":2.2,"total fruits":3.3,"veggies fresh":17.3,"veggies proc":28,"total veggies":45.27,"corn":5.4,"wheat":1198.1,"cotton":0},{"code":"NE","state":"Nebraska","category":"state","total exports":7114.13,"beef":762.2,"pork":262.5,"poultry":31.4,"dairy":30.07,"fruits fresh":0.7,"fruits proc":1.5,"total fruits":2.16,"veggies fresh":20.4,"veggies proc":33.1,"total veggies":53.5,"corn":1735.9,"wheat":292.3,"cotton":0},{"code":"NV","state":"Nevada","category":"state","total exports":139.89,"beef":21.8,"pork":0.2,"poultry":0,"dairy":16.57,"fruits fresh":0.4,"fruits proc":0.8,"total fruits":1.19,"veggies fresh":10.6,"veggies proc":17.3,"total veggies":27.93,"corn":0,"wheat":5.4,"cotton":0},{"code":"NH","state":"New Hampshire","category":"state","total exports":73.06,"beef":0.6,"pork":0.2,"poultry":0.8,"dairy":7.46,"fruits fresh":2.6,"fruits proc":5.4,"total fruits":7.98,"veggies fresh":1.7,"veggies proc":2.8,"total veggies":4.5,"corn":0,"wheat":0,"cotton":0},{"code":"NJ","state":"New Jersey","category":"state","total exports":500.4,"beef":0.8,"pork":0.4,"poultry":4.6,"dairy":3.37,"fruits fresh":35,"fruits proc":74.5,"total fruits":109.45,"veggies fresh":21.6,"veggies proc":35,"total veggies":56.54,"corn":10.1,"wheat":6.7,"cotton":0},{"code":"NM","state":"New Mexico","category":"state","total exports":751.58,"beef":117.2,"pork":0.1,"poultry":0.3,"dairy":191.01,"fruits fresh":32.6,"fruits proc":69.3,"total fruits":101.9,"veggies fresh":16.7,"veggies proc":27.1,"total veggies":43.88,"corn":11.2,"wheat":13.9,"cotton":72.62},{"code":"NY","state":"New York","category":"state","total exports":1488.9,"beef":22.2,"pork":5.8,"poultry":17.7,"dairy":331.8,"fruits fresh":64.7,"fruits proc":137.8,"total fruits":202.56,"veggies fresh":54.7,"veggies proc":88.7,"total veggies":143.37,"corn":106.1,"wheat":29.9,"cotton":0},{"code":"NC","state":"North Carolina","category":"state","total exports":3806.05,"beef":24.8,"pork":702.8,"poultry":598.4,"dairy":24.9,"fruits fresh":23.8,"fruits proc":50.7,"total fruits":74.47,"veggies fresh":57.4,"veggies proc":93.1,"total veggies":150.45,"corn":92.2,"wheat":200.3,"cotton":470.86},{"code":"ND","state":"North Dakota","category":"state","total exports":3761.96,"beef":78.5,"pork":16.1,"poultry":0.5,"dairy":8.14,"fruits fresh":0.1,"fruits proc":0.2,"total fruits":0.25,"veggies fresh":49.9,"veggies proc":80.9,"total veggies":130.79,"corn":236.1,"wheat":1664.5,"cotton":0},{"code":"OH","state":"Ohio","category":"state","total exports":3979.79}],"_note":"Response truncated for documentation purposes"}
curl --location --request GET 'https://zylalabs.com/api/13073/csv+to+json+converter+api/26448/convert+csv+to+json?url=https://raw.githubusercontent.com/plotly/datasets/master/2011_us_ag_exports.csv&url=Required' --header 'Authorization: Bearer YOUR_API_KEY'
After signing up, every developer is assigned a personal API access key, a unique combination of letters and digits provided to access to our API endpoint. To authenticate with the CSV to JSON Converter API simply include your bearer token in the Authorization header.
| 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.
(Save 2 months with annual billing 🎉)
Trusted by leading companies
The CSV to JSON Converter turns any CSV — passed as a URL or raw text — into clean, structured JSON your app or AI agent can use immediately.
Key features:
Perfect for data pipelines, spreadsheet imports, ETL steps, and AI agents that need structured data from CSV files.
The API returns structured JSON data, automatically detecting types such as numbers, booleans, and nulls. This ensures that the output is clean and usable for applications or AI agents.
The response includes fields like "ok," "rowCount," "fields," and "data." The "fields" array lists the column names, while "data" contains the actual records as objects with key-value pairs.
The response is structured as a JSON object. It contains a success indicator ("ok"), the total number of rows processed ("rowCount"), an array of field names ("fields"), and the actual data records ("data") as an array of objects.
The API provides information from CSV files, including various data types like numerical values, strings, and booleans. It can handle diverse datasets, such as state exports or agricultural statistics.
Users can customize requests by specifying the "url" parameter to fetch a CSV from a public URL or by posting raw CSV text directly. Additionally, they can choose to enable or disable header mode for object keys.
The data is sourced from publicly accessible CSV files. Users must provide a valid URL to ensure the API can fetch and convert the data accurately.
Typical use cases include data pipelines, spreadsheet imports, ETL processes, and AI applications that require structured data from CSV files for analysis or processing.
Users can parse the JSON response to access specific fields and values. The structured format allows for easy integration into applications, enabling data manipulation, analysis, and visualization.
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
