An infographic compares Python notebooks, spreadsheet automation, and AI chat for analyzing data and producing a revenue report.
Excel automation used to mean recording a macro and hoping the VBA held up. Three tools now try to write the Python for you: Mito, Copilot with Python in Excel, and Julius AI. They look similar on a feature list, but they differ a lot in where the work runs, who controls the data, and what you pay. This piece compares them, using How-To Geek's roundup as the starting point. I've corrected several details against vendor and Microsoft documentation.

An infographic compares Python notebooks, spreadsheet automation, and AI chat for analyzing data and producing a revenue report. The short version​

  • Mito turns spreadsheet-style edits into reusable Python inside Jupyter.
  • Copilot in Excel works inside the workbook and can use Python in Excel, but access depends on your license, platform, build and tenant.
  • Julius AI runs in a browser. You upload files and ask questions in plain English.

None of them removes the need to check the output.

Mito: a macro recorder that writes Python​

Mito's documentation describes a set of Jupyter extensions with three parts: an AI chat and debugging layer, an interactive spreadsheet, and a spreadsheet component for Streamlit and Dash apps. In the spreadsheet you can write formulas such as VLOOKUP, apply filters, build pivot tables and make graphs. Mito says every edit is converted into Python code in the notebook. That is the macro-recorder idea, with a script as the output instead of VBA.

The practical gain is repeatability. Mito's FAQ says that if you complete a spreadsheet workflow once, you get a Python script you can rerun on new data. The caveat is that a rerun works best when the new file has a structure similar to the original. A renamed column, a changed date format or a shifted layout can break a "monthly refresh". Test the script on a realistic next-month file before you rely on it.

Setup: Mito isn't an Excel add-in. It runs in JupyterLab, Jupyter notebooks, JupyterHub, SageMaker and similar environments. It installs with pip, using the mito-ai and mitosheet packages, according to How-To Geek. Anyone who has never opened a notebook will need some time to get comfortable with it.

Cost: Mito's site confirms an open-source version and paid Pro and Enterprise tiers.

  • Pro includes unlimited AI completions, extra formatting and transformation options, and the ability to disable telemetry.
  • Enterprise adds admin controls, database and LLM integrations, and training.
  • Mito's site says it runs on your own infrastructure and that enterprises can bring their own API keys for providers such as Azure and AWS.

How-To Geek cites $20 per user per month for Pro and 150 free AI completions per month. I couldn't confirm either figure on Mito's pages, so check the live plans page before budgeting.

Copilot and Python in Excel: powerful, but check eligibility​

Microsoft's support documentation says Copilot in Excel helps you build and edit workbooks. It can generate formulas, charts and PivotTables, apply formatting, and make direct changes. It has three modes:

  • Edit changes the workbook directly.
  • Plan proposes a plan before anything is edited.
  • Chat keeps responses in the chat pane.

Edit, chat and plan modes are available on Windows, Mac and the web. iPad support is narrower, and iPhone and Android are more limited still.

Licensing is more nuanced than "you need a $30 Copilot license"​

How-To Geek says in-Excel editing requires a Microsoft 365 Copilot license. Microsoft's current FAQ is broader. Copilot in Excel requires one of these:

  • a Microsoft 365 Personal or Family subscription with an AI credits plan
  • a Microsoft 365 Premium subscription
  • a commercial Microsoft Copilot subscription
  • a Copilot Chat-eligible Microsoft 365 or Office 365 business or enterprise subscription

Microsoft adds that availability can vary by license and, for enterprise users, by tenant configuration. In-product labels such as "M365 Copilot (Premium)" and "M365 Copilot (Basic)" show which experience you have. So the safe advice is to check your own account and the labels in Excel. Don't assume the commercial add-on price applies to everyone, and don't assume the free chat tier alone unlocks everything.

Python in Excel has its own requirements​

Python in Excel is a separate feature from Copilot, and it has its own build requirements. Microsoft's availability page lists these for Enterprise and Business users on Windows:

  • Current Channel, Version 2408 (Build 17928.20114) or later
  • Monthly Enterprise Channel, Version 2408 (Build 17928.20216) or later
  • Semi-Annual Enterprise Channel, Version 2502 (Build 18526.20472) or later

It's also available in Excel on the web, and on Mac Current Channel from Version 16.96 (Build 25041326). It is not available on Excel for iPad, iPhone or Android. Workbooks containing Python can be viewed there, but Python cells show an error when recalculated.

Other limits that matter for rollouts:

  • A qualifying Microsoft 365 subscription gives standard compute. Premium compute and manual or partial recalculation modes need the Python in Excel add-on license.
  • Device-based licenses and shared computer activation aren't supported.
  • Free consumer licenses and perpetual licenses don't support Python in Excel.
  • Microsoft 365 connected experiences must be enabled.

Copilot editing itself only works when Calculation Options are set to Automatic. SharePoint check-out requirements can also stop Copilot in Excel on Windows and Mac. Microsoft's guidance for that case is to use Excel for the web.

What about the #BLOCKED! error?​

How-To Geek says Protected View blocks Python formulas in untrusted workbooks and returns #BLOCKED!. I couldn't verify that exact description in Microsoft's documentation. Microsoft documents several other causes of #BLOCKED!, so treat it as a symptom to diagnose, not a single cause:

  • Microsoft's troubleshooting page says Python in Excel must be enabled in a workbook for Python formulas to calculate. It also says to confirm access to Microsoft 365 connected services.
  • Microsoft's data-security page documents a registry policy that, when set to disable Python functions, makes Python functions return the error #BLOCKED!
  • A Microsoft Press Store chapter says a Python cell can show #BLOCKED! when the workbook sits in a location not tied to a valid Python in Excel license. For example, a company-licensed setup shouldn't be used from a personal OneDrive.
  • Forum reports describe a "limit exceeded" variant, for example when too many untrusted workbooks with Python formulas are open at once.

If your team hits this error, check licensing and connected services first. Then check the workbook location and any admin policy.

Security posture​

The article says Python in Excel runs in Azure containers and not on the local machine. That is a meaningful difference from running scripts on a laptop. It also means these workflows depend on a cloud connection. Microsoft also warns that Copilot output can be wrong. It advises against relying on it for sensitive financial, legal or medical decisions, and notes that saved changes are visible to anyone with access to the file.

Julius AI: the hands-off option​

Julius runs in the browser. Its site says you upload files, ask questions in plain English, and get answers that come from code run on your actual data. It lists spreadsheets, CSVs and PDFs among the supported inputs. That matches How-To Geek's point that nothing needs installing and no Microsoft subscription is required.

Pricing has moved​

Julius's pricing page shows a free tier and several paid plans. Plus is $20 a month ($16 a month when billed annually) and Pro is $45 ($37 annually). Business is $450 a month ($375 annually) and Enterprise is by contact. The page describes limits in credits and lists data connectors, including Google Drive, OneDrive and SharePoint. Higher tiers add warehouses such as Snowflake, BigQuery and Postgres. The "roughly $20" figure from third-party listings is a fair ballpark for Plus, but credits and features change, so treat the pricing page as the reference.

I couldn't confirm How-To Geek's claims about a ChatGPT app that edits saved workbooks, so I'm leaving those out.

Data handling needs a real review​

Julius's terms of service include broad language on user-generated content. They describe a license that includes sharing content with third-party AI providers to develop and improve AI models. The pricing page says Julius is SOC 2 Type II compliant. That helps, but it doesn't replace your own approval process. For confidential or regulated spreadsheets, get the privacy and security review done before uploading anything. By contrast, Copilot in an existing Microsoft 365 tenant and Mito's bring-your-own-model setup keep data inside boundaries you already control.

Which one fits?​

NeedBest fitWatch out for
Reusable, reviewable scripts from spreadsheet-style actionsMitoRequires a Jupyter environment; scripts depend on a consistent file layout
Work inside Excel with Microsoft's compliance boundaryCopilot and Python in ExcelEligibility varies by license, build, platform and tenant
Quick answers from a file, no installJulius AIData leaves your environment; credit-based limits

A practical checklist before you automate​

  1. Run the workflow against a fresh file with realistic quirks, such as renamed columns, blanks and duplicates.
  2. Reconcile totals against the source data. A model deciding how to clean messy columns can misread them.
  3. Keep the generated script, or a reviewed copy of the workbook, as the record of what changed.
  4. For Copilot and Python in Excel, confirm the build channel, license labels and connected-experience settings for each user.
  5. For Julius, get sign-off on privacy and data handling first.

Bottom line​

These tools do lower the barrier to Python-based Excel automation, as How-To Geek argues. The details decide which one suits you: Mito for code you can inspect and rerun, Copilot for staying inside Microsoft 365, and Julius for the fastest start. Plans and quotas change quickly, so verify prices and eligibility on the day you buy.

 

References

  1. 3 no-code Python tools that automate Excel spreadsheets in seconds How-To Geek 2026-10-23T14:30:17+00:00
  2. My Python formula on MS Excel is not working. I get an error #Blocked messge, - Microsoft Q&A learn.microsoft.com
  3. AI Chatbot – Chat with AI Online for Free | Julius AI julius.ai