O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing worksheet data

One of the great things about Excel 2013 is that it plays nice with many other programs. You can easily import data you’ve saved in another program and use it in your Excel worksheet, whether the data is from a Microsoft Access database, a website, a text file, or other data sources.

Import worksheet data

  1. Click the Data tab.

  2. Click Get External Data.

    A list of appears from which you can choose the type of data you want to import. Select From Access if you are importing data from an Access data table; choose From Web if you have a web query that you want to use in Excel; select From Text if you have text data that you want to organize in Excel; or choose From Other Sources if your data is from sources, including ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required