Last Updated: December 16, 2019
·
1.058K
· synthe

GDocs -> JSON

Went from google docs spreadsheet to json in under a minute. Export spreadsheet as TSV, open in Sublime Text 2, find replace w/ regex:
Find:
(\w)\t(\w)\t(\w*)
Replace:
"$3": "$1 $2",
Then just remove the last comma and drop into any json object.

Side note, I also had to switch the keys to all lowercase, so I did:
Find w/ regex:
"\w*":
Click Find All
Cmd + Shift + P, type lower, hit enter