My understanding is that at this time, there is no way to update data from Excel, and it have it show up in Smartsheet. The Smartsheet Live Data Connector provides a read-only experience and is not able to write data into Smartsheet.
I would like to propose an idea for Smartsheet to be updated via Excel.