Product guides

CSV, Excel or PDF: choosing an export format

Exports come in three formats, each with its own strengths. Pick by what the recipient will do with the file, not by habit.

Editorial illustration for CSV, Excel or PDF: choosing an export format

When a report needs to leave the app, you choose a format: PDF, Excel or CSV. The three are not interchangeable. Each suits a different reader and a different task, and choosing the right one saves the recipient a lot of effort. A few minutes of thought here avoids the awkward email asking for the file in another form.

PDF: for reading

A PDF is a fixed document. It looks the same everywhere and cannot easily be edited, which makes it ideal for reading, filing and sharing a summary. Use it when the recipient needs to see the report as presented: a partner reviewing the month, a lender asking for a statement of spending, or your own archive.

Its weakness is that the numbers are hard to reuse. Copying a table out of a PDF is fiddly and error-prone.

Excel: for working

An Excel file keeps the data in cells that can be sorted, filtered and summed. It suits anyone who will do further analysis: you, an accountant, or a colleague. It can carry several columns and sometimes more than one sheet, and the recipient can check totals with their own formulas.

The cost is that the file is editable, so it is less suitable as an official record you do not want altered.

CSV: for machines

CSV is plain rows of values separated by commas. It carries no formatting, but almost every system can read it. Choose CSV when the file is going into another program, such as accounting software or a database, or when you want the simplest possible container for raw data.

Accounting profiles

Some exports let you pick an accounting profile. The standard option keeps Spendix's own column layout, while others adapt the layout to well-known accounting packages, with ledger names carrying each category. If the file is destined for such software, choosing the matching profile saves reformatting. When unsure, ask the person or program receiving it which layout they expect.

Where exported files live

Generated files are kept in an exports area for seven days. Links you copy from there expire much sooner, around fifteen minutes. If a file has gone, generate it again. Exports are available only to owners, admins and accountants, so a member who cannot find the option may lack that role.

FormatBest forWeakness
PDFReading, filing, sharing a summaryHard to reuse numbers
ExcelAnalysis and checkingEditable, so less formal
CSVImporting into other softwareNo formatting

Sending the right file to the right person

Before sending, think about the reader's tools. An accountant is likely comfortable with Excel or software-specific layouts. A relative reviewing a household summary wants a PDF that opens anywhere. A developer or bookkeeping tool wants CSV. If you are unsure, a short message asking what they prefer takes less time than converting a wrong file.

Name files clearly, with the period and the report title, so they can be found later.

A simple decision rule

Ask what the recipient will do. If they will read, send a PDF. If they will calculate, send Excel. If a program will consume it, send CSV. When the audience is mixed, send two formats rather than compromising. Small file sizes make this cheap.

Finally, check the file before sending. Open it, confirm the period and the total, and be sure it contains only what the recipient should see.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports