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: