Turning a pile of order emails into a spreadsheet
Order confirmations, form submissions, and receipt emails usually share one useful trait: every one of them repeats the same fields in the same order, just with different values. That repeated shape is exactly what you need to turn dozens of emails into one clean table — without typing anything by hand.
The pattern to look for
Each record should look like a short block of "Label: value" lines, separated by a blank line from the next record. For example:
Order: 1042 Customer: Ana Lee Email: ana@acme.com Total: $120.00 Order: 1043 Customer: Ben Cho Email: ben@acme.com Total: $85.50
If your emails look roughly like this — even if the exact wording of the labels varies a little — you're in good shape.
The steps
- Select and copy the relevant text from each email. You don't need to clean it up first — stray greetings or signatures above and below each block are fine, as long as the "Label: value" lines stay intact.
- Paste everything — all the records, one after another — into Paste to Table, with a blank line between each record.
- Switch the detection mode to "Key: value blocks." This mode treats each blank-line-separated chunk as one row, and turns every unique label it finds (Order, Customer, Email, Total...) into a column.
- Check the result. If a field is missing in one email but present in others, that cell just comes out blank — it won't break the rest of the table.
- Export as CSV for Excel, or copy straight into Google Sheets with "Copy for Excel."
When this doesn't work well
If your source emails use completely different wording for the same field ("Order #" in one, "Order ID" in another), the tool will treat them as two separate columns. The fix is usually a quick find-and-replace on the pasted text before converting — standardize the labels, then convert.