ImportExcel: Pull Website Data into Excel with
ImportExcel: Pull Website Data into Excel with PowerShell
In this short video, I'm using Import-Html to pull Demographics of the United Kingdom data from Wikipedia.
First, I install the ImportExcel module in PowerShell - no admin rights required. Then I load the module into the current session.
After that, I use the URL to import the data. The number 9 tells PowerShell which table to extract. Tables are counted from zero, so 9 means the 10th table on the page.
This PowerShell module enables reading and writing Excel files without Microsoft Excel installed on the system.
A simple way to turn web data into structured data in seconds.
#PowerShell #Automation #DataManagement #IT #TechSkills #DataSkills #Organisation #VisualStudioCode #vscode #importExcel #Beginner #LearningByDoing #Coding #Shorts