Spreadsheet Data

  • 1
  • Question
  • Updated 5 years ago
  • Answered
Hi. I'm totally new to web-building so apologies if this sounds like a daft question.

The website I'm looking to build will consist of information that I currently have contained in a spreadsheet (OpenOffice, rather than Excel).

Is there a way to transfer this data onto my website? I noticed in the tutorial that copying and pasting from external sources can lead to problems, so I'm wondering if there's a way around it.

Thanks,

Ian
Photo of Ian Mayhew

Ian Mayhew

  • 2 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 1
Photo of Gop

Gop

  • 7473 Posts
  • 2115 Reply Likes
Hello Ian,

The easiest way that allows you to format etc is to use Google Drive (prev Google Docs). You can upload your file to Google and Share it there. Then you can grab the link from the share and paste it into your web-page. The process is similar to hosting images on Picassa etc. It is a champion solution for this requirement.

You can also save the spreadsheet as a web-page which I think is an option with OO it may be called HTM or something similar. This works but is really quite involved in tweaking: setting it up with colour, contrasts, font intensity, grids, widths, heights etc It works but is a lot of work and possibly for someone who has considerable experience using HTML.
Photo of Ian Mayhew

Ian Mayhew

  • 2 Posts
  • 0 Reply Likes
Hello Gop, thanks for the reply. The first solution sounds like the best one for me.

I take it there's no limit to how many times I can do this? I'm planning to have about 20-25 spreadsheets on the website.

And also, am I able to change the content of the spreadsheets week on week?

Thanks again

Ian
Photo of Gop

Gop

  • 7473 Posts
  • 2115 Reply Likes
Hi Ian,

I can't recall the limitations on the amount stored but it's a lot. That info will be in their support info or their FAQ I'm sure.

Changes are no problem at all. For example you can link a sheet to a contact form and these can have hundreds of entries changing by the minute almost and the site will reflect these changes. I read at one time where a cyclist traveller was sending his GPS data via satellite to a server then onto his Google Sheet and then taking that info and plotting his progress in real time on a website. Once again I'm not sure how fast the dynamics are as this presumably is the process of the two servers: Google and Yola.