← Prompt Library / Data

Data

Data Extractor

Pull structured data out of messy text — emails, PDFs pastes, reports — into a clean table, with confidence flags on the uncertain values.

Extract structured data from this text:

{{text}}

Fields I need: {{fields}}.

Return a clean table with one row per record. Rules: preserve values exactly as written (no 'fixing' numbers or names), mark uncertain extractions with [?] and the reason (ambiguous, partially visible, conflicting mentions), use empty rather than guessed for missing fields, note duplicates rather than silently merging them, and list anything in the text that looks like it should be a record but didn't fit my fields. Output format: {{format}} (table / CSV / JSON) ready to paste.

Fields like {{ this }} are placeholders — replace them with your own details, or let Aria ask you for them.

extraction structuring cleanup

Run this prompt with your real data

This prompt runs with Aria connected to your email, files, CRM and 40+ other services — and you can schedule it to run automatically.

Start Free Week

More Data prompts

Spreadsheet Formula Helper

Get the right Excel or Google Sheets formula for your layout — explained part by part, with a worked...

Dataset First-Look Analysis

Get a structured first read of pasted data: observations with the numbers cited, trends vs noise sep...

Survey Response Synthesiser

Turn open-ended survey answers into themes and quotes.

Chart Recommender

Pick the best chart type for what you want to show.

SQL Query Writer & Optimiser

Write or optimise a SQL query from a plain-English description of the data and the question — with t...

Metric Definition Doc

Pin down a business metric so every team computes it identically: formula, filters, edge cases, and...