MySQL for Excel Guide  /  Import MySQL Data into Excel  /  Adding Summary Fields

5.3 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.


This feature was added in MySQL for Excel 1.3.0.

The Add Summary Fields option (deselected by default) appears on the Import Data dialog as shown in the figure that follows.

Figure 5.6 The 'Add Summary Fields' option

Content is described in the surrounding text.

Enabling this option adds a row of summary fields for the appropriate columns in your imported data. Notice the newly created row appended to the existing rows shown in the next figure.

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

Content is described in the surrounding text.

Select the row to reveal a down arrow, and click it to display a set of summary options shown in the next figure.

Figure 5.8 The 'Add Summary Fields' row: choices

Content is described in the surrounding text.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.