Quickstart: Excel on Windows
Get up and running with ModelMonkey in Microsoft Excel on Windows
Requirements
Before installing, make sure you have:
- Microsoft Excel desktop app (Windows or Mac)
- Excel for Microsoft 365, Excel 2021, or Excel 2019
- A Microsoft account for sign-in
Note: ModelMonkey for Excel works with the desktop application only. Excel Online and mobile versions are not currently supported.
Warning
Excel Online (browser version) is not supported. Please use the Excel desktop application.
Step 1: Set Up a Shared Folder Catalog
The Excel add-in is currently in beta and requires manual installation while we await Microsoft AppSource approval.
Create a shared folder for the add-in manifest:
- Create a folder in your Documents (e.g.,
Documents\OfficeAddins) - Download the manifest file: manifest.xml and save it to this folder
- Right-click the folder and choose Properties
- Open the Sharing tab and click the Share button
- Add yourself (and any other users who need the add-in) with Read/Write permission
- Click Share, then note the network path shown (e.g.,
\\YourPC\OfficeAddins) - Click Done to close the dialogs
Tip
Make note of the full network path — you will need it in the next step.
Step 2: Trust the Shared Folder
Tell Excel to trust your shared folder as an add-in catalog:
- Open Microsoft Excel
- Go to File > Options
- Select Trust Center, then click Trust Center Settings
- Select Trusted Add-in Catalogs
- In the Catalog Url box, enter the network path from Step 1 (e.g.,
\\YourPC\OfficeAddins) - Click Add catalog
- Check the Show in Menu checkbox for the newly-added catalog
- Click OK to close both dialogs
- Close and reopen Excel for changes to take effect
Warning
You must restart Excel after adding the trusted catalog for the add-in to appear.
Step 3: Load the Add-in
Now you can load ModelMonkey from your trusted catalog:
- Open Microsoft Excel
- Go to Home > Add-ins, then click More Add-ins
- Select the SHARED FOLDER tab at the top of the dialog
- Select ModelMonkey and click Add
The add-in will be installed and ready to use.
Step 5: Try Your First Task
Let's try a simple task to see ModelMonkey in action. With some data in your spreadsheet, try one of these prompts:
- "Summarize this data"
- "Calculate the total of column B"
- "Find any duplicate values"
- "Create a chart from this data"
Type your request in the chat box and press Enter. ModelMonkey will analyze your spreadsheet and respond with either an answer or a proposed plan of action.
Step 6: Review and Approve Changes
Before making any changes to your spreadsheet, ModelMonkey shows you exactly what it plans to do:
- Review the plan - See the steps ModelMonkey will take
- Ask questions - Request clarification if needed
- Approve or modify - Accept the plan or ask for adjustments
- Watch it work - ModelMonkey executes the approved changes
You're always in control. Nothing happens without your approval.
Warning
Always review changes before approving, especially on important spreadsheets.
Troubleshooting
Add-in not appearing?
- Make sure you're using Excel desktop (not Excel Online)
- Try closing and reopening Excel
- Check if the add-in is enabled in File > Options > Add-ins
Sign-in issues?
- Ensure pop-ups are not blocked for Excel
- Try signing out and back in
- Clear your browser cache if using a Microsoft work account
Need help?
Contact us at support@modelmonkey.io and we'll help you get set up.
Uninstalling
To remove ModelMonkey from Excel:
- Open Microsoft Excel
- Go to File > Options
- Select Trust Center, then click Trust Center Settings
- Select Trusted Add-in Catalogs
- Select the catalog URL you added (e.g.,
\\YourPC\OfficeAddins) - Click Remove
- Click OK to close both dialogs
- Close and reopen Excel for changes to take effect
Next Steps
Now that you've completed your first task, explore what else ModelMonkey can do:
- Spreadsheet Editing - Learn what ModelMonkey can do with your data
- Approval System - Understand how to review and approve changes
- Custom Instructions - Personalize how ModelMonkey works for you
Check out the feature guides to learn more about each capability.