Zum Inhalt springen
Agentic Workflowdocs
v0.8.2Kostenlos installieren

rezepte / extract data

Copy any table on a page as CSV

Run it on a page with a table and paste clean CSV into a spreadsheet. The first row becomes the header. No account, no AI.

Dieser Inhalt ist noch nicht in deiner Sprache verfügbar.

Anfänger 3 Min. Keine Einrichtung Daten extrahieren

Workflow · table-to-csv.awf 4 Schritte

Page Table to CSV: ein Workflow mit 4 Schritten, beginnend mit When Started und endend mit Copy to clipboard.

  1. When Started(Auslöser – zur Dokumentationsseite)
  2. Read the table(Get Structured Data – zur Dokumentationsseite)
  3. Build CSV(CSV – zur Dokumentationsseite)
  4. Copy to clipboard(Clipboard Write – zur Dokumentationsseite)
In AWFlow öffnen
Run it → read the table → build CSV → copy to the clipboard.

How it works

Section titled “How it works”

  1. Run it on the page

    When Started Knoten-Referenz

    When Started has no settings; run it from the right-click menu on the page with the table.

    Step 1, close-up of the app: When Started, outlined.Step 1, close-up of the app: When Started, outlined.Vollbild
    When Started
    The workflow editor with the Page Table to CSV recipe: sticky notes and the steps When Started, Read the table, Build CSV, Copy to clipboard, linked left to right. The top bar shows the Workflow active switch and Save; Test Workflow is above the canvas.The workflow editor with the Page Table to CSV recipe: sticky notes and the steps When Started, Read the table, Build CSV, Copy to clipboard, linked left to right. The top bar shows the Workflow active switch and Save; Test Workflow is above the canvas.

  2. Read the table

    Get Structured Data Knoten-Referenz

    Get Structured Data in table mode reads the first table on the page, one item per row, using the first row as the column names.

    Passen Sie es an — set DOM Selector to the table you want, such as #results table, when the page has several.

    Step 2, close-up of the app: The DOM Selector field, outlined.Step 2, close-up of the app: The DOM Selector field, outlined.Vollbild
    The DOM Selector field
    The settings of the Read the table step: DOM Selector with its picker, and Options with Mode and Table first row is header.The settings of the Read the table step: DOM Selector with its picker, and Options with Mode and Table first row is header.

  3. Build the CSV

    CSV Knoten-Referenz

    CSV Build turns the rows into CSV text in the csv field, quoting values that need it.

    Passen Sie es an — change Delimiter to ; for spreadsheets set to a European locale.

    Step 3, close-up of the app: The Delimiter menu, outlined.Step 3, close-up of the app: The Delimiter menu, outlined.Vollbild
    The Delimiter menu
    The settings of the Build CSV step: Operation Build from items, CSV Text, Source Field, Delimiter “,”, and the header, trim and quote switches.The settings of the Build CSV step: Operation Build from items, CSV Text, Source Field, Delimiter “,”, and the header, trim and quote switches.

  4. Copy it

    Clipboard Write Knoten-Referenz

    Clipboard Write copies the CSV, ready to paste into Google Sheets, Excel or Numbers.

    Passen Sie es an — download a .csv file with Save as File instead.

    Step 4, close-up of the app: Copy to clipboard, outlined.Step 4, close-up of the app: Copy to clipboard, outlined.Vollbild
    Copy to clipboard
    The workflow editor with the Page Table to CSV recipe: sticky notes and the steps When Started, Read the table, Build CSV, Copy to clipboard, linked left to right. The top bar shows the Workflow active switch and Save; Test Workflow is above the canvas.The workflow editor with the Page Table to CSV recipe: sticky notes and the steps When Started, Read the table, Build CSV, Copy to clipboard, linked left to right. The top bar shows the Workflow active switch and Save; Test Workflow is above the canvas.

Test it

Section titled “Test it”

  1. Install the recipe and save it. No setup is needed. To import the file yourself, use Add Workflow › Import, choose the .awf and click Create & open. Then click Make it mine at the bottom of the canvas, tick the box and confirm, so you can edit it.

    Step 1, close-up of the app: Create & open, outlined.Step 1, close-up of the app: Create & open, outlined.Vollbild
    Create & open
    The Create a workflow dialog at step 3, Name & save, after importing table-to-csv.awf: Source Imported .awf, Name “Page Table to CSV”, an optional Description, Where to save “Saved locally in this browser”, and the Back and Create & open buttons.The Create a workflow dialog at step 3, Name & save, after importing table-to-csv.awf: Source Imported .awf, Name “Page Table to CSV”, an optional Description, Where to save “Saved locally in this browser”, and the Back and Create & open buttons.
    Step 1, close-up of the app: Make it mine, outlined.Step 1, close-up of the app: Make it mine, outlined.Vollbild
    Make it mine
    The Make this workflow yours? dialog over the Page Table to CSV workflow: it came from the Marketplace, It can currently lists what the workflow may access, two notes on what changes, the “I'm responsible for what this workflow does from now on.” checkbox, and Cancel and Make it mine.The Make this workflow yours? dialog over the Page Table to CSV workflow: it came from the Marketplace, It can currently lists what the workflow may access, two notes on what changes, the “I'm responsible for what this workflow does from now on.” checkbox, and Cancel and Make it mine.
    Step 1, close-up of the app: Save, outlined.Step 1, close-up of the app: Save, outlined.Vollbild
    Save
    The workflow editor with the Page Table to CSV recipe: sticky notes and the steps When Started, Read the table, Build CSV, Copy to clipboard, linked left to right. The top bar shows the Workflow active switch and Save; Test Workflow is above the canvas.The workflow editor with the Page Table to CSV recipe: sticky notes and the steps When Started, Read the table, Build CSV, Copy to clipboard, linked left to right. The top bar shows the Workflow active switch and Save; Test Workflow is above the canvas.

  2. Open a page with a table, such as a Wikipedia list.

  3. Right-click it and choose Agentic Workflow › Personal Workflows › Page Table to CSV.

  4. Paste into a new spreadsheet: each column lands in its own cell.

Variations

Section titled “Variations”
Variation What to change Level
Send rows to a sheet Replace CSV and Clipboard Write with Google Sheets Append. Intermediate
Keep only some rows Add Filter or Sort between the table and the CSV. Beginner
Lists instead of tables Set Get Structured Data Mode to list for ul or ol lists. Beginner

Troubleshoot

Section titled “Troubleshoot”
  • The wrong table is copied. The page has several tables. Set DOM Selector to the one you want; the data extraction guide shows how to find a selector.
  • Column names are the first data row. The table has no header row. Turn off Table first row is header.
  • Nothing is copied. Run it from the right-click menu on the page itself, not from the canvas.
Aria fragen