MySQL and MySQL Community information

  • July 14, 2014

Adding summary fields when importing MySQL data with MySQL for Excel

Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since MySQL for Excel 1.3.0, remember you can always install the latest GA or maintenance version using the MySQL Installer also you can download directly any GA or non-GA version from the MySQL Developer Zone.

Thinking about how we can make MySQL for Excel users life more easy we added an option to include a calculation-summary row to the Import Data process. We are going to show you in this post how to take advantage of this new option in a few clicks. 

The current blog post assumes you already know how to import data into excel, you could always take a look at our previous post How To - Guide to Importing Data from a MySQL Database to Excel using MySQL for Excel if you need further reference on that topic.

When you are importing a table to Excel you will notice this option at the Import dialog:

Check that option before pressing the Import button.
Once you did that, check the last row from the data you imported and you will notice a new row at the end:

If you select a a cell from that row you will notice an arrow appears:

 if you click it a set of summary options will appear, allowing you to customize how the data in the upper cells will be processed to show the result in this last row:

for this blog we have selected  Sum to show an example of how this works:

And that's it! We learned how to add summary fields to our data imports to excel easily. Remember that your feedback is very important for us, please drop us a message with your comments, suggestions for this or other features and follow us at our social media channels: 


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.