My Blog

R and Python Plotting in Google Sheets

Now you can use R and Python to create beautiful graphs on the fly inside Google Sheets by using techniques developed previously. In fact, many functions that produce image files can be used inside Google Sheets formulas with minimal additional set up.

Using R and Python in Google Sheets Formulas

With a bit of setup, you can create spreadsheet formulas for others to use that execute R, Python, or practically any programming language code! While Shiny and Dash are great ways to share your work, following the instructions in this article, you will be able to create R and Python dashboards directly inside Google Sheets. As a bonus, these same methods allow you to insert R and Python functionality into other Google services such as Docs, Forms and Slides!