Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  Import MySQL Data into Excel  /  Adding Summary Fields

9.5 Adding Summary Fields

Summary fields are calculated fields added to the last row of each column in the imported MySQL table. The drop-down list for each summary field in the resulting worksheet includes functions such as Average, Sum, Min, and Max.

Note

This feature was added in MySQL for Excel 1.3.0.

The Add Summary Fields option (deselected by default) is listed on the Import Data dialog:

Figure 9.6 The 'Add Summary Fields' option

The 'Add Summary Fields' option

Enabling this option adds a row of summary fields for the appropriate columns in your imported data. Notice the newly created row on the bottom:

Figure 9.7 The new 'Add Summary Fields': the new row

The new 'Add Summary Fields': the new row

Select the row to reveal a down arrow, and click it to display a set of summary options:

Figure 9.8 The 'Add Summary Fields' row: choices

The 'Add Summary Fields' row: choices

For example, choosing Sum:

Figure 9.9 The 'Add Summary Fields' row: sum example

The 'Add Summary Fields' row: sum example

Adjust each summary field accordingly.


User Comments
Sign Up Login You must be logged in to post a comment.