Copy Data From Web Page to Spreadsheet

Copy and paste from the web pages below into an Excel spreadsheet the data, and then format the data into the following columns. Since there is a limit to the number of listings that these pages will display in one query, this must be done state by state, not the entire country in one query.

Columns for the Institution Directory on: https://hub.nacacnet.org/independentmemberdirectory
Name
Street Address
City
State
Postal Code
Country
Category
Organization
Public/Private
2/4 Year
Account Phone
Account Fax
Website

Columns for the Independent Counselor Directory on https://hub.nacacnet.org/institutionmemberdirectory
Name
Title
Street Address
City
State
Postal Code
Country
Email
Account Phone
Account Fax
Website