PDF Teaching Schedule to Excel Converter
Paste the following prompt into your AI chat to install this skill:
Follow https://skillhub.cn/install/skillhub.md and install @user_2ed69ff3/pdf-teaching-schedule-to-excel.
About this skill
The Problem
Teaching schedule tables in higher-education program plan PDFs often span pages, use merged cells, and lay out multi-semester courses across columns. Manual transcription into Excel is prone to missed semesters, misread course categories, and inaccurate assessment marks. This skill converts such PDF tables into structured Excel data, focusing on batch major cleanup and data preparation before validation.
Core Capabilities and Flow
- Major detection: scans major names, codes, study levels, and learning formats, then locates one or more majors in a single PDF.
- Table structure handling: processes cross-page headers, validates column counts, maps semester and assessment columns, and filters summary rows such as
subtotalortotal. - Course normalization: splits multi-semester courses into numbered rows, distributes credits and class hours, cleans course codes of Chinese and abnormal characters, and tags required or elective courses, including elective “minimum N courses” merged cells.
- Output modes: supports
separate,merged, andmerged-sheet, and generates an execution result sheet with file counts, course counts, and multi-semester course details.
Boundaries
It fits program-plan plus teaching-schedule PDF templates better than arbitrary PDF layouts. If column headers are heavily customized, course categories depend on footnotes, or scanned images are too blurred, preprocessing or manual spot checks may be needed. The output is structured course data for system import, course statistics, or course list generation.
Use Cases
- Academic staff convert multiple major PDF schedules to separate Excel files.
- Registrar merges multiple majors from one PDF into one Excel sheet.
- Analyst splits multi-semester courses into numbered rows and checks counts.
- Staff extract major codes, levels, and formats into structured Excel rows.
Best For
- Academic staff: batch convert program plan PDF schedules into import-ready Excel.
- Course analysts: split multi-semester courses, clean codes, and count major courses.
- Registrar: extract major information from PDFs into structured course lists.
- Data clerks: output multi-major combined PDFs as separate or merged Excel files.
Related Skills
Turn post-meeting text into bilingual minutes, preserving structure and consistent terminology.
Interprets tender files, generates bid docs, and checks compliance via the Bailian API.
Create, repair, and recalculate xlsx, xlsm, csv, or tsv workbooks with formula-safe edits, validation, and recalculation.
Convert HTML files or URLs into PDFs that preserve CSS, support Chinese, and handle automatic pagination.