GOOGLESHEETS: Stata module to read, write, and edit Google Sheets directly from Stata

Eric Booth

Statistical Software Components from Boston College Department of Economics

Abstract: googlesheets mirrors the import excel / export excel / putexcel family, but talks to live Google Sheets via the Sheets API. Surgical placement of values and matrices, on-demand cell formatting, sheet (tab) management, and filtered reads of Google Forms response sheets. Subcommands: import, export, put, format, list, ping, addsheet, deletesheet, renamesheet. Talking to the API needs a one-time Google Cloud OAuth setup; see the One-time setup section of -help googlesheets-. The package creates a private Python venv on first run and installs the Google client libraries into it.

Language: Stata
Requires: Stata version 17
Keywords: google sheets; spreadsheets; import; export; putexcel; api; oauth; forms (search for similar items in EconPapers)
Date: 2026-07-30
Note: This module should be installed from within Stata by typing "ssc install googlesheets". The module is made available under terms of the MIT license (https://opensource.org/licenses/MIT).
References: Add references at CitEc
Citations:

Downloads: (external link)
http://fmwww.bc.edu/repec/bocode/_/_gs_field.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/_/_gs_jesc.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/_/_gs_outfield.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets.sthlp help file (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_addchart.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_addsheet.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_auth.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_create.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_deletesheet.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_export.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_format.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_helper.py Python helper script (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_import.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_list.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_ping.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_put.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_renamesheet.ado program code (text/plain)
http://fmwww.bc.edu/repec/bocode/g/googlesheets_runpy.ado program code (text/plain)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:boc:bocode:s459836

Ordering information: This software item can be ordered from
http://repec.org/docs/ssc.php

Access Statistics for this software item

More software in Statistical Software Components from Boston College Department of Economics Boston College, 140 Commonwealth Avenue, Chestnut Hill MA 02467 USA. Contact information at EDIRC.
Bibliographic data for series maintained by Christopher F Baum ().