Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to automatically add rows to a Google spreadsheet documents by editing a local text file?

Maybe via DropBox or GoogleCL?

share|improve this question
Can you give me some feedback on the answer I gave? – Jacob Jan Tuinstra Jan 26 '13 at 20:14
Sorry and thank you, I was travelling at the time of your answer and I didn't get to check your #2 solution. Also now I see my question was not perfectly articulated (I added automatically just now). My point being that I'd like to only touch the local csv file (and possibly terminal) so I don't need to access/log in the google drive repository itself. – pax Jan 27 '13 at 21:48

The following choices can be made:

  1. import the local CSV file into a separate sheet and copy the imported rows into the desired place
  2. Write a script that does it for you. I was about to prepare the example myself, but there's no need to. The following link will explain in detail what to do: add data via CSV file
share|improve this answer
both solutions imply operating on the spreadsheet itself, they're not automatic (just working locally) - it's my bad I wasn't specific enough while writing the question. – pax Jan 27 '13 at 21:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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