I am trying to add data to an existing CartoDB table from a local csv file. Using Import API creates a new table. How can I specify to add data to existing table instead of new table?


1 Answer 1


It does not appear that standard tables in CartoDB allow appending rows to existing tables. If you look at the API there is an append parameter but it says that it is "Reserved for future usage.".

However, I did find this thread which indicates that you can import using SQL, provided the schemas match.

Like so:

INSERT INTO mastertable SELECT * FROM anewtable 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.