© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_14

14. Importing Data

David Slager

(1)Fort Wayne, Indiana, USA

Excel is the premier analysis tool. This is the reason for bringing data from other sources into Excel. Microsoft has added even more sources and ways of importing data for Excel 2016.

After reading and working through this chapter you should be able to

  • Import delimited text and fixed-width text files

  • Import data from an Access database

  • Import data as is from a web page and modify and transform it before importing it

  • Create connections between a workbook and a data source

Importing Data into Excel

Excel’s Ribbon has two groups of buttons for bringing data into Excel. See Figure 14-1. The first group, Get External ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

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