My feedback

1. Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.

   208 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with:

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Subscribe

   We’ll send you updates on this idea

   28 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Hi folks,

   Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.

   The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.

   What do you think?

   For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.

   thanks

   Ashvini Sharma
   Lead Program Manager
   Excel

   Bruno Crotman commented  ·  Mar 24, 2018  ·  Delete…

   It will be a GREAT achievement. Power Query is great for Data Wrangling. Sometimes even better than R. Its a very well built tool.

   Adding the possibility to run R scritps will bring all the power of R. The tools are very complementary.

   Regarding the difficulty of installing the libraries, I do not think this will be a problem. Many times the worksheets are shared but the update process is done by one of the users. Other times Excel serves as an environment to create a prototype that will be imported by Power BI. Anyway... we will manage that. Dont worry about it. This is a huge acomplishment! We will use it a lot!

   Bruno Crotman supported this idea  ·  Nov 4, 2017