ShiftPlumExport a shift timesheet to CSV and check the totals
A CSV export gives you one row per event so you can review hours in a spreadsheet. In ShiftPlum, choose a calendar and date range, then export CSV. Before using it as a timesheet, check the event categories, reporting boundaries and units: the file contains minutes, not decimal hours.
Choose the calendar and dates again in Export
Open Export, select CSV and confirm the calendar, start date and end date in that dialog. Do not assume a search or category filter in Statistics becomes an export filter: the CSV includes the selected calendar's events within the chosen start-date range.
For two jobs, export each calendar separately and keep their original files. If you later combine rows in a workbook, add a calendar or employer column so you can trace each row back to its source.
Know what each important column means
The end-day field is especially useful for nights. A value of 1 means that the event ends on the day after its start date. The start and end times alone are not enough to reconstruct that interval.
| CSV field | Meaning |
|---|---|
| Date | Event's starting date |
| End day | Number of days from start date to end date |
| Break (min) | Unpaid break duration in minutes |
| Paid minutes | Elapsed event minutes minus the break |
| Estimated earnings / Currency | Saved calculation and its currency |
| Category / Location / Notes | Context that may need filtering or removal |
Open the file without changing the data
Use your spreadsheet application's import options if a double-click puts everything in one column. The export is comma-separated UTF-8 text. Inspect the delimiter, text encoding and date preview before accepting the import.
Keep an untouched original. Spreadsheet settings can reinterpret dates, decimal points and text values. First compare a known date, a title containing a comma and a row with earnings to the source calendar. If the preview looks wrong, correct the import settings rather than editing every row by hand.
Convert minutes only when you need decimal hours
For an unchanged export, “Paid minutes” is column G. Divide that value by 60 in a new column: 675 minutes becomes 11.25 hours. Sum the minutes for the selected work rows before rounding the final hours total.
Filter Category to the events you intend to count. A personal appointment with a start and end time can have a duration too. Keep separate currency totals for earnings; adding USD and EUR into one amount would not produce a meaningful pay estimate.
Reconcile the first and last shifts
The range follows the event's start date. A night beginning on the last day of the month is exported in full, even if it ends next month. A night beginning before the selected range is not pulled in just because part of it falls inside that range.
Compare the row count and minutes with a Statistics view using the same dates, calendar and intended categories. If a workbook allocates hours by actual calendar day, record its different boundary rule and reconcile overnight events separately.
Review the copy you intend to share
The CSV includes notes and locations as well as estimated earnings. Remove columns the recipient does not need from a separate sharing copy. Check titles too: a harmless-looking schedule can still reveal personal details through event names.
A CSV file does not update after you send it, and revoking a calendar link cannot recall a downloaded spreadsheet. For a simple view of when you work, a read-only calendar link may be more suitable. For a printable report, use Print / PDF after checking the preview.