MS Excel — Use #PowerQuery to IMPORT .csv formatted data from the Web

Part 1 — Building Basic Data Analysis with Excel Power Tools

Overview

When getting data from the web, a lot of sites provide the ability to DOWNLOAD a csv formatted file of the data.

Rather than download it though, you can simply connect to it and import the data using PowerQuery.

Why import? Because the data can be refreshed and updated anytime the underlying source on the web changes!

That’s convenient!

One of my favorite small datasets that I use for training is a listing of banks that have failed (closed or been acquired).FDIC Failed Bank List – Comma Separated Values File – Data.govbanklist.csvcatalog.data.gov

In this video, I walk through importing the data from the web via connecting to the csv rather than downloading the csv file.

Have you used this approach? If not, give it a try!https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F8SUsdogETJQ%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D8SUsdogETJQ&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F8SUsdogETJQ%2Fhqdefault.jpg&key=a19fcc184b9711e1b4764040d3dc5c07&type=text%2Fhtml&schema=youtube

Next Up

In Part 2, I will review creating a dynamic Date Dimension query which updates from the core data query.

Continuing to build out the analysis…

About Author: Don tomoff

Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics

CONNECT WITH DON! LinkedInFlipboardTwitterSnapchat

Related Articles