csvbase is a simple website for sharing table data. Join the discord.
Loading csvbase tables into Google sheets
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:
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:
Data loaded with IMPORTDATA
will update every hour.
This is currently not possible.