[Python] How to Extract Structured Schedule Data from Excel and Use It in a Web App

I’m working on a web app that generates class routines based on semester and section input. I have an Excel file containing detailed schedules for all semesters at my university.

Each class entry looks like this:

• 
  CSE 328.2 (UDD)
  
  
• 
  CSE 328 → Course code
  
  
• 
  .2 → Section
  
  
• 
  (UDD) → Faculty code Some classes are 1.5 hours, others 2 hours, and they’re arranged by day and time.
  

Goal I want to extract this data from Excel and use it to build a website where a user selects their semester and section, and the app generates their full weekly schedule automatically.

enter image description here

Questions:

What's the best way to extract structured data from this Excel file?

Should I use a database to store the parsed data for faster retrieval, or read directly from Excel?

What technologies/libraries would be ideal for this (Python, JS, etc.)?

I've attached a screenshot for reference (note: image available externally).

Any help on parsing strategy, data modeling, or design logic is appreciated

Continue reading...