CartoDB - Update column from local csv

So I uploaded a csv from my local drive and set up the map, but I would like to update a column of data every day and re-upload the csv, but keep map settings.

The dataset is very simple: one column for country names and one with values. Only the values change every day, not the country names

Any ideas?

You have two different approaches here:

  • Using Sync tables with your local file being synchronized from a Dropbox/GDrive folder. Countries will be automatically georeferenced each time.
  • Using an automatic script in your end that updates your table with the new information via the SQL API:

You can sync your data with Google Drive or Dropbox. Here is a tutorial about it.

For doing that, you need a John Snow account (at least).