Book Wurmple Book Wurmple - 2 months ago 11x
HTML Question

Extract raw text/data from a Google Sheet to a HTML Webpage

I have a basic website in which I intend to fill with a large amount of informative text. I wish to separate the content from the actual source code I use so my code is more efficient and organised. How do I go about doing this?

I tried publishing my Google sheet and using the code:

<div class="content_text">
<iframe src=";single=true&amp;widget=false&amp;headers=false">

However this left me with:

enter image description here

Is there a way to eliminate the formatting to leave me with just the raw text?


There are a few undocumented parameters, you just need to modify the URL in the code adding the parameter chrome=false removes the title bar and gridlines=false will remove the borders. Your URL should look like this:

Just replace the URL in the src attribute of your iframe tag.