To achieve this natively you may be able to do this with a combination of automations post-import.
My suggestion would be
1. Import the records into a 'worker table' as-is, something like 'Calendar Staging Records'
2. Automation 1: for each record imported where days <> 'Daily' (assuming these would all just be a single day) -- create a record in your main calendar table for that day/time (you can likely derive the correct date via a formula using some variables in your spreadsheet)
3. Create a table called 'days' which has 5 records (mon-fri)
3. Automation 2: for each record imported where days = 'daily' (assuming these would always be all 5 days of the workweek), create 5 records in your main calendar table using the copy records action (copying records from your days table) -- you could also just do 5 create record actions if that's easier/you dont see this becoming more dynamic in the future. To get the correct dates for your calendar, you can also do some formula magic -- OR add a 'week starting' column in your spreadsheet which might make life easier in that regard all around.
sorry for the brief explanation; I hope that helps a bit, let me know if you have any questions!
Charlie
