How do I use csvbase with Google sheets?

Loading data

Google Sheets provides the special function IMPORTDATA which allows loading csv files from urls. Use it like this:

=IMPORTDATA("https://csvbase.com/meripaterson/stock-exchanges.csv")

This function loads the data into the cells below (and to the right of) the cell in which it is entered:

Depending on the permissions on your Google sheet, you may be prompted to click though a dialog box to allow access to external sources:

Dates

Unfortunately Google Sheets does not parse ISO dates correctly from csv files (a very similar issue to Excel).

This is very easily fixed by setting the cell format as so:

Resulting in dates appearing correctly in the sheet:

Update frequency

Data loaded with IMPORTDATA will update every hour.

Writing data from Google Sheets

This is currently not possible.