5.1Exporting (PDF, Excel, Word, CSV)
The essentials in 30 seconds
- One format per use: PDF to read/print/archive a fixed document, Excel “data only” to analyze and rework, CSV/XML to import into a system, Word/RTF for an editable document.
- PDF is the reference distribution format: a fixed, layout-faithful, printable, non-editable, universal document — essential for finalized statements (invoices, account statements, official reports).
- Verify before distributing: pagination and overflow in PDF, cell usability in Excel — a perfect report in the wrong format misses its target.
Running mini-case — Farès, management controller in Algiers
Farès, a management controller in Algiers, distributes the same monthly budget tracking report to three audiences: management receives the fixed PDF for reading and archiving, analysts receive the “data only” Excel for their pivot tables, and the ERP receives a CSV for import. One month, he mistakenly sends analysts the Excel “with page layout” — unusable merged cells — and a PDF to someone who needed to rework the figures. He decides to formalize one export rule per recipient. This case returns in the lesson, the diagram, the script and the 48h challenge — and continues in 5.2, 5.3 and 5.4.
This same case returns in the lesson, the diagram, the script and the 48h challenge — and continues in 5.2, 5.3 and 5.4.
1. Outputting the report in a format
A report only has value if it is distributed: exporting outputs it in various formats according to use, via “File → Export” (or the export icon). Farès learned this the hard way: the same budget report must exist in three forms depending on who receives it.
PDF: the distribution format par excellence — fixed document, faithful to the layout, printable, non-editable, universal. Excel: so the recipient can rework the data. Word/RTF: to include the content in an editable document. CSV/text: raw data exchange. HTML, XML for integration and the web.
2. Choose according to use
Read/print a finalized document (invoice, statement, official report) → PDF (faithful, universal, non-editable). Analyze/rework data (sort, filter, calculate) → Excel “data only” (values in clean cells). Include in an editable document → Word/RTF. Exchange with a system (machine to machine) → CSV/XML. Farès applies exactly this grid: management → PDF, analysts → data-only Excel, ERP → CSV.
Excel export “with page layout” reproduces the report appearance but creates merged cells that complicate analysis — prefer “data only” for reworking. Typical mistakes: a PDF for someone who must manipulate figures (nothing usable), an editable format for an official document that should stay fixed.
3. Verify before distributing
Check the result: does the layout hold in PDF (pagination, width overflow, split groups, blank pages)? Is the Excel data usable (aligned columns, calculable numbers)? Farès opens every export before sending: a one-minute check avoids a round trip with three recipients.
Export can be automated (scheduling, application integration — 5.3) for mass distribution. If rendering is poor: in PDF, switch to landscape, adjust columns and margins, set “Keep Together” and page breaks; in Excel, switch to “data only” and check types. A perfect report poorly exported misses its target.
Did you know?
A perfect report in the wrong format misses its target.
🔎 Concrete example — The right format for each of Farès's targets
Two recipients, two choices — plus the system.
Invoice to send to the customer → PDF (faithful, non-editable).
Figures for the analyst → “data only” Excel.
Import into the ERP → CSV.Reading: each recipient receives a file suited to their real use.
Lesson: check pagination (PDF) and usability (Excel) before distribution.
Section vocabulary
- Exporting
- Outputting the report in a format suited to its use, via “File → Export”.
Simple example: Farès exports budget tracking in PDF, Excel and CSV according to recipients.
What it is not: simply saving the working file.
Reflex: can the recipient do what they must do with this file?
- PDF export
- The fixed distribution format: faithful to the layout, printable, non-editable, universal.
Simple example: Farès sends the monthly invoice in PDF in Algiers for reading and archiving.
What it is not: a format for reworking or calculating figures.
Reflex: must this document stay fixed and printable?
- Data-only Excel
- The export that places values in clean cells, without layout, for analysis.
Simple example: Farès's analysts receive usable columns in a pivot table.
What it is not: the “with page layout” export with merged cells.
Reflex: do my cells sort and calculate?
- CSV export
- Raw data exchange, without formatting, meant to be read by software.
Simple example: Farès provides a CSV to the ERP for the monthly import.
What it is not: a file meant to be read by a human.
Reflex: is a machine or a person going to read this file?
- Choice by use
- The rule that matches each recipient with the format suited to their real use.
Simple example: Farès writes: management → PDF, analysts → Excel, ERP → CSV.
What it is not: the same file sent to everyone.
Reflex: do I have one export rule per recipient?
In practice — Export a report
- Export to PDF (“File → Export” → PDF) for a finalized document to read/print; check layout fidelity and pagination.
- Export to “data only” Excel to let the recipient analyze/rework the figures.
- Choose the format by USE: PDF (reading), Excel (analysis), Word (editable), CSV (raw data).
- Check the export result (layout in PDF, data usability in Excel) before distributing.
Ready-to-say script — announce distribution to recipients
“Each month, you will receive this budget tracking in the format suited to your use: management receives a fixed PDF for reading and archiving, analysts a data-only Excel for their analyses, and the ERP a CSV for import. If a format does not suit you — unusable columns, cut-off layout — tell me before the next distribution and I will adjust.”
Say to recipients to frame export formats from the first distribution.
Copy-paste template — export rule sheet
EXPORT RULE SHEET — report: ___
RECIPIENT 1: ___ · USE: read/print → FORMAT: PDF · CHECKED ON: ___
RECIPIENT 2: ___ · USE: analyze → FORMAT: Excel data only · CHECKED ON: ___
RECIPIENT 3: ___ · USE: import → FORMAT: CSV · CHECKED ON: ___
CHECK: PDF pagination OK? YES / NO · Excel cells usable? YES / NOSolo / tight budget
Farès alone: one PDF for management and one data-only Excel for himself are enough to start.
Very small business / small team
Two formats shown in the sending email: PDF to read, Excel to analyze — everyone takes theirs.
SME in Algiers
Farès in Algiers schedules a monthly group send: PDF to management, Excel to analysts, CSV to accounting for the ERP.
Starting team
Pair: one exports and verifies, the other checks pagination and cells before the group send.
✓ Best practices
- PDF for a fixed document to read/print; “data only” Excel to analyze.
- Switch to landscape if the PDF overflows in width.
- Test the export with real data before distributing.
✗ Common pitfalls
- Sending a “with page layout” Excel to someone who wants to analyze (merged cells).
- Sending a PDF to someone who must rework the data (nothing manipulable).
- An editable format for an official document that should stay fixed.
Key takeaways
- EXPORTING (“File → Export”) outputs the report in various FORMATS by use: PDF, Excel, Word/RTF, CSV, HTML, XML… It is the step that turns a designed report into a DISTRIBUTED document.
- PDF = the reference DISTRIBUTION format: FIXED document, faithful to the layout, printable, non-editable, universal. Essential for fixed-format documents (invoices, official statements).
- “Data only” EXCEL = the right choice so the recipient can REWORK figures (the “with page layout” export reproduces appearance but complicates analysis).
- CHOOSE the format by USE: reading/printing → PDF; analysis → Excel; editable → Word; raw data → CSV. Verify the export (PDF pagination, Excel usability). Export can be AUTOMATED (5.3).
48h challenge — apply tomorrow
Fill in the export rule sheet (template above) for 1 real report by Farès: does each recipient have their adapted and verified format?
- I can name the right format to read, analyze and import.
- My export rule per recipient is written and verified.
- I know why “page layout” Excel blocks analysis.
Frequently asked questions
Which export format should I choose based on what the recipient must do with the report?
The criterion is USE. READ/PRINT/ARCHIVE a finalized fixed document (invoice, statement, official report) → PDF: it preserves the layout exactly, is universal, non-editable, printable — the default choice. ANALYZE/REWORK figures (sort, filter, calculate, pivot tables) → “DATA ONLY” Excel (values in clean cells; avoid “with page layout” which creates merged cells that are hard to use). INCLUDE in an editable text document → Word/RTF. IMPORT into another system (machine to machine) → CSV (or XML). Mistakes: sending a “page layout” Excel to someone who wants to analyze; a PDF to someone who must rework; an editable format for a document that must stay fixed. Matching format to use is essential — a perfect report in the wrong format misses its target.
My export (PDF or Excel) does not render well: what are the causes and solutions?
PDF (layout): WIDTH OVERFLOW → switch to LANDSCAPE, reduce/remove columns, check the printable area; poor PAGINATION (split groups, blank pages) → section options “Keep Together”, “New Page”, “Suppress blanks”; objects that OVERLAP or truncate with real data → widen fields, enable auto-grow, test with real data; gap with preview → standard fonts. Always check the PDF before distribution. Excel (structure): MERGED cells and awkward structure (“with page layout” export) → use “DATA ONLY”; shifted columns → align fields or “data only”; numbers as text (do not calculate) → check types. General method: choose the format SUITED to use and test with real data.
Which export lets the recipient rework figures?