domains / families / data / xlsx-parsing

xlsx-parsing

separate

Read Microsoft Excel (.xlsx) files robustly with `openpyxl` (or `pandas`). Covers multi-sheet workbooks, header rows, empty cells, merged cells, comma-separated list cells, and converting a sheet to a list-of-dicts the rest of your code can consume. Use when a task input or reference document is an `.xlsx` file rather than JSON/CSV.

When to use

• Reading .xlsx files
• Handling multi-sheet workbooks
• Processing header rows
• Handling empty cells
• Handling merged cells
• Parsing comma-separated list cells
• Converting sheets to list-of-dicts

When not to use

• The file is `.csv` — use `csv.DictReader` directly.
• The file is `.json` or `.jsonl` — use `json.loads`.
• The file is `.xls` (legacy binary) — `openpyxl` will refuse; use `xlrd<2` or convert to `.xlsx` first.

Skill page

Source