Grid → JSON

1 Paste data (include the header row)

Delimiter

Tip: if any column contains multi-line text (like HTML in an InformationText field), use Save Results As → CSV in SSMS rather than copying the grid — grid copy strips embedded line breaks, CSV export keeps them quoted correctly.

2 Set column types — everything defaults to string, which matches most varchar columns

Only mark a column Number if its underlying SQL type is actually numeric (e.g. an int ID). A digits-only varchar like a funding code should stay String — that's what FOR JSON PATH would do too.

3 Output

Pretty-print