Microsoft® Excel® 2010 Inside Out

Importing and Exporting Files

Excel gracefully accepts proprietary data created in many other applications. Excel also makes it easy to import data from text files and helps you parse it into worksheet columns.

Note

Mountains of very specific, sleep-inducing technical details are available about importing and exporting files. If you need details, you should consult Microsoft Office Online (office.microsoft.com). Also, for information regarding sharing data with other Microsoft Office 2010 applications and working with external databases, see Chapter 32, and Chapter 24.

Using the Open and Save As Commands to Import and Export Files

To import a file from another application or from an earlier version of Excel, click the File tab, click Open, and select ...