{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["readme","output","input-Top_pages"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"readme","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"What it does",null,"Scrapes webpages specified on input tab"]
[null,"How it works",null,"Scrape all website pages specified in Column A of input tab. Column C, D, E, etc use CSS selectors to extract sections of page. Technically you can add as many columns as needed. Script will only read columns with values"]
[null,"Why",null,"Free scraper. Useful if your company restricts software you can install on your work computer"]
[]
[]
[]
[]
[null,"[AT Item]",null,"Will return specified CSS selector, recommend nesting multiple selectors for more complex pages","[/AT Item]","Similar to HTML syntax, team item tag and loop tag need an opening and closing tag"]
[null,"[AT loop]",null,"Will return multiple items separated by \"|\" character","[/AT Loop]"]
[null,"[AT Item attr=\"src\"]",null,"Used to return specific attribute from value. Ex values, \"src\", \"alt\",\"aria-label\" etc. Must use double quotes. Use exact convention, don't put extra spaces between \"Item and attr\""]
[null,null,null,null,null," "]
[null,"Notes"]
[null,null,null,"Try deleting cache in Internet Explorer if you update a page but your not getting expected results"]
[null,null,null,"May not return values if page takes too long to load"]
[]
[]
[]
[]
[null,null,null,null,"Debugging - copy and paste this in the browser console window to test out your CSS selectors before plugging them into the input tab"]
[null,null,null,null,"output the number of elements matching selector"]
[]
[null,null,null,null,"var strHTML=document.querySelectorAll(\"h1.headline\");"]
[]
[null,null,null,null,"console.log('%c'+strHTML.length, 'background: #222; color: #bada55');"]
[]
[]
[null,null,null,"Created by Angel Tabora - 2021"]
[null,null,null,"'Free to use but kindly provide credit and link back to blog if possible"]
[null,null,null,"https://angelskills.com/wp/2021/07/06/free-website-scraping-tool-data-extractor-bulk-automation/"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"bug output must have two lines"]

{"sheet":"output","index":1,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["https://angelskills.com/test/scrapedemo.html",null,"Bug, leave the two values in row A1 and A2 or replace with your website. Script will crash otherwise. "]
["https://angelskills.com/test/scrapedemo.html",null,"Bug, leave the two values in row A1 and A2 or replace with your website. Script will crash otherwise. ",null,null,null,null,null,null,null,"Script ran for 1.28"]

{"sheet":"input-Top_pages","index":2,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["https://angelskills.com/test/scrapedemo.html","Col B","Site headline","Recent posts as list","First image ALT tag"]
["https://angelskills.com/test/scrapedemo.html",null,"[AT:Item]p.site-title[/AT:Item]","[AT:Item]#recent-posts-2[/AT:Item][AT:Loop]li[/AT:Loop]","[AT:Item attr=\"alt\"]img[/AT:Item]"]