Microsoft Excel

Microsoft Excel is a connector: it links a MeDo app to one Microsoft account, so the app can find or create Excel workbooks in that account's OneDrive, add, rename, and remove worksheets, read and update cell ranges, and add rows to a table. The app works with the workbooks you choose, in your own OneDrive.

#What you can build

• A sales dashboard. Choose a workbook and a worksheet and show its rows in a table with totals and a refresh button.
• An expense tracker. Add each entry from a form as a new row in a table in your workbook, and list the entries below the form.
• An order export page. Create a new dated workbook from the app's orders after you confirm.
• An inventory sheet editor. Pick a worksheet, review the cell changes, and confirm before saving them.

Microsoft Excel fits when the data already lives in a workbook, or when the people you work with expect an Excel file — logs, trackers, price lists, exports. It does not replace Excel itself: files, tables, and rows cannot be deleted, and charts and formatting are not available, see Limits.

#Build examples

Copy one of these into the prompt box. The first one is the smallest useful starting point and only reads data.

Use @Microsoft Excel to build a sales dashboard that only I can sign in to, where I choose a workbook and a worksheet and see its rows in a table with totals and a manual refresh button.

Use @Microsoft Excel to build an expense tracker web app that only I can sign in to, with a form that adds each entry as a new row to a table in my workbook and a list of the entries below the form.

Use @Microsoft Excel to build an order export page that only I can sign in to, which creates a new dated workbook from my app's orders after I confirm.

Use @Microsoft Excel to build an inventory sheet editor that only I can sign in to, where I pick a worksheet, review cell changes, and confirm before saving them.

Each example asks for a sign-in. The app works with your own workbooks, so say who may use it, as these examples do.

#Prepare and connect

You need a Microsoft account whose OneDrive holds, or will hold, the workbooks. A personal Microsoft account connects directly and does not need a Microsoft 365 subscription. A work or school account may need an administrator in your organization to approve the connection first. No API key and no Azure app registration are involved.

1. Open Skills & Connectors in the sidebar and search for Microsoft Excel.
2. Open the Microsoft Excel card and click Connect.
3. Sign in to the Microsoft account and approve the access MeDo asks for.
4. The button changes to Connected.

Microsoft's consent page names the connection Composio - Excel. That is the service MeDo uses to run connector sign-ins, so this is expected. The access covers the files in your OneDrive, because Excel workbooks are stored there.

If you start building before connecting, MeDo shows a Microsoft Excel connection button under its reply. You can connect there instead.

#Use it in your app

• The app uses your connected account, not each visitor's Microsoft account. Everyone who opens the app works with the same workbooks. Keep the app behind its own sign-in, limited to the intended people, and keep sign-up closed if only you should use it.
• Choose the workbook once. Tell MeDo the workbook's file name and folder, or let the app list a folder and offer a picker. The app then keeps that workbook and does not look it up again each time.
• Rows the app adds go into a table. To log entries, ask for a table with a header row. Each new entry is added below the last row in one step, so the app never has to work out where the next free row is.
• Data is read when a page opens or you refresh it. There is no live sync. Changes made in Excel appear after the next refresh.
• Dates and amounts show the way Excel displays them. Ask the app to show dates as dates if a column shows plain numbers instead.
• Text from a form stays text. The app stores what visitors type as plain text, so a value that starts with = is not turned into a formula in your workbook.
• Changes are confirmed first. MeDo previews the new rows or the changed cells before saving. Removing a worksheet or clearing cells asks for confirmation, because those changes are destructive.
• Exports get a new file name. Creating a workbook at a path that already exists replaces that file, so ask for a date or time in the file name when the app creates workbooks.

#Limits and troubleshooting

"Connection required" appears in the app. Ask the app owner to open the connector card and click Connect, then reload.

A workbook cannot be found by name. OneDrive search can miss workbooks that were created or edited recently, sometimes for a day or longer. Browse the folder instead, or give MeDo the folder and file name.

A number such as 007 lost its leading zeros, or a date appears as a number. Excel reads what the app writes the way it reads typing. Ask the app to store that column as text, or to show the date the way Excel displays it.

The app replaced a file. Creating a workbook at an existing path replaces that file. Ask the app to add a date or time to the names of workbooks it creates.

A change did not appear. Writes are not retried automatically. Open the workbook, confirm what actually changed, and only then repeat the edit.

#Related

• Connector catalog — the other connectors and what they are for.
• Skills & Connectors — how Skills are called, priced, and limited.
• Managing access & roles — restrict who can read and change connected data.