Document Processing Guide
Work with office documents: PDF, Excel, Word, and PowerPoint.
Format Overview
| Format |
Extension |
Structure |
Best For |
| PDF |
.pdf |
Binary/text |
Reports, forms, archives |
| Excel |
.xlsx |
XML in ZIP |
Data, calculations, models |
| Word |
.docx |
XML in ZIP |
Text documents, contracts |
| PowerPoint |
.pptx |
XML in ZIP |
Presentations, slides |
Key concept: XLSX, DOCX, and PPTX are all ZIP archives containing XML files. You can unzip them to access raw content.
PDF Processing
PDF Tools
| Task |
Best Tool |
| Basic read/write |
pypdf |
| Text extraction |
pdfplumber |
| Table extraction |
pdfplumber |
| Create PDFs |
reportlab |
| OCR scanned PDFs |
pytesseract + pdf2image |
| Command line |
qpdf, pdftotext |
Common Operations
| Operation |
Approach |
| Merge |
Loop through files, add pages to writer |
| Split |
Create new writer per page |
| Extract tables |
Use pdfplumber, convert to DataFrame |
| Rotate |
Call .rotate(degrees) on page |
| Encrypt |
Use writer's .encrypt() method |
| OCR |
Convert to images, run pytesseract |
Excel Processing
Excel Tools
| Task |
Best Tool |
| Data analysis |
pandas |
| Formulas & formatting |
openpyxl |
| Simple CSV |
pandas |
| Financial models |
openpyxl |
Critical Rule: Use Formulas
| Approach |
Result |
| Wrong: Calculate in Python, write value |
Static number, breaks when data changes |
| Right: Write Excel formula |
Dynamic, recalculates automatically |
Financial Model Standards
| Convention |
Meaning |
| Blue text |
Hardcoded inputs |
| Black text |
Formulas |
| Green text |
Links to other sheets |
| Yellow fill |
Needs attention |
Common Formula Errors
| Error |
Cause |
| #REF! |
Invalid cell reference |
| #DIV/0! |
Division by zero |
| #VALUE! |
Wrong data type |
| #NAME? |
Unknown function name |
Word Processing
Word Tools
| Task |
Best Tool |
| Text extraction |
pandoc |
| Create new |
python-docx or docx-js |
| Simple edits |
python-docx |
| Tracked changes |
Direct XML editing |
Document Structure
| File |
Contains |
word/document.xml |
Main content |
word/comments.xml |
Comments |
word/media/ |
Images |
Tracked Changes (Redlining)
| Element |
XML Tag |
| Deletion |
<w:del><w:delText>...</w:delText></w:del> |
| Insertion |
<w:ins><w:t>...</w:t></w:ins> |
Key concept: For professional/legal documents, use tracked changes XML rather than replacing text directly.
PowerPoint Processing
PowerPoint Tools
| Task |
Best Tool |
| Text extraction |
markitdown |
| Create new |
pptxgenjs (JS) or python-pptx |
| Edit existing |
Direct XML or python-pptx |
Slide Structure
| Path |
Contains |
ppt/slides/slide{N}.xml |
Slide content |
ppt/notesSlides/ |
Speaker notes |
ppt/slideMasters/ |
Master templates |
ppt/media/ |
Images |
Design Principles
| Principle |
Guideline |
| Fonts |
Use web-safe: Arial, Helvetica, Georgia |
| Layout |
Two-column preferred, avoid vertical stacking |
| Hierarchy |
Size, weight, color for emphasis |
| Consistency |
Repeat patterns across slides |
Converting Between Formats
| Conversion |
Tool |
| Any → PDF |
LibreOffice headless |
| PDF → Images |
pdftoppm |
| DOCX → Markdown |
pandoc |
| Any → Text |
Appropriate extractor |
Best Practices
| Practice |
Why |
| Use formulas in Excel |
Dynamic calculations |
| Preserve formatting on edit |
Don't lose styles |
| Test output opens correctly |
Catch corruption early |
| Use tracked changes for contracts |
Audit trail |
| Extract to markdown for analysis |
Easier to process |
Common Packages
| Language |
Packages |
| Python |
pypdf, pdfplumber, openpyxl, python-docx, python-pptx |
| JavaScript |
docx, pptxgenjs |
| CLI |
pandoc, qpdf, pdftotext, libreoffice |
1---
2name: document-processing
3description: Use when working with "PDF", "Excel", "Word", "PowerPoint", "XLSX", "DOCX", "PPTX", "spreadsheets", "presentations", "extract text", "merge documents", "convert documents", or asking about "office document manipulation"
4version: 1.0.0
5metadata:
6 source: https://skillmd.com/skills/eyadsibai/document-processing
7---
8
9# Document Processing Guide
10
11Work with office documents: PDF, Excel, Word, and PowerPoint.
12
13---
14
15## Format Overview
16
17| Format | Extension | Structure | Best For |
18|--------|-----------|-----------|----------|
19| **PDF** | .pdf | Binary/text | Reports, forms, archives |
20| **Excel** | .xlsx | XML in ZIP | Data, calculations, models |
21| **Word** | .docx | XML in ZIP | Text documents, contracts |
22| **PowerPoint** | .pptx | XML in ZIP | Presentations, slides |
23
24**Key concept**: XLSX, DOCX, and PPTX are all ZIP archives containing XML files. You can unzip them to access raw content.
25
26---
27
28## PDF Processing
29
30### PDF Tools
31
32| Task | Best Tool |
33|------|-----------|
34| Basic read/write | pypdf |
35| Text extraction | pdfplumber |
36| Table extraction | pdfplumber |
37| Create PDFs | reportlab |
38| OCR scanned PDFs | pytesseract + pdf2image |
39| Command line | qpdf, pdftotext |
40
41### Common Operations
42
43| Operation | Approach |
44|-----------|----------|
45| **Merge** | Loop through files, add pages to writer |
46| **Split** | Create new writer per page |
47| **Extract tables** | Use pdfplumber, convert to DataFrame |
48| **Rotate** | Call `.rotate(degrees)` on page |
49| **Encrypt** | Use writer's `.encrypt()` method |
50| **OCR** | Convert to images, run pytesseract |
51
52---
53
54## Excel Processing
55
56### Excel Tools
57
58| Task | Best Tool |
59|------|-----------|
60| Data analysis | pandas |
61| Formulas & formatting | openpyxl |
62| Simple CSV | pandas |
63| Financial models | openpyxl |
64
65### Critical Rule: Use Formulas
66
67| Approach | Result |
68|----------|--------|
69| **Wrong**: Calculate in Python, write value | Static number, breaks when data changes |
70| **Right**: Write Excel formula | Dynamic, recalculates automatically |
71
72### Financial Model Standards
73
74| Convention | Meaning |
75|------------|---------|
76| Blue text | Hardcoded inputs |
77| Black text | Formulas |
78| Green text | Links to other sheets |
79| Yellow fill | Needs attention |
80
81### Common Formula Errors
82
83| Error | Cause |
84|-------|-------|
85| #REF! | Invalid cell reference |
86| #DIV/0! | Division by zero |
87| #VALUE! | Wrong data type |
88| #NAME? | Unknown function name |
89
90---
91
92## Word Processing
93
94### Word Tools
95
96| Task | Best Tool |
97|------|-----------|
98| Text extraction | pandoc |
99| Create new | python-docx or docx-js |
100| Simple edits | python-docx |
101| Tracked changes | Direct XML editing |
102
103### Document Structure
104
105| File | Contains |
106|------|----------|
107| `word/document.xml` | Main content |
108| `word/comments.xml` | Comments |
109| `word/media/` | Images |
110
111### Tracked Changes (Redlining)
112
113| Element | XML Tag |
114|---------|---------|
115| Deletion | `<w:del><w:delText>...</w:delText></w:del>` |
116| Insertion | `<w:ins><w:t>...</w:t></w:ins>` |
117
118**Key concept**: For professional/legal documents, use tracked changes XML rather than replacing text directly.
119
120---
121
122## PowerPoint Processing
123
124### PowerPoint Tools
125
126| Task | Best Tool |
127|------|-----------|
128| Text extraction | markitdown |
129| Create new | pptxgenjs (JS) or python-pptx |
130| Edit existing | Direct XML or python-pptx |
131
132### Slide Structure
133
134| Path | Contains |
135|------|----------|
136| `ppt/slides/slide{N}.xml` | Slide content |
137| `ppt/notesSlides/` | Speaker notes |
138| `ppt/slideMasters/` | Master templates |
139| `ppt/media/` | Images |
140
141### Design Principles
142
143| Principle | Guideline |
144|-----------|-----------|
145| Fonts | Use web-safe: Arial, Helvetica, Georgia |
146| Layout | Two-column preferred, avoid vertical stacking |
147| Hierarchy | Size, weight, color for emphasis |
148| Consistency | Repeat patterns across slides |
149
150---
151
152## Converting Between Formats
153
154| Conversion | Tool |
155|------------|------|
156| Any → PDF | LibreOffice headless |
157| PDF → Images | pdftoppm |
158| DOCX → Markdown | pandoc |
159| Any → Text | Appropriate extractor |
160
161---
162
163## Best Practices
164
165| Practice | Why |
166|----------|-----|
167| Use formulas in Excel | Dynamic calculations |
168| Preserve formatting on edit | Don't lose styles |
169| Test output opens correctly | Catch corruption early |
170| Use tracked changes for contracts | Audit trail |
171| Extract to markdown for analysis | Easier to process |
172
173## Common Packages
174
175| Language | Packages |
176|----------|----------|
177| **Python** | pypdf, pdfplumber, openpyxl, python-docx, python-pptx |
178| **JavaScript** | docx, pptxgenjs |
179| **CLI** | pandoc, qpdf, pdftotext, libreoffice |