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”

Import an HTML Table into Excel

In this article, I will show you how to import an HTML table into Excel. This will work for any data from a local HTML file or online URL that is stored in a table. I will import the HTML table in a way that the data can be updated if it changes, which is particularly valuable for online data. This will be done using a Get & Transform Query. As such, this method is only compatible with the Windows version of Microsoft Excel.

Continue reading “Import an HTML Table into Excel”

SQL Import Excel File to Table with Python Pandas

If you’re looking for a simple script to extract data from an excel file and put it in an SQL table, you’ve come to the right place. In this article, I will show you how to use python pandas and sqlalchemy to import an excel file to a SQL database (MySQL) in a free, fast and flexible manner. The same method also works for SQLite or other SQL databases, but the connection details will be different.

Continue reading “SQL Import Excel File to Table with Python Pandas”

Excel Import CoinMarketCap API Data with Query

The CoinMarketCap Pro API is a great source for cryptocurrency data on current and historical prices, exchange information and more. If it is your wish to use Excel to import CoinMarketCap API data, and have it updated live, look no further. In this article, I will show you how to use a query to import current prices into Excel and have them updated regularly using the methods shown in the Import JSON Data in Excel article. Be aware that this works best with Excel 2016 or greater, and doesn’t work with Excel for Mac. If you are using Excel 2013 or prior, you will need to install Power Query before attempting these steps.

Continue reading “Excel Import CoinMarketCap API Data with Query”

Excel Function to Calculate Travel Time and Distance using Google Maps API with VBA

In this article, we will create an Excel function to calculate the distance between two addresses using the Google Maps directions API. This will allow you to get the travel time between the two locations. The format of the function will be as follows: =TRAVELTIME(origin, destination, api_key), =TRAVELDISTANCE(origin, destination, apikey). The origin and destination will be strings, and can be either an exact address or the name of a place. In order to use the function, an API key is required. The “Getting Started” page can help you with this: http://bit.ly/googlemapsgettingstarted. Create a new project and make sure the Directions API is added.

Continue reading “Excel Function to Calculate Travel Time and Distance using Google Maps API with VBA”

Excel Email Validation with Data Validation Tools

If you have a list of email addresses in Excel that you need to validate follow proper format, or would like to prevent other Excel users from entering invalid addresses in a column, use Data Validation. By using a custom formula as the validation criteria, email address validation can be done. To get started, with the cells you need validated selected go to Data > Data Validation.

Continue reading “Excel Email Validation with Data Validation Tools”

How To Use Excel Data Types and When You Might Not Want To

Microsoft recently introduced a feature called “Data Types” into Excel 365. Unlike the regular Excel data types like Dates, Numbers, and Text, this feature relies on the internet to bring external data points into your Excel sheets. They call them linked data types. The implementation is a lot easier to use than creating a query or using VBA to bring data to Excel, but it’s pretty limited in its current form and probably wouldn’t be very valuable to most users. Right now, it’s limited to Stock and Geography data.

Converting a set of stock tickers to the Stocks data type.
Continue reading “How To Use Excel Data Types and When You Might Not Want To”