{"uid":"cap_TaDEc-W7qiEPGNqxrzjrP","slug":"402utils-json-to-csv-converter-a76e5d9a","name":"402utils JSON-to-CSV Converter","description":"Convert a JSON array of objects into a clean RFC 4180 CSV: header row, CRLF records, correct quoting and quote-doubling. Nested objects flatten to dot-notation columns (a.b.c), arrays are JSON-encoded into their cell, and you can select and order columns explicitly. Delimiter: comma, semicolon, tab or pipe. Caps: 100,000 rows, 5 MB body, 20 MB CSV out. Returns text/csv ready for Excel, Google Sheets or a data pipeline.","url":"https://402utils.com/v1/json-to-csv?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object"},"maxItems":100000,"minItems":1,"description":"1–100,000 plain JSON objects, one per CSV record. Nested objects flatten to dot-notation column names; arrays are JSON-encoded into their cell; null becomes an empty cell."},"columns":{"type":"array","items":{"type":"string"},"description":"Optional column selection and order (flattened dot-notation names). Unknown names produce empty cells. Omit to use the union of all flattened row keys in first-seen order."},"delimiter":{"enum":[",",";","\t","|"],"type":"string","default":",","description":"Field separator."}}},"responseSchema":{"type":"json","example":"name,city,stats.score,stats.active,tags\r\nJeanne d'Arc,Orléans,9.5,true,\r\nJosé,,,,\"[\"\"vip\"\",\"\"beta\"\"]\"\r\n"},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.002","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":{"p10Cents":"0.2000","medianCents":"0.2000","p90Cents":"0.2000","minCents":"0.2000","maxCents":"0.2000","p95Cents":"0.2000","sampleCount":1,"varies":false,"failureChargeRate":1},"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.002/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.002","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.002","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_uOI-iXWl1D5P0JGC-ksi1","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.002","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Converts a JSON array of objects into a properly formatted RFC 4180 CSV with configurable delimiter, column selection, and nested object flattening","exampleAgentPrompt":"Convert this JSON array of order records into a CSV file using a semicolon delimiter, and only include the columns order_id, customer.name, and total_amount.","exampleUseCases":null,"resultDescription":"Returns a text/csv response with an RFC 4180-compliant CSV: a header row with column names (dot-notation for nested fields), CRLF line endings, correct quoting and quote-doubling for special characters, and one row per input object. Arrays within objects are JSON-encoded into their cell; nulls become empty cells. Ready for direct import into Excel, Google Sheets, or a data pipeline.","failureModes":["Input array exceeds 100,000 rows — returns 400 or payload-too-large error","Request body exceeds 5 MB — returns 413 or similar size error","Output CSV would exceed 20 MB — returns an error indicating output size limit","rows field is missing or empty — returns 400 validation error","Invalid delimiter value (not comma, semicolon, tab, or pipe) — returns 400 validation error","Malformed JSON body — returns 400 parse error","columns array references names that produce no matches — returns CSV with empty cells but no error"],"whenToPreferThis":"Choose this endpoint when you need to transform a JSON array of objects (including nested structures) into a standards-compliant CSV without writing custom serialization code. Ideal for data pipeline automation, generating spreadsheet downloads from API responses, or preparing structured exports for tools like Excel or Google Sheets. Prefer over manual conversion when nested objects need dot-notation flattening or when column ordering and selection matter.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T18:43:45.539Z","isFirstParty":false,"canonicalSlug":"402utils-json-to-csv-converter-a76e5d9a"}