Every fault you find, turned into a quote

See how →
Knowledge Centre

A Year of PPM, Loaded From a Spreadsheet in Minutes

When a client sends their PPM schedule as a spreadsheet, Build Concierge reads it and creates every job, visit and line in your job management system, mapped to the right contacts and contracts.

WorkflowsAutomationsPosted: 23/07/2026Read time: 4 mins

No more days lost keying a year of visits into the system by hand. No more sites missed because a row got skipped. No more new contract starting on the back foot before the first visit even happens.

The problem

Winning a PPM (planned preventative maintenance) contract is the good news. Then the spreadsheet lands. Hundreds of sites, each with its own address, assets, visit frequencies and dates, all needing to become real jobs in your system before the first engineer can be sent anywhere.

So someone sits down and starts typing. Site by site, visit by visit, line by line. It takes days. It is mind-numbing work, and it is exactly the kind of task where a row gets skipped, an address goes in wrong, or a quarterly visit quietly becomes an annual one. The contract has already started, but the diary is empty, and the team is on the back foot before the first visit even happens.

And it is not a one-off. Every renewal, every new contract, every updated schedule means doing the whole thing again.

What the automation does

When the client's PPM schedule arrives as a spreadsheet, Build Concierge reads it and builds the whole thing for you.

  1. Reads the schedule. Hundreds of rows of sites, dates, assets and visit frequencies.
  2. Maps it to your world. Matching each line to the right contact and contract in your job management system.
  3. Creates every job and visit. The full schedule, from the first visit to the last, laid straight into the diary.
  4. Adds the detail. Assets, addresses and financial lines attached to each job, not just a bare booking.
  5. Handles the awkward bits. Multiple visits per site, multiple assets per visit, and sites that need grouping or splitting.

Nothing gets skipped

Every row in the spreadsheet becomes a job, and nothing is silently dropped. If a row cannot be matched or is missing detail, it is flagged for a person rather than guessed at, so you start the contract with a complete, accurate diary.

What you get

  • A full year of PPM loaded in minutes, not days
  • Every visit in the diary from day one of the contract
  • No data-entry marathon every time a contract starts or renews
  • No sites missed because a row got skipped
  • New contracts starting on the front foot, ready to deliver

The schedule that used to swallow days of admin is live in the time it takes to read the email. Your team starts the contract ready to deliver, not buried in keying, and nothing falls through the gaps.

Ways to run it

Every client sends their schedule differently, so the automation flexes to match:

Spreadsheet or CSV

A schedule sent as Excel or CSV is read row by row and turned into jobs, however the client has laid it out.

PPM PDFs and work orders

The same works for schedules and work orders sent as PDFs, with the detail extracted automatically.

Multiple visits per site

A site needing quarterly or monthly visits gets each one created and dated, not just a single booking.

Multiple assets per visit

Where a visit covers several assets, each one is captured against the job, so nothing is lost.

Grouped or split jobs

Sites can be grouped under a contract or split into separate jobs, matched to how you actually schedule and bill.

What you need

Just three things:

  1. Build Concierge connected to your job management system
  2. A sample of the schedule your client sends
  3. How you want it mapped (contacts, contracts and job types)

We support you in connecting to your job management system. Once we have seen a sample schedule, we set up the mapping so each row lands as the right job, against the right contact and contract, every time, no matter how the client formats it.

Getting set up

Step 1: Talk to us

Show us a schedule a client actually sends, and how you turn it into jobs today.

Step 2: We build it with you

We set up the reading and the mapping, and agree how visits, assets and lines are created.

Step 3: Test it live

We run a real schedule through it, check every job lands correctly, then switch it on.

Most businesses are up and running within days.

Common Questions

Whatever your client already sends. Excel, CSV or PDF, laid out however they like. We set the automation up around their format, so they do not have to change a thing.

That is normal, and it is fine. We map each client's layout once, so the next schedule from them just works. A new client with a new format? We add the mapping for them too.

Yes. As well as the jobs and visits, it can attach the assets, addresses and financial lines, so each job is complete rather than just a diary placeholder.

It is flagged for a person rather than guessed. Nothing is created against the wrong site or silently dropped, so you can trust what lands in the diary.

Minutes, rather than the days it takes by hand. The bigger the schedule, the bigger the saving.

Ready to load a year of PPM in one go?

Get in touch with the Build Concierge team and we’ll set it up around the way you work.

Keep reading

More from the knowledge centre

WorkflowsAutomationsEquipment Hire

Always Know Where Your Kit Is

As kit is collected, returned or moved, Build Concierge keeps its location, status and history current in your hire system.

WorkflowsAutomationsEquipment Hire
Posted: 13.08.26Read time: 3 mins
WorkflowsAutomations

Waste Transfer Notes, Matched and Audit Ready

Waste transfer notes arrive by email and Build Concierge files each against the right job, keeping your duty of care record complete.

WorkflowsAutomations
Posted: 13.08.26Read time: 3 mins
WorkflowsAutomations

Book and Cost Engineer Overnight Stays, Automatically

When a job needs an overnight stay, Build Concierge finds a hotel to your rules, sends the office a booking link and puts the cost straight on the job.

WorkflowsAutomations
Posted: 12.08.26Read time: 3 mins
WorkflowsAutomations

Every Job Document, Filed Where It Belongs

Photos, certificates, worksheets and reports arrive by email and Build Concierge files each one against the right job automatically, so nothing is lost in an inbox.

WorkflowsAutomations
Posted: 12.08.26Read time: 3 mins
WorkflowsAutomationsEquipment Hire

Always Know Where Your Kit Is

As kit is collected, returned or moved, Build Concierge keeps its location, status and history current in your hire system.

WorkflowsAutomationsEquipment Hire
Posted: 13.08.26Read time: 3 mins
WorkflowsAutomations

Waste Transfer Notes, Matched and Audit Ready

Waste transfer notes arrive by email and Build Concierge files each against the right job, keeping your duty of care record complete.

WorkflowsAutomations
Posted: 13.08.26Read time: 3 mins
WorkflowsAutomations

Book and Cost Engineer Overnight Stays, Automatically

When a job needs an overnight stay, Build Concierge finds a hotel to your rules, sends the office a booking link and puts the cost straight on the job.

WorkflowsAutomations
Posted: 12.08.26Read time: 3 mins
WorkflowsAutomations

Every Job Document, Filed Where It Belongs

Photos, certificates, worksheets and reports arrive by email and Build Concierge files each one against the right job automatically, so nothing is lost in an inbox.

WorkflowsAutomations
Posted: 12.08.26Read time: 3 mins
WorkflowsAutomationsEquipment Hire

Always Know Where Your Kit Is

As kit is collected, returned or moved, Build Concierge keeps its location, status and history current in your hire system.

WorkflowsAutomationsEquipment Hire
Posted: 13.08.26Read time: 3 mins
WorkflowsAutomations

Waste Transfer Notes, Matched and Audit Ready

Waste transfer notes arrive by email and Build Concierge files each against the right job, keeping your duty of care record complete.

WorkflowsAutomations
Posted: 13.08.26Read time: 3 mins
WorkflowsAutomations

Book and Cost Engineer Overnight Stays, Automatically

When a job needs an overnight stay, Build Concierge finds a hotel to your rules, sends the office a booking link and puts the cost straight on the job.

WorkflowsAutomations
Posted: 12.08.26Read time: 3 mins
WorkflowsAutomations

Every Job Document, Filed Where It Belongs

Photos, certificates, worksheets and reports arrive by email and Build Concierge files each one against the right job automatically, so nothing is lost in an inbox.

WorkflowsAutomations
Posted: 12.08.26Read time: 3 mins