Edit your whole team in a sheet

Change a department, a job title, a pay rate or any other field for many people at once in a spreadsheet-style page, or download the team to Excel, edit it and upload it back.

On Employees, click Edit in a sheet. Your team opens as a sheet: one row per person, one column per field. Change the cells you want, review the changes, then apply them. Nothing is saved while you type.

Change many people at once

  1. On Employees, click Edit in a sheet.
  2. Click a cell and type. Enter moves down. To give many people the same value, click the cell that has it and click Fill down; it copies that cell to every row below. Undo takes it back.
  3. Click Columns to show more fields, such as address, emergency contact, birth date or weekly hours.
  4. Click Review changes. You see a summary, for example "12 people: Department" and "3 people: Pay rate".
  5. Click Apply changes.

Pay rates need a start date

When a pay rate or pay type changes, the review asks New pay rates start on. Hours before that day keep the old rate. Pay history is added to, never rewritten, so past pay periods do not change.

Edit in Excel and upload it back

  1. In the sheet, click Excel or CSV beside the download icon. The file has the same columns the sheet is showing.
  2. Edit it in Excel or Google Sheets and save it.
  3. On Employees, click Bulk import and upload the file.
  4. Each row says Updates and the person's name. Click Update people.

People are matched by payroll ID, then employee number, then email, then their exact name. If a match is doubtful, for example two people share a name, the row asks you to choose Update them or Add as new. It never guesses. An empty cell in an uploaded file never clears what is already saved.

Good to know

  • A cell with a problem turns red and says why. That row is left as it is until you fix it; the others are applied.
  • PINs are never shown or downloaded. Type a new PIN in the PIN cell to change one.
  • Pay columns appear only for people who are allowed to see pay.
  • A manager who is limited to some locations sees and changes only the people at those locations.
  • Every change shows in the person's Activity, with who made it.

Questions people ask

Can I undo a change after I apply it?

There is no single undo after Apply changes. Open the sheet again and type the old value back, or open the person's profile. Their Activity tab shows what each field was before.

Will uploading my edited file add everybody twice?

No. Rows are matched to the people already on your team by payroll ID, employee number, email or exact name, and those people are updated. Only rows that match nobody are added as new people.

Why is there no pay rate column?

Pay columns show only for people allowed to see pay. Owners and admins see them. A manager sees them only if an owner switched that on in Settings > People and permissions > Permissions.

Can I give somebody a raise from a future date here?

Yes. Change the Pay rate cell, click Review changes, and set New pay rates start on to the date. The old rate stays in force until that day.

Related guides

Still stuck, or missing a feature?

Ask in the chat in your dashboard or email [email protected]. A real person reads every message, and we'll work it out.

Updated 2026-11-16