Aller au contenu
Agentic Workflowdocs
v0.8.2Installer gratuitement

recettes / 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.

Ce contenu n’est pas encore disponible dans votre langue.

Débutant 3 min Aucune configuration Extraire des données

workflow · table-to-csv.awf 4 étapes

Page Table to CSV : un workflow de 4 étapes, qui commence par When Started et se termine par Copy to clipboard.

  1. When Started(Déclencheur — ouvrir sa page de documentation)
  2. Read the table(Get Structured Data — ouvrir sa page de documentation)
  3. Build CSV(CSV — ouvrir sa page de documentation)
  4. Copy to clipboard(Clipboard Write — ouvrir sa page de documentation)
Ouvrir dans AWFlow
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 nœud référence

    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.Plein écran
    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 nœud référence

    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.

    Personnalisez-le — 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.Plein écran
    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 nœud référence

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

    Personnalisez-le — 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.Plein écran
    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 nœud référence

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

    Personnalisez-le — 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.Plein écran
    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.Plein écran
    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.Plein écran
    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.Plein écran
    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.
Demander à Aria