Add external data to wordpress website page each time it loads

[hans gruber]

I have a wordpress website built using elementor. We book appointments using an excel spreadsheet. Each time this spreadsheet updates I can use VBA to create a file with available appointments. This could be another spreadsheet, or a text file etc.

I would like my website to use this data and display it in a contact page.

My questions are:

What would be the best format to save the data for it to be imported?
Where do I save it? I can save it in a google drive or FTP it to my site.
How do I get it into my wordpress webpage?

Can anyone help or point me in the right direction? I would like the wordpress page to load this data each time the page loads. A lot of tutorials are about manually importing data once and that's the end.

 

[hans gruber]

I've had a play with iframe and it works well. I can easily create a html table and ftp it to my site, so it's looking promising.

 

[hans gruber]

Just thought I'd update. Got this up and running. It was easier than I thought. Html created in vba as you close spreadsheet and winscp to folder on site, then iframe. Thanks for pointing me in the right direction.