Turn any webpage into a spreadsheet

SelectorGadget+Spreadsheet.md

Turn any webpage into a spreadsheet

Follow this walk-through in video format

Instructions

1. Install the SelectorGadget Chrome extension.

2. On the target site, activate SelectorGadget from the toolbar. Click on any elements to select it. It will turn green. Similar elements will be autoselected and turn yellow. Click on yellow items to deselect them and turn them red. This is a trial-and-error process.

3. When all the items you want to copy have turned yellow, open the developer console (command+option+J on macOS or control+shift+J on Windows or Linux). Use one of the commands below to copy the selection to the clipboard:

Copy a list of text cells:

copy([...document.querySelectorAll("SELECTOR")].map(item=>item.innerText).join("\n"))

Copy a list of image URLs:

copy([...document.querySelectorAll("SELECTOR")].map(item=>item.src).join("\n"))

Copy a list of link URLs:

copy([...document.querySelectorAll("SELECTOR")].map(item=>item.href).join("\n"))

Replace SELECTOR in the command with the selector given by SelectorGadget.

4. After running the command, paste the results (command+V on macOS or control+V on Windows or Linux) into the right column in your sheet.

5. Repeat 3-4 for each set of elements that you need, filling in your sheet!