Is the receipt CSV ready for every expense application?

No single CSV layout fits every importer. Review the extracted columns and adapt them to the template your destination requires.

How are receipt discounts represented in CSV?

Recognition follows the visible receipt, which may use separate lines or negative amounts. Check the sign and association with the correct item.

Should the receipt subtotal be imported as a purchase item?

Usually it should be kept separate from line items to avoid double counting. Choose the structure appropriate for your own reporting process.

Can I combine many receipt CSV files without cleanup?

Different shops use different layouts and abbreviations. Standardize headers, currency and item naming before combining reviewed exports.

How do I get the merchant name and date into the receipt CSV?

They come through as single-cell rows above the items, not as columns, so copy them into the destination columns yourself. For named vendor, date, total and tax fields, Receipt Extractor returns those values as JSON and is the better fit when you only need the header details.

Why does one receipt item take two rows in the grid?

A long product name wraps onto a second printed line, and the reader can treat each printed line as a row. Move the extra words into the item's description cell and delete the spare row, so the quantity and price stay on the line they belong to.

Will pound, euro or other currency symbols be kept in the CSV?

They are read as characters like any other text, so check them against the paper. Because the file is UTF-8 without a byte-order mark, import it with UTF-8 selected if a symbol looks garbled in a spreadsheet. Prices are plain text in the file, so the importer applies the number format.

What should I do when the page says no table was found?

The reader could not see clear rows on the receipt. Retake the photo closer and flatter, in even light, with item names and prices both in frame, and crop away the surroundings. Then convert again, and try Table AI (beta) in Settings if a sharp photo still fails.

Is there a quick way to process a whole month of receipts?

Premium accounts can use Batch mode to convert a stack of receipt photos with the same settings and receive one CSV per photo in a ZIP, without a review grid. For a month you want to review, the Excel version of this page can save each checked receipt to History and build one combined workbook.

Do receipt photos from a phone have to be JPG files?

No. The upload takes the common image formats, including JPG, PNG, WEBP, HEIC and TIFF, so a photo from an iPhone can be chosen as it is, without converting it to JPG first.

Image to CSV

Receipt to CSV — Prepare Itemized Purchase Records

Choose your image

Choose an itemized receipt image with clear prices

Convert a receipt image into CSV line items for review. Check discounts, tax rows and wrapped descriptions before importing the purchase records elsewhere.

Custom expense-import preparation
Comparing basket costs across shops

Upload your table image

Choose an itemized receipt image with clear prices

All image formats (JPG, PNG, WEBP, HEIC, TIFF…)

Receipt to CSV: turn a receipt photo into rows for an expense import

This receipt to CSV page reads the printed lines of a receipt photo into an editable grid and saves them as comma-separated rows. It is made for the item list: product, quantity and price on one line each, with discounts and tax kept apart from purchases. You decide which rows belong in the file and which header names your expense template wants, then export a plain .csv.

What a receipt gives the table reader

A receipt is a narrow column of text, not a grid. The store name, address and date sit at the top and arrive as single-cell rows, the items follow, and the subtotal, tax, total and payment lines close the page. A product name that wraps can leave its second half on a row with no price. If the page reports that no table was found, retake the photo closer and flatter so the price column lines up. For the words only, read the receipt as plain text.

Separate items from totals, tax and payments

Only the item lines belong in an expense or purchase import. Delete the subtotal, tax, total, cash tendered, change and card lines, or keep the total on one row you label yourself, so an importer never adds a purchase twice. A discount printed with a minus sign is a real adjustment; keep the sign and make sure it sits beside the item it reduces.

Photograph the full receipt straight on, from the header to the last payment line.
Open the grid and delete every row that is not a purchased item.
Check each price, quantity and discount sign against the paper.
Choose See result, download the CSV and map it in the importer.

Add what the receipt does not put in a column

Expense templates ask for fields a receipt never tabulates: the merchant, the date, a category and an account. The merchant and date appear in the grid as single-cell rows, not as a column on each item, so copy them into the template yourself, or use the receipt reader that returns vendor, date, total and tax when you need them as named fields. One receipt gives one CSV, so keep each in its own photo.

Check currency symbols and encoding on import

The file is UTF-8 text without a byte-order mark, so a symbol such as the pound or euro sign can look wrong when a spreadsheet opens it with another encoding. Use the application's import option, choose UTF-8 and the comma delimiter, and set the price columns to your regional number format. Decimal commas are read as characters, so compare a few prices with the paper after the import.

Before you import receipt rows

Smooth the paper and keep thumbs and shadows off the print.
Use one receipt per photo so lines from two receipts never interleave.
Normalize shop abbreviations before you compare products across stores.
For saved receipts with daily totals, use receipt to Excel.

Expense import templates need clean rows, not receipt photos

Read a receipt's item list into a plain CSV file for your own expense workflow. Receipts rarely follow a single table layout, so separate purchased items from totals and payment details before importing the result.

Custom expense-import preparation

Recover purchase rows, then add the category and account columns required by your chosen expense template.

Comparing basket costs across shops

Build reviewed receipt records and normalize abbreviations manually before comparing similar products from different stores.

Separate purchases from discounts and payment lines

Capture the full item list with clear discount and total lines.
Correct product descriptions and distinguish refunds or discounts from positive charges.
Download CSV, map the destination fields and test the import with reviewed records.

Receipt import layouts, discount signs and duplicate totals

Is the receipt CSV ready for every expense application?: No single CSV layout fits every importer. Review the extracted columns and adapt them to the template your destination requires.
How are receipt discounts represented in CSV?: Recognition follows the visible receipt, which may use separate lines or negative amounts. Check the sign and association with the correct item.
Should the receipt subtotal be imported as a purchase item?: Usually it should be kept separate from line items to avoid double counting. Choose the structure appropriate for your own reporting process.
Can I combine many receipt CSV files without cleanup?: Different shops use different layouts and abbreviations. Standardize headers, currency and item naming before combining reviewed exports.
How do I get the merchant name and date into the receipt CSV?: They come through as single-cell rows above the items, not as columns, so copy them into the destination columns yourself. For named vendor, date, total and tax fields, Receipt Extractor returns those values as JSON and is the better fit when you only need the header details.
Why does one receipt item take two rows in the grid?: A long product name wraps onto a second printed line, and the reader can treat each printed line as a row. Move the extra words into the item's description cell and delete the spare row, so the quantity and price stay on the line they belong to.
Will pound, euro or other currency symbols be kept in the CSV?: They are read as characters like any other text, so check them against the paper. Because the file is UTF-8 without a byte-order mark, import it with UTF-8 selected if a symbol looks garbled in a spreadsheet. Prices are plain text in the file, so the importer applies the number format.
What should I do when the page says no table was found?: The reader could not see clear rows on the receipt. Retake the photo closer and flatter, in even light, with item names and prices both in frame, and crop away the surroundings. Then convert again, and try Table AI (beta) in Settings if a sharp photo still fails.
Is there a quick way to process a whole month of receipts?: Premium accounts can use Batch mode to convert a stack of receipt photos with the same settings and receive one CSV per photo in a ZIP, without a review grid. For a month you want to review, the Excel version of this page can save each checked receipt to History and build one combined workbook.
Do receipt photos from a phone have to be JPG files?: No. The upload takes the common image formats, including JPG, PNG, WEBP, HEIC and TIFF, so a photo from an iPhone can be chosen as it is, without converting it to JPG first.