2e:null 2f:["$","title",null,{"children":"Load in CSV Data from googlesheets | Brett Cooper | Observable"}] 34:T462,# Load in CSV Data from googlesheets *To get a [CSV file from a google docs spreedsheet.](https://stackoverflow.com/questions/33713084/download-link-for-google-spreadsheets-csv-export-with-multiple-sheets/33727897#33727897)*

https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name}

Source URL: https://docs.google.com/spreadsheets/d/18A7oDuavlh89rAmqcaXpqle8QLqIvlAkoEUxcObzuUM/edit#gid=1985253373 **sheet_name** = 1985253373 **key** = 18A7oDuavlh89rAmqcaXpqle8QLqIvlAkoEUxcObzuUM So the CSV download link is: [https://docs.google.com/spreadsheets/d/**18A7oDuavlh89rAmqcaXpqle8QLqIvlAkoEUxcObzuUM**/gviz/tq?tqx=out:csv&sheet=**1985253373**](https://docs.google.com/spreadsheets/d/18A7oDuavlh89rAmqcaXpqle8QLqIvlAkoEUxcObzuUM/gviz/tq?tqx=out:csv&sheet=1985253373) #### datum looks like this:

  Object[0] {
    name: "Container security scanning"
    quadrant: "Techniques"
    ring: "Adopt"
    isNew: "TRUE"
    description: "< p>The continued adoption of containers for deploy… that run as part of the deployment pipeline.< \p>"
  }

35:[] 32:{"id":"abbb34557434cd97","slug":"load-in-csv-data-from-googlesheets","title":"Load in CSV Data from googlesheets","thumbnail":"bddaf6ef91f7b9e567247fad42266b131ee267389699403bed08bc928d9df77e","access_level":"public","create_time":"$D2021-07-30T16:18:56.200Z","update_time":"$D2021-07-30T16:20:18.470Z","view_time":null,"first_public_time":"$D2021-07-30T16:19:32.678Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"ca35562412a365ec","login":"hellonearthis","name":"Brett Cooper","avatar_url":"https://avatars-next.observableusercontent.com/ee05023c4c2a9d53e29a4f85f35e35430ae16d2c4aa6a6ca791175caf667abc2","tier":"starter_2024"},"version":7,"publish_version":7,"role":null,"authored":false,"authors":[{"type":"individual","id":"71df97e2192b6fce","login":"hellonearthis","name":"Brett Cooper","avatar_url":"https://avatars-next.observableusercontent.com/ee05023c4c2a9d53e29a4f85f35e35430ae16d2c4aa6a6ca791175caf667abc2","tier":null}],"members":[{"type":"individual","id":"71df97e2192b6fce","login":"hellonearthis","name":"Brett Cooper","avatar_url":"https://avatars-next.observableusercontent.com/ee05023c4c2a9d53e29a4f85f35e35430ae16d2c4aa6a6ca791175caf667abc2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Load in CSV Data from googlesheets","cells":[{"id":0,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"