If you import a spreadsheet with a blank value for the Calendar column, the event gets imported, but is unassociated with any calendar. That means the event is not visible in the front end.
The validation for the spreadsheet should include a check for whether there is actually a value for the calendar.