Microsoft Office Tutorials and References
In Depth Information
Importing, Exporting, and Connecting to Data Sources
Compact Form
Outline Form
Tabular Form
Figure 12-15 The same PivotTable report displayed in three different formats.
Importing, Exporting, and Connecting to Data Sources
Typing data by hand is one way to create a range or table in Excel. If the original data is
stored in another program or data file format, it’s much easier to import it into Excel. As an
added benefit, you get the assurance that the imported data is accurate, avoiding the
significant possibility of errors introduced when you rekey data.
The process works in reverse as well. If you have painstakingly entered and edited data in
an Excel table or range, it’s a straightforward process to export that data, in whole or in
part, to another file format for use in another program.
We start with the process of importing data. If you want to import the new data into a
completely new workbook, start with the Open dialog box (click File, then Open, or press
Ctrl+O). Choose the appropriate file format from the drop-down menu, locate the file
containing the data to be imported, and click Open. What happens next depends on the
original data format.
The most likely candidate for a successful import is a Comma Separated Values (CSV) file,
which represents the universal data interchange format. Fields are separated by commas
(and enclosed in quotation marks if necessary), with each record delimited by a carriage
return. Excel imports the entire file as a range, with each record in a single row and each
field in a single column.
Search JabSto ::

Custom Search