Microsoft Office Tutorials and References
In Depth Information
Creating PivotTables from external data
On this page, you can change the data type and formatting of the columns in your data.
Because you’ll assign number styles and PivotTable Quick Styles after you create the
PivotTable, you can click Finish to import the data into your worksheet. After the data is in
Excel, you can work with it normally.
In this exercise, you’ll import data into Excel from a text file and then create a PivotTable
based on that data.
SET UP You need the Creating text file located in the Chapter10 practice file folder to
complete this exercise. Don’t open the file yet; just follow the steps.
Create a new Excel workbook. On the Data tab, click the Get External Data button,
and then click From Tex t to open the Import Text File dialog box.
Navigate to the Chapter10 practice file folder, and then double-click the Creating
text file to start the Tex t Impor t wizard.
Verify that the Delimited option is selected, and then click Next to display the next
page of the wizard.
In the Delimiters area, verify that the Tab check box is selected and also verify that
the data displayed in the Data preview area reflects the structure you expect.
Click Finish to skip the third page of the wizard, which has commands you can use
to assign specific data types to each column. Excel assigns data types for you, so you
don’t need to do so. After you click Finish , the Import Data dialog box opens.