HTML form data automatically upload into a spreadsheet

Question

Hi all,

I have created a webpage that asks users questions on details of their order. I want the data from this form to be uploaded to a spreadsheet where i can transfer the records for each submission into another excel document.

I have tried using phpMyAdmin export option. however this does not update automatically on a new record being added and have to manually export the file. Meaning it will create multiple files.

I have tried using using PhpSpreadsheet. But i cannot install the composer as i get exit code 1.

I have also tried linking the page to google sheets. This is the only option i have seen that updates after submission of the form. However it hasnt been working for me and i am unsure why.

If anyone knows anyway to do this task pls comment!