How to convert csv to json for postman collection runs
- Step 1Export your test data as CSV — Pull your test scenarios from a spreadsheet or the test harness into a CSV file.
- Step 2Convert to a JSON array — Use this tool with output format 'array of objects' and inference on.
- Step 3Open Postman's collection runner — Pick the collection, choose 'Data' and select the .json file you just downloaded.
- Step 4Run the collection — Each iteration receives one object from the array. Reference its keys with {{variableName}} in the request body.
Frequently asked questions
Why not just use CSV in the Postman runner?+
CSV in Postman treats every cell as a string. JSON keeps numeric, boolean, and null fields typed so test assertions and request bodies do not need to cast values manually.
Does Newman accept the same JSON file?+
Yes. Newman uses the same data-file format. Pass it with newman run collection.json -d data.json.
Can I generate nested request bodies from a flat CSV?+
Use the grouped output mode to nest records by a key column, or run a Find & Replace pass on the CSV before conversion if you need a deeper shape.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.