Script to extract meta title, description from website
Budget: $30 – $250 AUD
Hi,
I have an Excel spreadsheet of 600,000 websites.
I want to extract meta data, specifically data that looks like this in the source code:
<title>title of website</title>
<meta name="description" content="Description of website." />
<meta property="og:description" content="Description of website." />
I have all the data in Excel. A sample data is attached.
TASK
I use a Mac. I use Excel and have the developer tab enabled. I wish for you to use VBA to create the desired script that will extract this data AND also include error handling just in case a website does not have title or any type of meta content and meta property description/s.
***
I'll run the script and do the data collection
***
I need this urgently
I have an Excel spreadsheet of 600,000 websites.
I want to extract meta data, specifically data that looks like this in the source code:
<title>title of website</title>
<meta name="description" content="Description of website." />
<meta property="og:description" content="Description of website." />
I have all the data in Excel. A sample data is attached.
TASK
I use a Mac. I use Excel and have the developer tab enabled. I wish for you to use VBA to create the desired script that will extract this data AND also include error handling just in case a website does not have title or any type of meta content and meta property description/s.
***
I'll run the script and do the data collection
***
I need this urgently