Chapter 32: Importing and Cleaning Data

In This Chapter

Importing data into Excel

Manipulating and cleaning data

Using the new Flash Fill feature to extract and concatenate data

Reviewing a checklist for data cleaning

Exporting data to other formats

Data is everywhere. For example, if you run a website, you're collecting data continually and you may not even know it. Every visit to your site generates information that is stored in a file on your server. This file contains lots of useful information, if you take the time to examine it.

That's just one example of data collection. Virtually every automated system collects data and stores it. Most of the time, the system that collects the data is also equipped to verify and analyze the data — but not always. And, of course, data is also collected manually. A telephone survey is a good example.

Excel is good tool for analyzing data, and it's often used to summarize the information and display it in the form of tables and charts. But often, the data that's collected isn't perfect. For one reason or another, it needs to be cleaned up before it can be analyzed.

One very common use for Excel is as a tool to clean up data. Cleaning up data involves getting raw data into a worksheet, and then manipulating it so it conforms to various requirements. In the process, the data will be made consistent so it can be properly analyzed.

This chapter describes various ways to get data into a worksheet and provides some tips to help you clean it up. ...

Get Excel 2013 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.