Enter a new item to the list: Reopen the Excel file, open the ribbon and click on Data and Refresh All: If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. Instead of exporting the list to Excel after every change, you can automatically update Excel.
This offers you flexibility by creating other views with other metadata fields to create multiple Excel files.