HTML cannot do any of this. You need a programming language.
Most agreed! HTML is pretty much for display only. You would need something like Perl to handle that for you.
Perl has the ability (using CGI) to get the values from the form fields and populate them into and email if you wish. There are also modules for creating, writing to, and updating Excel spreadsheets.
Please know though that if you post over in the Perl forum that we will need to see the code that you have tried thus far and will help you achieve your goal from there.
Regards,
Jeff