Adding summary fields when importing MySQL data with MySQL for Excel
By Javier Rivera on Jul 14, 2014
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: