VLine Roster Import — Excel Import for Complex Rosters
New import mode for complex .xlsx rosters: declare which columns are shift data and which to ignore. Built for VLine train driver rosters and any depot spreadsheet that mixes shift data with operational identifiers.
Shift It’s Excel import has always handled the common formats — ward master rosters, HosPortal exports, the typical .xlsx a manager emails out. But some rosters are more than just a shift table. VLine train driver rosters, for example, pack employee IDs, service codes, rolling stock identifiers, and depot references into the same spreadsheet as the actual shift data. A parser that treats all of that as potential shift information gets confused.
The new advanced import mode solves this with a declaration step. Before the algorithm runs, you mark which columns and cells contain shift times, dates, and labels — and which to ignore. Employee ID column? Ignore. Service codes? Ignore. Depot reference? Ignore. Once you’ve declared the structure, the parser works only on what you’ve identified as shift data. The result is a clean import from a spreadsheet the automatic parser couldn’t previously handle.
Why this matters for complex rosters
Most shift-tracking apps assume your roster is a tidy table of names, dates, and times. Many real-world rosters aren’t. Operational spreadsheets contain information for multiple purposes — payroll processing, fleet scheduling, compliance reporting — and the shift data is embedded within that structure rather than standing alone.
The declaration step lets you describe the spreadsheet to the importer rather than hoping the automatic parser can infer the structure. It takes an extra minute the first time for a new roster format.
What formats this covers
The advanced import is available for any .xlsx file, not just VLine rosters. If you’ve previously had trouble importing a spreadsheet because the automatic parser was picking up the wrong cells, the declaration step gives you the control to fix it manually.
If you’re working with a format that still won’t import cleanly, contact us with the roster file (with personal information removed). We can either help you configure the declaration or add automatic support for the format.
Know what you're owed.
Shift It checks your pay against your award automatically. Start free — upgrade when it catches its first mistake.