Microsoft Outlook Export Contacts to Excel (CSV)

In this article we are going to export contacts to an Excel sheet. The resulting file is a CSV file that can be opened in Excel or used for another purpose, such as importing in another program. If you wish to save it as an XLSX file (regular excel file format), simply open it in Excel and save it as a regular file. To get started, open Outlook. Locate the folder containing the contacts you want to export if you have multiple.

Showcasing contacts to export in Outlook interface.
The folder containing the contacts to export is highlighted. Remember its name so you can select it in the export wizard.
Continue reading “Microsoft Outlook Export Contacts to Excel (CSV)”

Microsoft Outlook Import Contacts from Excel or CSV

In this article we are going to import contacts to Outlook from an Excel file. My file is currently in .xlsx format so we will first convert it to .csv format. Then, we will map it and import the contacts.

excel file with contacts to import
The Excel file with contacts to import
Continue reading “Microsoft Outlook Import Contacts from Excel or CSV”

BeautifulSoup 4 Python Web Scraping to CSV Excel File

In this tutorial we do some web scraping with Python and Beautiful Soup 4. The results are then saved to a CSV file which can be opened and analyzed in Microsoft Excel or another spreadsheet program. I show you how to select elements from the page, deal with 403 Forbidden errors by faking your user agent, and overcome cases where the website is poorly laid out for web scraping. The example used here is SocialBlade.

Continue reading “BeautifulSoup 4 Python Web Scraping to CSV Excel File”