---
title: "How to Export my Data & Documents in a Spreadsheet"
description: "Export your documents from Receiptor AI as a spreadsheet, with one row per document and all extracted fields in columns, including a direct link to the original PDF."
url: https://help.receiptor.ai/en/articles/12087619-how-to-export-my-data-and-documents-in-a-spreadsheet
collection: "Export & Integrations"
updated: 2026-11-07
language: en
---

# How to Export my Data & Documents in a Spreadsheet

Export your documents from Receiptor AI as a spreadsheet, with one row per document and all extracted fields in columns, including a direct link to the original PDF.

In some cases, you might want to get a CSV export, to turn your documents and data into a spreadsheet. This is how Receiptor AI does it for you.

## What you get

A CSV export produces a **spreadsheet where each row is one document**, and **each column is a field** from your chosen template: date, merchant, amount, category, payment status, and so on. Every row also includes a direct link to the original PDF, so you can open the source document straight from the spreadsheet.

If you enable **Include Line Items**, the layout changes: each line item on a document gets its own row, with the document-level fields (merchant, date, totals) repeated alongside the item-level detail.

![](https://staticfiles.gleap.io/gattachments/58qLkRMRGDpQi82XxeodquTNbVyV4rqEnpndvDYPbkr8O3udfkEWuqN6QptNkjPhdCzGLjnFa8l.png)

## How to Export as CSV

1.  In the [**Documents section**](https://app.receiptor.ai/documents)
    
2.  Select the documents you want to export using the checkboxes. Use the filters or tabs (e.g., **To Export**, **Last Extracted**) to narrow down your selection first if needed.
    
3.  Click **Export**.
    
4.  Choose **CSV** as the format.
    
5.  Select the CSV template you want to use (see below).
    
6.  Click **Export** to generate and download the file.
    

![](https://staticfiles.gleap.io/gattachments/Sm9BB1EvBqf3QjkCQob0MV80SM49pqCQGru0qGppI9nxMWDX0FAL8iXarYVGmBITMLoigzaEViH.png)

## Choose a CSV template

### Pre-built system templates

When you export as CSV, you choose which fields to include by picking a template. Receiptor AI comes with six pre-built templates:

<table data-id="1df2b369-7e06-4fbb-83c0-8b2d1b9280ac" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="b7981ad4-e92d-4f35-a6ab-b8a07b15749b"><strong>Standard Export</strong></p></td><td colspan="1" rowspan="1"><p data-id="ceefbdb6-d719-437c-b0fc-9a16d6654866">General bookkeeping, the most commonly used fields</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="64e0b084-5c3f-4fb1-8478-b19a45caba75"><strong>Detailed Export</strong></p></td><td colspan="1" rowspan="1"><p data-id="6c8108cc-f14d-4cd6-b704-dac7d36bad39">Comprehensive export with all main fields</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="38205c6d-2a83-461f-b312-b2bb446e9987"><strong>Accounting Export</strong></p></td><td colspan="1" rowspan="1"><p data-id="285f1815-8189-4661-86df-a8474e5b95b7">Optimized for import into accounting software</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="2590abf4-4261-4b7e-9eac-32b774180a45"><strong>Tax Report</strong></p></td><td colspan="1" rowspan="1"><p data-id="02192c89-9362-4a4f-a72b-0d844c6f21a7">Focused on tax-related information</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="cd0510b5-fe0f-4966-a950-084a85f1282a"><strong>Line Items Export</strong></p></td><td colspan="1" rowspan="1"><p data-id="db38c1a0-b1d7-416c-b961-0dc8e482a20d">One row per line item instead of one row per document</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="814ebb13-6e3a-4b31-a3cb-a07d8569adf4"><strong>Minimal Export</strong></p></td><td colspan="1" rowspan="1"><p data-id="b54b5d26-5cda-4ac2-ab62-9b0e67fe8830">Essential fields only: date, merchant, amount, category</p></td></tr></tbody></table>

![](https://staticfiles.gleap.io/gattachments/ede1jajqqJujzrZ5fNHnW1NxYKlcLVqfg6G9o3WuESm1yRZDoxEfiwPUb5J4IfES4W6HkFsSVjN.png)

### Custom templates

If none of the pre-built templates fit your workflow, you can create your own:

1.  Navigate to **Settings >** [**Export Templates**](https://app.receiptor.ai/settings/export-templates).
    
2.  Click **Create template**.
    
3.  Enter a **Name** and an optional description.
    
4.  Select the fields you want to include. Fields are grouped by category:
    

<table data-id="1a8a5a71-1d1a-4c9e-9665-a98d32fe65a4" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="a6f190fb-969f-46f9-b3bb-e1edc48cb90d"><strong>Basic Information</strong></p></td><td colspan="1" rowspan="1"><p data-id="c0795835-b585-475d-aff0-f00f95b5002c">Received At, Created At, Transaction Date, Transaction ID, Merchant, Amount, Amount Currency, Category, Doc Type</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="be254428-ee62-4add-9e3b-de706e414c8e"><strong>Payment Details</strong></p></td><td colspan="1" rowspan="1"><p data-id="ccdc59d1-b3cc-4e48-8327-7327322625f8">Payment Method, Payment Method Ending, Payment Status, Amount Paid, Amount Due</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="9c5fd834-170f-45cd-86fc-76c39cdb7326"><strong>Tax Information</strong></p></td><td colspan="1" rowspan="1"><p data-id="118d43bf-50cc-47f1-a40d-b7cc8c1844ed">Tax Rate, Tax Type, Tax Amount, Subtotal</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="904a3840-ee7e-4fc0-96e9-d27616860de1"><strong>Document Details</strong></p></td><td colspan="1" rowspan="1"><p data-id="6b3538b6-a9e0-4e68-98fd-f6f257447e43">Invoice ID, Invoice Date, Receipt ID, Filename, From, To, Billing Period Start, Billing Period End, Dispute Deadline, Summary, Statement Description</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="4e2b1e89-0c35-4b6a-b884-0b9efadfb077"><strong>Merchant</strong> <strong>Information</strong></p></td><td colspan="1" rowspan="1"><p data-id="3f7ce5bd-0269-4db2-893c-de1f951e6be3">Merchant Address, Merchant Tax ID, Merchant Website</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="c62b87e0-97f3-4558-aee6-ce9450985713"><strong>Currency Conversion</strong></p></td><td colspan="1" rowspan="1"><p data-id="c012e8e5-df02-4fb0-92b7-eb787ca205a9">Total (Converted), Total Currency, Conversion Rate, Preferred Currency</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="31efb466-e6e4-49e9-a522-8f0b76cf79ce"><strong>Other</strong></p></td><td colspan="1" rowspan="1"><p data-id="7880f08e-a7b4-4142-885c-a3de6993f178">Attachment URL</p></td></tr></tbody></table>

5.  Toggle **Include Line Items** on if you want one row per line item instead of one row per document.
    
6.  Click **Save**.
    

Your template will appear in the template picker the next time you export as CSV.

![](https://staticfiles.gleap.io/gattachments/yGHPYagTZ6qUL3iD7XwtOLtiRx3pwqDWL0xoVTuqcNwjCAuPdI0w1kcfIaDyvo4xPpuiDoEOspv.png)

## Automating recurring CSV exports

You can schedule a CSV export to run automatically on any cadence (daily, weekly, monthly, or any custom interval) using a scheduled automation rule.

1.  Go to **Automations**.
    
2.  Click **Create Automation**.
    
3.  In **Basic Information**, give the rule a name (e.g., "Weekly CSV export to accountant").
    
4.  Set the **Trigger** to **On Schedule** and enter your cron expression and timezone. For example, every Monday at 8am is `0 8 * * 1`.
    
5.  Add **Conditions** if you want to filter which documents are included. For example, you can limit the export to a specific document type, a date range, a merchant, or a payment status.
    
6.  In **Actions**, add **Export as CSV** and select the template to use.
    
7.  Save the rule.
    

From this point, Receiptor AI will automatically export the matching documents as a CSV on your chosen schedule.

![](https://staticfiles.gleap.io/ghelparticle/3QD7E8GL3GbMkbAYNZCpo36oVADO2JywYS26m3j6zsJV9hcfOT0RDw9bDZKfxn7w3QihOdIf53D.png)

## Common questions

**Q: What is the difference between "one row per document" and "one row per line item"?**  
A: By default, each document produces one row in the CSV with a summary of all its fields. If you enable Include Line Items, each individual line item on a document gets its own row, with the document-level fields repeated. Use the Line Items Export template or enable this toggle on a custom template when you need itemized data.

**Q: Can I use a custom template for automated scheduled exports?**  
A: Yes. When setting up an automation with a scheduled CSV export action, you can select any of your saved custom templates.

**Q: My export failed. What should I do?**  
A: Go to **Exports** in the left sidebar and check the status of the job. If it shows as failed, click the three-dot menu to **Copy Job ID** and share it with support via live chat or at [info@receiptor.ai](mailto:info@receiptor.ai).

**Q: The Amount field shows a different currency than expected. Why?**  
A: The Amount field reflects the original document currency. To get amounts converted to your workspace's preferred currency, include the **Total (Converted)** and **Preferred Currency** fields from the Currency Conversion group.

* * *

## Support

Still have questions? Reach out via the in-app chat or at [info@receiptor.ai](mailto:info@receiptor.ai).
