JSON to CSV converter that flattens nested objects.

Where JSON shows up in SEO work

More often than it used to. Search and analytics APIs return JSON, crawlers export it, and scripts that pull rankings or page data tend to write it because it is the easiest thing to write. The person who then needs to sort, filter or share that data usually wants a spreadsheet.

A converter is the step in between. It is not glamorous, but doing it by hand, or writing a one-off script each time, is how columns end up misaligned and a client sheet ends up wrong.

The rules this converter follows

• Every distinct key path becomes one column, in the order it is first seen.
• Nested objects flatten with dots. Arrays follow the option you pick.
• A missing key is an empty cell, never a shifted row.
• Fields containing the delimiter, quotes or line breaks are quoted, with inner quotes doubled, which is the standard CSV convention.
• Nothing is rounded, reformatted or guessed. A date stays the string it was.

That last rule is deliberate. A converter that “helpfully” reformats numbers and dates is the reason leading zeros vanish from postcodes and product codes. If a value needs cleaning, clean it in the sheet where you can see what changed.

When a spreadsheet is the wrong destination

Beyond a few hundred thousand rows, a spreadsheet stops being a comfortable place to work, and the right move is a database or a notebook rather than a bigger CSV. For keyword lists specifically, the next useful step after getting them into rows is grouping them, which is what the keyword clustering tool does.