csvbase is a simple website for sharing table data. Join the discord.

How do I use csvbase with Google sheets?

Loading csvbase tables into 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")

screenshot of IMPORTDATA

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

screenshot of a csvbase table loaded in google sheets

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

screenshot of a permissions-check dialog box

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:

screenshot of setting the cell formatting to "Date"

Resulting in dates appearing correctly in the sheet:

screenshot of corrected dates

Update frequency

Data loaded with IMPORTDATA will update every hour.

Writing data from Google Sheets

This is currently not possible.