Import from Excel or Google Sheets

The fastest way to get your people into Oho is a spreadsheet. You fill in Oho's template, connect it once, and Oho creates your workers and starts verifying the credentials you've listed for them. This guide walks through it from start to finish.

What you'll end up with

Your whole workforce in Oho — each person a worker, with their credentials added and checked — without typing anyone in by hand.

Before you start

You'll need:

• Your list of workers and the credential details you hold for them (names, dates of birth, organisation, card or registration numbers).
• A stable Worker ID for every person — the unique identifier they already have in your HR or payroll system. This is what Oho matches on, so it needs to be there from the first import.
• A spreadsheet in Oho's template format. Alongside an Instructions sheet, the template has four data sheets:

Sheet	What goes on it
Workers	One row per person you employ or engage.
Applicants	One row per candidate you're still hiring, before they become a worker.
Credentials	One row per card or registration a worker holds.
Exemptions	One row per requirement a worker is formally excused from.

Fill in the sheets you need and leave the others empty — a straightforward workforce import only needs Workers. Don't delete a sheet you're not using: leave it in place with just its headings. Keep the column headings as they come in the template so Oho can read them.

Excel or Google Sheets — your choice

Both work the same way and use the same template. Google Sheets is the simplest if you'd rather not host a file yourself.

Step 1: Fill in the template

Start from Oho's template, which already has the sheets and the right column headings:

⬇ Download the Excel template (.xlsx)

Fill in the sheets you need, then save the file (or, for Google Sheets, upload the template to Google Drive and open it as a Sheet).

Worker ID is the match key. Oho attaches each credential and exemption row to its worker by matching the Worker ID column — not by email. Use exactly the same Worker ID on the Workers, Credentials and Exemptions sheets, and reuse it on later runs so Oho recognises a returning worker and updates them rather than creating a duplicate. A row with a blank Worker ID can't be linked.

Each sheet's row directly under the headings is a hint row describing what the column expects. Leave it in place — Oho skips it — and start your data on the row below.

What each sheet needs

Oho only refuses a row when it can't tell who or what the row is about. Everything else imports:

Sheet	Required — a row without these is skipped	Strongly recommended — the row imports, but you lose something
Workers	Worker ID, and a name	Email, Date of Birth, State, Worker Type, Status
Credentials	Worker ID, Credential Type, Reference Number	State, Status
Applicants	Applicant ID, and a name	Organisation, Email
Exemptions	The same three as Credentials	State — it's what makes the exemption state-specific

The recommended columns are worth filling in even though nothing blocks you:

• State on a credential row picks the register Oho checks. Without it, a state-issued card may never verify.
• Date of Birth is how several registers match a person. A worker without one may not verify even when their card details are right.
• Email is how Oho reaches a worker or applicant for a check request or a reminder. Volunteers with no email address still import — don't invent one.
• Status left blank counts as active, on both workers and credentials.

Everything else is genuinely optional.

→ Spreadsheet column reference — every column, what it expects, and the exact values Oho accepts.

A worker can have as many credential rows as they hold cards — repeat their Worker ID on each one.

Credential Type takes a fixed set of codes, and a row with a code Oho doesn't recognise is skipped. As well as wwcc, wwvp, driverslicense, firstaid and cpr, it covers ahpra, teacher, ndws (NDIS Worker Screening), vevo, npc (a police check you already hold), passport, and any custom credentials you've defined. The full list is in Credential Type values.

Applicants and exemptions

Applicants are people you're still considering, who haven't been onboarded as workers yet. Fill in the Applicants sheet if you want to bring a recruitment list in at the same time as your workforce — otherwise leave it blank. Applicants don't take credential rows: their credentials arrive when they complete a Recruitment Check, and when you take an applicant on you promote them to a worker and their credentials carry across. See Applicants.

An exemption records that a worker is formally excused from a requirement — a registered teacher who's exempt from holding a Queensland Blue Card, for example. Exemptions count towards compliance, so a properly exempt worker doesn't also need the underlying card. The Exemptions sheet takes the same columns as Credentials, where Credential Type names the requirement the worker is excused from rather than a card they hold, and State is what makes it specific (wwcc + QLD becomes the Blue Card exemption).

Use that sheet when you're loading a batch of known exemptions alongside your workforce. For one-off exemptions — and where you need to capture a reason and a review-by date — record them on the worker's profile instead: see Record an Exemption.

Keep the headings unchanged

Keep the column headings exactly as they come in the template so Oho can read them. If a heading is renamed, moved, or removed, Oho can't map that column and those rows won't import.

For more on how each source works, see Excel or Google Sheets. For the full column-by-column detail, see the Spreadsheet column reference.

Step 2: Open Integrations

In the left menu, under Admin, click Integrations, then start a new integration.

Step 3: Choose your source

Pick Excel or Google Sheets from the list of sources.

Step 4: Connect your spreadsheet

Handle the link with care

Use an Anyone with the link → Viewer link only while the import runs, then revoke it — Step 7.

Your spreadsheet holds workers' names, dates of birth, and card or registration numbers, so:

• Set access to Viewer / view-only. Oho only needs to read the file, never edit it.
• Keep the link to yourself. Don't post it in email, chat, or tickets, and don't reuse it for anything else.
• Revoke it when the import has run — Step 7.

If you chose Google Sheets:

1. Open your Google Sheet and click Share (top-right).
2. Under General access, change it to Anyone with the link, set to Viewer.
3. Copy the link and paste it into the field in Oho.

If you chose Excel:

Oho needs a link to your .xlsx file that it can reach. The easiest way to get one is OneDrive:

1. Upload your completed .xlsx to OneDrive.
2. Create a share link, set so anyone with the link can view.
3. Copy that link and paste it into the field in Oho.

Any other web-hosted location works too, as long as Oho can reach the file — but OneDrive is the simplest. (Prefer not to host a file at all? Use Google Sheets instead.)

Why Oho needs a link anyone can open

Oho reads your file without signing in to your Google or Microsoft account, so the file has to be readable by anyone holding the URL. There's no more restricted option today, for either Google Sheets or Excel/OneDrive.

That means the URL is the only thing protecting the file: anyone who obtains it can see everything in the spreadsheet, and a forwarded or leaked link is enough to disclose it. Keeping the link view-only and short-lived is what limits the exposure.

Personal information like this carries handling obligations under the Australian Privacy Principles — see Workers → Privacy & access.

Step 5: Set how often it runs

Choose a schedule. You can run the import once to get started, or have it run on a regular schedule so changes you make in the spreadsheet flow through automatically.

Step 6: Name it and save

Give the integration a name you'll recognise, then save it. Oho runs the import and brings your people in.

Step 7: Lock the file back down

Now that Oho has your people, close the access you opened in Step 4:

• One-off import: revoke the link. In Google Sheets or OneDrive, set access back to Restricted / remove the link. Oho doesn't need the file again.
• Recurring schedule: the file has to stay reachable for future runs, so leave the link in place — keep it Viewer-only, store the file somewhere access-controlled, and revoke the link when you turn the schedule off.

What happens next

• Your people appear under All Workers.
• Each credential you listed is checked against its official source straight away — see One-off verification.
• To keep those checks current over time, set up Verification Sources for ongoing monitoring.

Updating later

If you set a recurring schedule, you don't re-import by hand — edit your spreadsheet (or Google Sheet) and Oho picks up the changes on the next scheduled run.

Common questions

My Google Sheet import found nothing. Check that sharing is set to Anyone with the link → Viewer, and that you pasted the sheet's link (not a screenshot or a private URL).

Some rows didn't import. Check the three things Oho actually refuses a row for: a blank Worker ID (or Applicant ID), a row with no name at all, and — on credential and exemption rows — a blank Reference Number or a Credential Type Oho doesn't recognise. Also make sure the column headings still match Oho's template, and that each credential or exemption row carries a Worker ID that appears on the Workers sheet.

The same person came in twice. Their Worker ID changed between runs. Oho matches on Worker ID, so keep it stable for the life of the person's record.

I don't see Integrations. This is an admin area — if it's not in your menu, ask an admin in your organisation, or contact support@weareoho.com.

Related

• Integrations — all the ways to bring data into Oho
• Spreadsheet column reference — every column in the template, and which are required
• How Oho Works — the journey from import to ongoing compliance