Skip to content
  • Products
        • AI PLATFORM

          • Platform OverviewThe Anaconda AI Platform is the only unified AI platform for open source saving users time, money, and risk.
          • Trusted DistributionMore than 12,000 vetted Python packages. Free Download
          • Secure GovernanceEnterprise-grade governance with role-based access control
          • Actionable InsightsComprehensive analytics on package usage, team collaboration, and resource utilization
        • ANACONDA AI PLATFORM

          • Get Started
          • Get a Demo
        • PRICING

          • Anaconda Pricing
  • Solutions
        • BY INDUSTRY

          • All Industries
          • Academia
          • Financial
          • Government
          • Healthcare
          • Manufacturing
          • Technology
        • PROFESSIONAL SERVICES

          • Anaconda Professional Services
  • Resources
        • RESOURCE CENTER

          • All Resources
          • Topics
          • Blog
          • Guides
          • Webinars
          • Podcast
          • Whitepapers
        • FOR USERS

          • Download Distribution
          • Docs
          • Support Center
          • Community
          • Anaconda Learning
  • Company
        • COMPANY

          • About Anaconda
          • Leadership
          • Our Open-Source Commitment
          • Newsroom
          • Press Releases
          • Careers
        • PARTNER NETWORK

          • Partners
          • Technology Partners
          • Channels and Services Partners
          • Become a Partner
        • CONTACT

          • Contact Us
  • Free Download
  • Sign In
  • Get Demo

Home Blog R Language Support Now in Anaconda Code for Excel

News

R Language Support Now in Anaconda Code for Excel

  • By Owen Price
  • April 2, 2025

We’re thrilled to announce the latest addition to Anaconda Toolbox: R language support in Anaconda Code! With this beta release, you can now harness the statistical power and visualization capabilities of R directly within your Excel worksheets, giving you even more flexibility in your data analysis toolkit. Let’s explore a practical example that showcases how this integration can revolutionize your data workflows.

With this powerful addition, Anaconda Code users can now script in both Python and R in the same Excel workbook, combining the two biggest data science languages with the world’s most popular productivity tool.

Anaconda Code sidebar

Customizable Environment

Anaconda Code means you can install R libraries directly into an R environment in your workbook, allowing you to choose from over 20k libraries to upgrade your statistical workflows. The environment is managed locally in the add-in, meaning your data stays in the workbook at all times. 

Anaconda Code environments

Statistical Analysis Made Simple with R in Excel

Consider a common challenge in data analysis: performing advanced statistical tests that go beyond Excel’s built-in functions. While Excel offers basic statistical tools, R is renowned for its comprehensive statistical capabilities. Now, you can access these powerful tools without leaving your Excel environment.

Anaconda Code’s REF function passes worksheet data directly into the R script where we can easily perform a one-way analysis of variance, printing the statistics to the cell’s log and returning a boxplot to the worksheet.

Statistical data screenshot

Why R in Anaconda Code Is a Game-Changer

Complementary Strengths: Combine R’s statistical prowess with Excel’s accessibility and familiar interface 

Seamless Data Flow: Work with Excel ranges directly in R without exporting or importing files 

Enhanced Visualizations: Create publication-quality graphics with ggplot2 and other R visualization packages 

Statistical Depth: Access R’s extensive ecosystem of statistical packages directly from your spreadsheet 

Local Execution: Scripts run locally in your secure Anaconda Code environment

Getting Started with R in Anaconda Code

Using R in Anaconda Code is straightforward:

  1. Install Anaconda Toolbox: If you haven’t already, install Anaconda Toolbox for Excel via the Add-Ins button on the Home tab of the Excel Ribbon. Just search for “Anaconda”
  2. Launch Anaconda Code: After the add-in is installed, you can launch Anaconda Code from the button on the Formulas tab of the ribbon
  3. Get Started: To help you get started, we’ve placed the important options front and center when you first open Anaconda Code, so you can get started quickly and with confidence
  4. Write Your R Script: Use familiar R syntax
  5. Run and Visualize: Execute your code and see results directly in Excel

Unlocking New Possibilities

The addition of R to Anaconda Code opens up exciting new possibilities for data professionals and analysts:

For Data Scientists: Continue using your preferred R packages and workflows while collaborating with colleagues who use Excel 

For Excel Power Users: Access advanced statistical techniques without leaving your spreadsheet 

For Data Analysts: Choose the right tool for each specific analysis—Python, R, or Excel—all in one environment 

For Researchers: Apply rigorous statistical methods to your data using R’s specialized packages

Cross-Language Integration

What makes this integration particularly powerful is the ability to use both Python and R in the same workbook. Different analyses might benefit from the strengths of each language—use Python’s machine learning capabilities alongside R’s statistical functions, all within your Excel workflow.

Start Leveraging R in Excel Today

Ready to elevate your Excel data analysis with the power of R? Install Anaconda Toolbox for Excel and begin exploring the possibilities of R integration today!

PrevPrevious ArticleAgents, Governance, and Truth: The AI Imperatives of 2025
Next ArticleOpen Source Growth at Anaconda in 2025: Building the Foundations for AI InnovationNext
You May Also Like

The AI Governance Paradox

Peter Wang

Committing to the Advancement of AI with Open Source

Peter Wang

Using Anaconda without Worry: Enabling ToS compliance with the conda-anaconda-tos plugin

Tyler Ferguson

You May Also Like

The AI Governance Paradox

Peter Wang
Read More

Committing to the Advancement of AI with Open Source

Peter Wang
Read More

Using Anaconda without Worry: Enabling ToS compliance with the conda-anaconda-tos plugin

Tyler Ferguson
Read More
Company
  • Press
  • Careers
  • Contact Us
  • Press
  • Careers
  • Contact Us
Products
  • Anaconda AI Platform
  • Capabilities
  • Professional Services
  • Pricing
  • Anaconda AI Platform
  • Capabilities
  • Professional Services
  • Pricing
Customers
  • Cloud Login
  • Support Center
  • Learning Catalog
  • Docs
  • Community
  • Cloud Login
  • Support Center
  • Learning Catalog
  • Docs
  • Community
Popular
  • AI Platform Guide
  • Topics
  • Guides
  • AI Platform Guide
  • Topics
  • Guides
Create Account
Contact Sales
Create Account
Contact Sales
Facebook X-twitter Linkedin Github Instagram Youtube

© 2025 Anaconda Inc. All rights reserved.

  • Legal
  • Privacy Policy
  • Terms of Use
  • Legal
  • Privacy Policy
  • Terms of Use