If I create a published table on Google sheets with a specific web address https://docs.google.com/xxxx how can I extract that information using a shell script? I have used the command

wget -O ABC.txt http://address.txt

to extract information from a webpage but it was already in .txt format. Creating another text file was straight forward. But if I use a similar command using a Google weblink it spits out all of the webpage content that doesn't matter; height, font, white-space, etc. I would like to extract the table into a txt or csv file. Has anyone done this?


Try this:

wget -O ABC.txt "https://docs.google.com/document/d/xxxxxx/export?format=txt"
| improve this answer | |
  • I created a test published google sheet, which has this url: docs.google.com/spreadsheets/d/e/… – Briana Aug 28 at 21:03
  • 1
    @Briana I think the sheet has to be open to the public if you want to download it with wget. – Chris W. Aug 28 at 21:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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