M365 Excel (.gov.sg Agencies only)
What is M365 Excel?
M365 Excel is a spreadsheet program used to organize, format, and analyse data using tables, calculations, formulas and graphs. It's part of the Microsoft Office suite and is widely used for tasks like data entry, accounting, financial analysis, and more.
What to take note?
Please make sure to read through this entire document as there may be restrictions that could affect your operations.
There is a cap on total disk space and Excel actions across all Plumber users. Please exercise prudence when using this action. To ensure that storage space is sufficient for all users, versions are deleted when they exceed 90 days since last modified. We maintain a M365 Excel action queue to ensure fairness. If there are many executions on the same file, the changes may not execute immediately. To prevent choking of the system, the Plumber team reserves the right to pause your pipe from using Excel if:
Your pipe exceeds a large amount of actions in a short span of time.
You are storing large files in your folder.
If your use case requires large files (>500 MB), or more than 100 Excel actions per 10 minutes, please contact us at https://go.gov.sg/plumber-support to avoid any disruption to your workflow.
Setting up M365 Excel connection (one-time)
To get started, you need to perform a one-time configuration to connect your Plumber account to M365. This will create a shared folder, known as your "Plumber folder," where you can place Excel files for Plumber to access.
Follow the steps below to set up the configuration.
Part 1: Configure on Plumber
Select "Add step" in the pipe editor

Select “M365 Excel” action

Then select the “Create table row” action (or any action you require)

Click on "Connect" and we will create a folder for you to use on the SharePoint site

Click on "Ok, got it!" and the connection is completed. You can now perform M365 excel actions on Plumber!

Part 2: Start creating or moving Excel files into your Plumber folder on the SharePoint site
Go to your OneDrive on the SG Govt SharePoint, and click on the “Shared” link

You will see a new folder named with your email. The subtitle of that folder will be Plumber (OGP). Any Excel files placed in this folder can be processed in a plumber pipe. We recommend that you star this folder for easy access.

You can create a new excel file via the “Add New” button, or move an existing excel file to this folder.

CAUTION: If you want to move files into this folder, make sure that “Keep sharing with the same people” is selected! Otherwise, existing users will lose access to that file!

Available Actions
Create Table Row
This action allows you to add rows to an Excel table.
You’ll need a table to use “create table row”. Please refer to Microsoft’s video here for instructions on creating a table.
Please do NOT edit the excel table unless you un-publish your pipe first! Editing the table while the pipe is running will result in data corruption!
Expand the “Choose app & event” section, and select “Create row” in the “Choose an event” dropdown.
Expand the “Set up Action” section
In the “Excel File” dropdown, select the file that you want plumber to edit.
In the “Table” dropdown, select the excel table you want plumber to add rows to.
In the “Values” section, input the columns you want to add your data to.
When you are done, click “Continue” and test your step to ensure you have configured it correctly.
Find Table Row
This action allows you to find a single table row by looking up a column value.
Expand the “Choose app & event” section, and select “Find table row” in the “Choose an event” dropdown.
Expand the “Set up Action” section
In the “Excel File” dropdown, select the file that you want plumber to edit.
In the “Table” dropdown, select the excel table want to lookup from.
In the “Lookup Column” section, select the table column you want to look up.
In the “Lookup Value” section, input the value you want to look up.
When you are done, click “Continue” and test your step to ensure you have configured it correctly.
Update Table Row
This action allows you to update a single table row whose column matches a lookup value
Expand the “Choose app & event” section, and select “Update table row” in the “Choose an event” dropdown.
Expand the “Set up Action” section
In the “Excel File” dropdown, select the file that you want plumber to edit.
In the “Table” dropdown, select the excel table want to lookup from.
In the “Lookup Column” section, select the table column you want to look up.
In the “Lookup Value” section, input the value you want to look up.
In the “Columns to update” section, input the columns and values that you want to update.
When you are done, click “Continue” and test your step to ensure you have configured it correctly.
List of agencies allow for M365 integration
This list was last updated on 29 Nov 2024.
If you're user with the email domains "x.gov.sg" and you're not able to access M365 app, please raise a ticket with us at https://go.gov.sg/plumber-support
@tech.gov.sg
@schools.gov.sg
@sport.gov.sg
@defence.gov.sg
@mom.gov.sg
All .edu.sg
mindef.gov.sg
All healthcare institutions
@nlb.gov.sg
@mnd.gov.sg
@singstat.gov.sg
@wsg.gov.sg
@bca.gov.sg
@spf.gov.sg
@thedigitalacademy.tech.gov.sg
@mas.gov.sg
@nea.gov.sg
@hdb.gov.sg
@moh.gov.sg
@mlaw.gov.sg
@judiciary.gov.sg
@nyc.gov.sg
@moe.gov.sg
@pub.gov.sg
@customs.gov.sg
@iras.gov.sg
@msf.gov.sg
@htx.gov.sg
@scdf.gov.sg
@mci.gov.sg
@mha.gov.sg
@stb.gov.sg
@jtc.gov.sg
@lta.gov.sg
@vital.gov.sg
@pris.gov.sg
@caas.gov.sg
@hsa.gov.sg
@gra.gov.sg
@ssg.gov.sg
@ica.gov.sg
@pa.gov.sg
@acra.gov.sg
@mfa.gov.sg
@cpf.gov.sg
@pmo.gov.sg
@toteboard.gov.sg
@csa.gov.sg
@hpb.gov.sg
@mddi.gov.sg
@mpa.gov.sg
@psd.gov.sg
@nparks.gov.sg
@enterprisesg.gov.sg
@mti.gov.sg
@sfa.gov.sg
@muis.gov.sg
@ncss.gov.sg
@hta.gov.sg
@imda.gov.sg
@mccy.gov.sg
@edb.gov.sg
@cscollege.gov.sg
@nac.gov.sg
@ura.gov.sg
@agc.gov.sg
@agd.gov.sg
Common Errors
Todo...
FAQ
Last updated
Was this helpful?