Importing External Data into Excel using Python

In this video I am going to show you how to import external data into your excel sheets. In this iteration, however, we are going to do this using web scraping with Python, BeautifulSoup and Requests. If this video was helpful please consider liking or subscribing - it would help me out a lot! The Code for the Script: import bs4 import requests import openpyxl wb = openpyxl.load_workbook('**File Path**') sheet = wb['**Sheet Name**'] r = requests.get('https://finance.yahoo.com/quote/AAPL?p=AAPL&.tsrc=fin-srch&guce_referrer=aHR0cHM6Ly9maW5hbmNlLnlhaG9vLmNvbS8_Z3VjZV9yZWZlcnJlcj1hSFIwY0hNNkx5OTNkM2N1WjI5dloyeGxMbU52YlM4Jmd1Y2VfcmVmZXJyZXJfc2lnPUFRQUFBTXJRZlphTm1qRE1FZHplWm1ra29pRU54cDdYSV9vQy1abmUxd0xLV2FmS1MyUXhYN2E2NXZ5SVZlSWxSTDRCY3NGVlJPUFcyN1NZSkFQa2pSSG04Vk55WTdSZURsa2lHaHEySVFqaGpNcS1oZnVHRXA4V2xiMDFTYlFwTW11YUtVTi1CclFRT3NldW9PN1R3ZVRIeFFmRUNNOTB6VWlSa05URHZQRE42ajUzJl9ndWNfY29uc2VudF9za2lwPTE1OTY5MjU5OTQ&guce_referrer_sig=AQAAAJ9MJIO1Wuuv3tlhwx4XmafEYzNBlBVxwIatIdwmph_PD_6084ClbHd_100qrWH_CLANySK5gXDU6YhzkO7rH9ZxYBQr6CzY9dGHz8w8hfXIul_aCdIwtNSr3oJIuInWm5edw2AsMmn_gsDRgysYheSjyBDl-zHW2mxnDcLsvU-B&_guc_consent_skip=1596926000') soup = bs4.BeautifulSoup(r.text, features='html.parser') priceAAPL = soup.find_all('div', {'class', 'D(ib) Mend(20px)'})[0].find('span').text.replace('.', ',') v = sheet.cell(row=7, column=6).value = priceAAPL wb.save('**File Path**')