Microsoft Excel
Install SheetsFinance from the Add-ins button on Excel's Home ribbon, then connect it with your Connection ID. It works in Microsoft 365, Excel for the web and standalone Excel 2019, 2021 and 2024.
Install the add-in
Open a new Excel Workbook and click Add-ins from the Home ribbon menu.
Either directly search for SheetsFinance or click More Add-ins which will open the Office Add-ins store in a pop-up modal. You can then search for SheetsFinance there. Then click Add to install.
Once installed successfully you'll see SheetsFinance buttons appear in your Home ribbon and a success message.
Excel currently supports
Connection IDconnecting only. Open the account/connect view, copy your Connection ID from your SheetsFinance Account Dashboard, and paste it into Excel to connect.
You're all set! You can now start using SheetsFinance in Excel.
Supported Excel versions
Every supported version returns the same data. Standalone versions show some results differently.
Excel version | Support |
|---|---|
Microsoft 365 on Windows or Mac | Supported |
Excel for the web | Supported |
Excel 2021 and 2024, including LTSC | Supported, with the differences below |
Excel 2019 bought as a one-time purchase | Supported, with the differences below |
Excel 2019 under a volume licence, Excel 2016 and earlier | Not supported |
To check your version, open File > Account > About Excel on Windows, or Excel > About Excel on Mac.
Differences in standalone Excel
Dates show as numbers
In Excel 2019, 2021 and 2024, dates appear as date numbers such as 44828. Select the cells and choose Short Date from the number format list on the Home ribbon.
Tables need Ctrl+Shift+Enter in Excel 2019
Excel 2019 can't fill a result across neighbouring cells, so enter tables as an array formula.
Select a range large enough for the whole result.
Type the formula.
Press Ctrl+Shift+Enter on Windows or Cmd+Shift+Return on Mac.