JSON to XML tool — validate first, convert second.">

How I Fixed a Broken JSON Formatter for Debugging Process

2026-07-13 · 3 min read

A product manager asked me to 'put the API response in a spreadsheet so the team can review it.' The JSON was a 200KB nested object. Writing a Python script would have taken 15 minutes. I used the JSON-to-CSV converter and delivered the spreadsheet in 30 seconds.

The Old Way I Used to Do This — And Why I Stopped

For the longest time, my approach was: find a free converter online, upload the file, download the result, and hope for the best. It worked maybe 80% of the time. The other 20% produced files with wrong dimensions, missing transparency, or compression artifacts that made text unreadable.

The real problem was not the converters themselves. It was that I did not know what I did not know. I was not checking the source file against JSON Schema Draft 2020-12 (json-schema.org) before converting, so I was feeding malformed inputs into tools that silently produced broken outputs. No error message, just a bad file.

What I Switched To — And Why It Stuck

Now I use a two-pass approach. Pass one: validate the source. I check the file against RFC 8259 / ECMA-404 JSON specification to catch issues before conversion — wrong color space, missing metadata, improper dimensions. Pass two: convert with a tool that preserves everything the source had. Our JSON to XML tool handles pass two without stripping alpha channels or downscaling without asking.

The difference is night and day. I went from a 20% redo rate to essentially zero. Use the two-pass method →

The Edge Case That Still Catches People Off Guard

If your source file has a color profile embedded — and most professional design exports do — a generic converter might discard it. The result looks fine on your screen but prints with shifted colors. I only caught this because a client sent me a photo of a printed banner where the brand blue had turned purple.

Now I make sure the converter preserves embedded ICC profiles. It is one of those things you do not think about until it burns you. Then you never forget.

Sam Taylor Written by Sam Taylor — Full-Stack Developer. More about me →