Credentials
Stored encrypted and decrypted only while a job is running. Use an IAM user scoped to the bucket below.
Temporary credentials
Leave empty for a long-lived IAM user key.
Location
Where browsing starts. Leave it empty to start at the top of the bucket. Saved work addresses objects by their full path, so this is a starting point rather than a restriction.
Extract Parquet Receipt to MySQL
Convert Parquet receipts into structured MySQL data with itemized purchases, subtotals, tax, and totals.
Connectors
Read straight from the systems your data already lives in, instead of uploading a file.
Capture every receipt line item. Output structured data in any format.
Upload Parquet receipts to extract itemized purchases into clean files. Each line item, subtotal, tax, and total is parsed into structured rows ready for analysis and reconciliation.
THANK YOU
THANK YOU
THANK YOU
THANK YOU
THANK YOU
| Item Description | Price |
|---|---|
| FARE | 41.25 |
| TIP | 8.00 |
| TOTAL | 49.25 |
| FOOD & DRINK | Price |
|---|---|
| ROAST CHICKEN | $24.00 |
| CAESAR SALAD | $13.00 |
| SPARKLING WATER x2 | $8.00 |
| SUBTOTAL | $45.00 |
| TAX (10.25%) | $4.61 |
| TOTAL | $49.61 |
| Item Description | Price |
|---|---|
| FLAT WHITE | 5.25 |
| BREAKFAST BURRITO | 11.75 |
| SUBTOTAL | 17.00 |
| TAX | 1.74 |
| TOTAL | 18.74 |
| Item Description | Price |
|---|---|
| POSTER TUBE | 6.49 |
| POSTER TUBE | 6.49 |
| BINDER CLIPS | 3.29 |
| PRINTING 25 PG | 7.50 |
| PRINTING 25 PG | 7.50 |
| SUBTOTAL | 31.27 |
| DISCOUNTS | 00.00 |
| TAX 10.25% | 3.21 |
| TOTAL | 34.48 |
| CHARGES | Price |
|---|---|
| 09/14 ROOM | 219.00 |
| 09/14 ROOM TAX | 38.31 |
| 09/15 ROOM | 219.00 |
| 09/15 ROOM TAX | 38.30 |
| 09/16 ROOM | 219.00 |
| 09/16 ROOM TAX | 38.30 |
| TOTAL | 771.91 |
| PAYMENT VISA | -771.91 |
| BALANCE DUE | 0.00 |
From individual receipts to consolidated expense reports
Extract receipts individually, standardize column headers, and store them as workspace datasets. When you are ready at month-end, consolidate multiple receipts into a single table and export.
-
1
Extract line-item data
Upload a Parquet receipt. Every printed line is parsed into structured rows, isolating individual items, subtotals, taxes, and totals.
Item Description Price FARE 41.25 TIP 8.00 TOTAL 49.25 IMG_2041.sql · 3 rowsFOOD & DRINK Price ROAST CHICKEN $24.00 CAESAR SALAD $13.00 SPARKLING WATER x2 $8.00 IMG_2046.sql · 6 rows, 3 more belowItem Description Price FLAT WHITE 5.25 BREAKFAST BURRITO 11.75 SUBTOTAL 17.00 IMG_2052.sql · 5 rows, 2 more belowItem Description Price POSTER TUBE 6.49 POSTER TUBE 6.49 BINDER CLIPS 3.29 IMG_2055.sql · 9 rows, 6 more belowCHARGES Price 09/14 ROOM 219.00 09/14 ROOM TAX 38.31 09/15 ROOM 219.00 IMG_2071.sql · 9 rows, 6 more below -
2
Standardize columns
Column names can differ from one receipt to the next. Rename the description column to Item and add a Receipt identifier so every receipt's rows line up when merged.
Item Description→ Item + Receipt = “Taxi 09-14”FOOD & DRINK→ Item + Receipt = “Dinner 09-14”Item Description→ Item + Receipt = “Breakfast 09-15”Item Description→ Item + Receipt = “Supplies 09-15”CHARGES→ Item + Receipt = “Hotel 09-14–17” -
3
Save as dataset
Store parsed receipt data securely in your workspace as structured datasets, ready for consolidation at any time.
Taxi 09-14 Dinner 09-14 Breakfast 09-15 Supplies 09-15 Hotel 09-14–17 -
4
Consolidate receipts
Combine saved receipt datasets into a single unified table, whether consolidating five receipts or fifty.
-
5
Summarize and export
Group the merged rows by Item to count line items across receipts, then download the consolidated table in your preferred format.
Summarize DataExport AsItem Count TOTAL 1 Export asExcelCSVJSON
Automate receipt data extraction via API
Trigger receipt parsing directly from your code. Submit receipt photos or PDFs to the endpoint and receive structured line items, tax breakdowns, and totals as JSON, CSV, or Excel payloads.
Explore the APIcurl -X POST "https://dataconverter.io/api/v1/convert/parquet-to-mysql" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "file=@kessler-kitchen.parquet" \ --output IMG_2046.sql✓ 200 OK · IMG_2046.sql · 6 rows
Frequently asked questions
Which receipt formats and layouts are supported?
The parser handles printed register receipts, restaurant bills, taxi slips, retail invoices, and hotel folios. It parses the document text directly rather than matching static merchant templates, ensuring reliable line-item extraction across any layout.
Can I upload photos directly from a smartphone?
Yes. You can upload receipts in JPEG, PNG, or WebP formats. Because iOS devices capture photos in HEIC format by default, select Most Compatible in Camera Formats to save as JPEG, or take a screenshot of the photo to upload directly.
Can I consolidate multiple receipts into a single file?
Yes. Extract receipts individually and save each one as a workspace dataset. Then, use the Merge Data tool to consolidate them into a unified table. Standardizing column headers like Item beforehand ensures rows align automatically.
Can I extract digital PDF receipts from email confirmations?
Yes. Select PDF as the source format. The parser extracts line items, taxes, and totals from digital PDF receipts using the exact same workflow as image uploads.