Thursday, April 18, 2024

Steps to get website table data to excel

 1)Libre Office Calc


CLICK From top menu Sheet ----->Link to external data

2)Enter the website URL and click enter

3)Use copy and paste special--->transpose, to change rows to columns and columns to rows

4)Use tools--->macros to write VB script to get things like finding emails and logos


No comments:

Post a Comment