Want to quickly grab open data from Socrata -> Google Sheet? =IMPORTDATA("https://data.phila.gov/resource/wptb-3uhi.csv …")pic.twitter.com/Dtu9kzrcxA
-
@skram Heh, I thought about mentioning limits/URL params; char limit. What if # rows unknown? Maybe I’ll write a post w/more detail.
@laurenancona you can always just put a really big number :) there are also download endpoint in the UI which will guarantee you get em all
-
-
@skram ah! Deliberately avoided that, wasn’t sure if =IMPORTDATA function’d parse w/query str. Wonder if it’d error on Gsheets limit? -
@laurenancona I'm no google sheets expert. Wouldn't use it for more than a hundred thousand rows anyway. Happy data'ing! - Show replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.