CheckcraftJSON to CSV online: a spreadsheet without uploading the file
Checkcraft is a desktop app for checking APIs and logs without code, with a free edition. Download, no sign-up →
An API export needs to go to an analyst or into Excel. Paste the JSON, check the table on screen and download the CSV without sending data to someone else’s server.
What you get
Each object in the array becomes a row. If the input is an object with a single array inside, as in {"items": [...]}, the elements of that array become the rows. Nested objects unfold into dotted columns such as customer.city, and arrays inside a row are written as JSON text. If objects have different fields, the columns are merged and missing cells stay empty.
Excel and non-Latin text
Excel in locales with a decimal comma expects semicolons; for Google Sheets and most English setups choose a comma, which is the default on this page. The file is saved as UTF-8 with a BOM, so Excel opens non-Latin text correctly. Values containing the delimiter, quotes or line breaks are quoted per RFC 4180.
Formula protection
Text starting with =, +, - or @ may be run by Excel as a formula. If such data came from outsiders, that is a risk. So these values get a leading apostrophe and Excel shows them as text. Numbers are left as they are. A script in your browser does the work; the page sends nothing to a server.
When an export has to be checked regularly
If the table exists to compare an API response with expectations again and again, it is easier to check the response itself: required fields, array totals, record counts. In Checkcraft these are rules that run on every pass, and request data can come from a CSV.
Repeat this on your own API
Checkcraft is a desktop app that saves API response checks without code and shows what did not match. Start with a sample, then use your own sanitized data. Free runs on Windows and Linux with no time limit.
Download FreeDownload and first runNo sign-up or email needed, the archive is ready in a couple of minutes. See the edition limits.
References
Start with the linked example and compare its result with your own test requirement.