Skip to content
duncanwerner edited this page Aug 7, 2014 · 21 revisions

Excel + R = BERT

The Basic Excel R Toolkit (BERT) is an Excel add-in designed to run R functions in Excel spreadsheet cells. BERT makes it easy to add your R functions and call them in Excel (it's hard to imagine a way to make it any easier, but if you have any thoughts please let us know).

  • [Quick Start] 1
  • [Example: Use Case] 2

Just to be clear, BERT uses its own completely isolated R environment. It won't be affected by (or screw up) any other R installation on your machine. And that R environment is set up automatically by the installer, so it's basically one step.

BERT supports Excel 2007, 2010 and 2013 in both 32- and 64-bit flavors.

The current build uses [R-3.1.1] 3. We also use the [Scintilla] 4 text component. BERT is licensed under the GPL; see the source distribution for license information on BERT, R, and Scintilla.