Script to extract meta title, description from website

Job ID: 34107108

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
Related categories: Visual Basic Excel Web Scraping