---
title: "RotaCloud import shifts from a spreadsheet · Hypamoon"
description: "Typing a rota from a spreadsheet into RotaCloud shift by shift? Load it from the sheet, see a summary first and publish when you are ready."
url: https://hypamoon.com/connect-to/rotacloud/import-shifts
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [RotaCloud](https://hypamoon.com/connect-to/rotacloud)
3.  Import shifts

For teams that run on RotaCloud

# RotaCloud import shifts from a spreadsheet

RotaCloud imports employees, leave and budgets from a CSV file, and copies weeks and templates within one location. Shifts planned in a sheet, from head office or a care plan, are added by hand. Reviewers mention typing shifts in and copying single shifts across dates.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=rotacloud/import-shifts)

## How it goes today

1.  Plan the weeks in a spreadsheet with the team.
2.  Open the rota for each location and week.
3.  Add each shift by hand with its role and break.
4.  Check the sheet and the rota against each other before you publish.

## How it can go

**Put a rota from your spreadsheet into RotaCloud without typing each shift.**

You drop the spreadsheet in, with name, date, start, end, break, role and location per row. First you get a summary per location and week, with rows that do not match a person, role or location. After you approve, the shifts go into RotaCloud unpublished, and you publish them there when the rota looks right.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your RotaCloud key in the portal, never in the chat.

Your request

> With Hypamoon, take the rota from the spreadsheet I send, with name, date, start, end, break, role and location per row, and add the shifts to RotaCloud unpublished. Show me a summary per location and week first, with rows that do not match a person, role or location, and wait for my approval.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~rotacloud/import-shifts&say=shifts%20from%20my%20spreadsheet%20into%20RotaCloud%20as%20unpublished%20shifts%2C%20with%20a%20summary%20and%20a%20check%20before%20they%20go%20in.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=rotacloud/import-shifts)

You create the RotaCloud API key yourself in your account settings, under API and Webhooks. It opens the whole account, so give it a name you will recognise. It stays yours.

## More for teams on RotaCloud

-   [**I want wage cost against takings for each site, week by week, without rebuilding it by hand.**](https://hypamoon.com/connect-to/rotacloud/labour-cost-report)
-   [**I rework the payroll export every month before it goes to payroll.**](https://hypamoon.com/connect-to/rotacloud/payroll-export)
-   [**I want to see who left early or did not clock in, as well as who was late.**](https://hypamoon.com/connect-to/rotacloud/missed-clock-ins)
-   [**At the end of the leave year I change each allowance one by one.**](https://hypamoon.com/connect-to/rotacloud/leave-carry-over)
-   [**I need to know who has read the memo, as the history only shows a share.**](https://hypamoon.com/connect-to/rotacloud/memo-read)
-   [**I want one clear email per person with their week, in our own words.**](https://hypamoon.com/connect-to/rotacloud/rota-email)
-   [**When I delete someone who leaves, their future shifts disappear with them.**](https://hypamoon.com/connect-to/rotacloud/deleted-shifts)
-   [**Everything for RotaCloud**](https://hypamoon.com/connect-to/rotacloud)
