Import CSV from URL?

[kirk klobeParticipant]

Is there any method I’m missing for direct import of CSV data from a URL, e.g. https://api.covidtracking.com/v1/states/mn/daily.csv ?

[dgteamModerator]

We don’t have import from CSV (something we have been thinking about adding) but the link you sent also has a JSON format that works great with our JSON importer that is in our beta version.

Use the same URL but replace with json.  Then you can check which columns to include.  Here I selected date, death, and hospitalized.

Note that I had to specify the ‘date’ column as a date format.  Click the gear menu to convert.

Then the data is ready to be used.

Not all JSON formats are easy to import but this one is setup very well.   Once it is set up, it will update when you open the file or click the reload button on the JSON group.

So sorry no CSV yet but hope this is useful!

 

[kirk klobeParticipant]

Awesome, thanks for the detailed answer, and I’ll throw in a feature request vote for CSV support.

[dgteamModerator]

Check this out – Demo of importing a CSV from a URL.

This is in the beta now …

https://youtu.be/lbfMrk7PdgE

 

[Author]

Posts