From the course: Excel for Engineering Professionals
Join today to access over 23,200 courses taught by industry experts.
Importing text files with Power Query - Microsoft Excel Tutorial
From the course: Excel for Engineering Professionals
Importing text files with Power Query
- [Instructor] Production control systems usually have ways to analyze how your process is functioning, but you may want to do that analysis yourself using Excel. It may surprise you how poorly large software systems integrate with Excel. For instance, our very own KinetEco solar panel production line is only capable of producing CSV files, one for each machine, and it dumps those files in a predefined folder on our company network. Let's have a look at that data and see how we might get it into Excel. This is what one of those files looks like in Notepad. For some reason, the file starts with blank rows with only commas, and then we have a header row, and then the data runs beneath the header. If you look at those date values, there's no way to tell which date order has been used. Are we looking at January 3rd or is it March 1st? There's no way to tell. But here's that same data when I scroll down a bit, and as there is no 13th or 14th month, we must be looking at the data for March,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.