Choose your MarketXLS add-in
Choose the add-in that matches where you use Excel. Both add-ins connect Excel to MarketXLS data, but they use different installation methods and formula names.
Compare the add-ins
| Windows desktop add-in | Microsoft 365 add-in | |
|---|---|---|
| Use it in | Desktop Excel on Windows | Excel on Mac or Excel for the web |
| Install it from | The MarketXLS Windows installer | The XML manifest; Select 5 is also available in Microsoft Marketplace |
| Find it in Excel | The MarketXLS ribbon tab | The MarketXLS (Web) ribbon tab and task pane |
| Formula example | =Last("MSFT") | =mxls.Last("MSFT") |
| Best choice when | You use desktop Excel on Windows and need Windows tools | You use a Mac, a browser, or the cross-platform add-in |
The Microsoft Marketplace listing is MarketXLS Select 5, which supports up to five symbols. For the web add-in manifest and platform-specific instructions, see Install on Mac or Excel for the web.
Choose an add-in
- If you use only desktop Excel on Windows, install the Windows desktop add-in.
- If you use Excel on a Mac or in a browser, install the Microsoft 365 add-in.
- If you switch between a Mac and Excel for the web, use the Microsoft 365 add-in on both.
Avoid running both add-ins in the same Windows workbook unless you need to test compatibility. The two versions can register similar functions, which can make it harder to tell which add-in is handling a formula.
Identify the add-in you already have
Open Excel and check the ribbon:
- MarketXLS usually identifies the Windows desktop add-in.
- MarketXLS (Web) identifies the Microsoft 365 add-in.
You can also check a working formula. A formula that starts with mxls. uses the Microsoft 365 add-in.