emantzoo

emantzoo / excel2r

Public

Convert Excel formulas to executable R code. Upload any multi-tab .xlsx workbook and get a standalone .R script. Shiny web app with 62 Excel function mappings.

18
0
100% credibility
Found Mar 30, 2026 at 18 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
R
AI Summary

A tool that converts entire Excel workbooks—including data, formulas, and tables—into standalone R scripts and tidy data files, with built-in verification against original results.

How It Works

1
📊 Start with your Excel workbook

You have a spreadsheet packed with data tables and clever calculations across multiple sheets.

2
🚀 Open the easy web tool

Launch the friendly app designed to turn your Excel magic into something even better.

3
📤 Upload your file

Simply pick your Excel file and let the tool read every sheet, formula, and number inside.

4
🔮 Review the transformed formulas

See your complex Excel formulas rewritten as simple, readable steps that match exactly what you built.

5
⚙️ Choose your setup

Decide if you want separate data files for easy editing or keep it tied to your original file.

6
💾 Download ready files

Grab a complete set of files: a script that runs your calculations and optional editable data sheets.

7
✅ Double-check the results

Run a quick comparison to confirm every single number lines up perfectly with your Excel.

🎉 Run calculations anytime

Now tweak your data, rerun the script with one go, and get fresh results without ever needing Excel again.

Sign up to see the full architecture

6 more

Sign Up Free

Star Growth

See how this repo grew from 18 to 18 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is excel2r?

excel2r takes any multi-tab Excel workbook and converts its formulas into a standalone R script, using base R with zero dependencies in CSV mode. Upload a .xlsx file via its Shiny web app or API, and you get tidy CSV data exports per sheet plus an R script that recreates every computation, including cross-sheet references and named tables. It verifies results against Excel's cached values, letting you ditch Excel entirely for scripted workflows—like converting Excel to CSV inputs for automated R pipelines.

Why is it gaining traction?

Unlike manual rewrites or brittle parsers, it handles 62 common functions (SUMIFS, VLOOKUP, nested IFs), auto-sorts execution order, and flags unsupported bits upfront. The killer hook is one-click verification and standalone output—no Excel runtime needed—plus a polished Shiny app for previewing transformations before download. Developers love auditing formulas as readable R code in version control.

Who should use this?

Data analysts migrating financial models or sales dashboards from Excel to R scripts. R teams inheriting opaque spreadsheets for production pipelines. Consultants converting Excel to CSV or JSON-like tidy data for client handoffs, especially with multi-sheet reports full of lookups and conditionals.

Verdict

Grab it for Excel-to-R migrations if your workbooks stick to supported functions—install via remotes and test the demo. With 18 stars and 1.0% credibility, it's early-stage but mature in docs, tests, and CI; production use needs your own verification on complex sheets.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.