CSV Upload and Display in a Table

Is it possible to use the SFTP, to upload a CSV file, then have a custom page that would display the CSV data in a Table?? I'd prefer, if I could add custom code to a Squarespace page, that would read the CSV file. We would like to have the CSV file uploaded nightly and require a SFTP location to upload the file to.

I created a folder called Inventory, with a test.html file, but I am not sure how to view it. I was going to have the Test.html file read the CSV file and display the information.

I assumed, I would be able to go to https://www.strongbridge.us/Inventory/test.html

On 8/3/2021 at 8:40 PM, SBI said:

Is it possible to use the SFTP, to upload a CSV file, then have a custom page that would display the CSV data in a Table?? I'd prefer, if I could add custom code to a Squarespace page, that would read the CSV file. We would like to have the CSV file uploaded nightly and require a SFTP location to upload the file to.

I created a folder called Inventory, with a test.html file, but I am not sure how to view it. I was going to have the Test.html file read the CSV file and display the information.

I assumed, I would be able to go to https://www.strongbridge.us/Inventory/test.html

You can consider upload the content into google sheet and use Table block plugin provided by Squarewebsites.org to display it on frontend

https://www.squarewebsites.org/squarespace-plugins/custom-table-block