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

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

Anaconda Recognized for Excellence in AI Innovation​

Kodie Dower

You May Also Like

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

Anaconda Recognized for Excellence in AI Innovation​

Kodie Dower
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