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
Written by Jeff Nelson
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Regex
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#