Artifacts Gallery Guilds Search Wiki Login Register

Welcome, Guest. Please login or register. - Thinking of joining?
a Summer day - @447.29 (what is this?)
Activity rating: Four Stars Posts & Arts: 61/1k.beats Random | Recent Posts | Guild Recents
News: :ha: :pc: Hello Melonland! :pc: :happy: Guild Events: Summer Projects

+  MelonLand Forum
|-+  Life & The Web
| |-+  ✁ ∙ Web Crafting
| | |-+  ☔︎ ∙ I need Help!
| | | |-+  (Live) spreadsheets in HTML??


« previous next »
Pages: [1] Print Embed
Author Topic: (Live) spreadsheets in HTML??  (Read 1064 times)
BlazingCobaltX
Hero Member ⚓︎
*****
View Profile WWW


⛺︎ My Room
StatusCafe: blazingcobaltx
RSS: RSS

Guild Memberships:
Artifacts:
First 1000 Members!Joined 2023!
« on: an Autumn night » Embed

Hello, let me explain my usercase.

I have two spreadsheets that are currently homeless. One of these is a personal archive of things I've watched/read/etc, which I used to edit on the fly all the time. The other is a public directory of videos for a fandom, which I now update once in a blue moon. In the vein of "degoogling" I have removed these from Google Drive, but the online editing and hosting of these sheets was incredibly convenient for someone like me who isn't at their PC most of the time.

While I was looking for a new place to host these, I thought it would be convenient to give both of them a spot on my website, but in two different ways. For the personal archive, I'd like to display live updates to the spreadsheet on my site. Ideally, I write all my reviews in that one sheet. For the fandom archive, I am just looking for a new place to host it and then embed; live editing is likely not something I will need.

...Dunno if that was really clear. I understand that finding an all-in-one solution that isn't GDrive is a bit hard. So there are two main questions:
1) What do you guys recommend for alternative online hosting of spreadsheets (with or without live editing)?
2) What are the best ways to display (the content of) a spreadhseet on a website, where the spreadsheet and its contents can be edited afrer upload?
« Last Edit: an Autumn night by BlazingCobaltX » Logged

https://blazingcobaltx.neocities.org/images/arceus.png
brisray
Hero Member ⚓︎
*****
View Profile WWW


⛺︎ My Room

Artifacts:
RocketmanFirst 1000 Members!Joined 2023!
« Reply #1 on: an Autumn night » Embed

For me the answer was Google Sheets and the Google Charts API.

I found the charts and tables are very customizable and can import data from a variety of sources, including Google Sheets. The charts on the web page are updated as soon as the spreadsheet is updated and the page refreshed.
Logged
TheFrugalGamer
Hero Member ⚓︎
*****
View Profile WWWArt


⛺︎ My Room
Itch.io: My Games
RSS: RSS

Guild Memberships:
Artifacts:
See A Bug Summer 2025 ParticipantGreat Posts PacmanFirst 1000 Members!Joined 2022!
« Reply #2 on: an Autumn night » Embed

If you're not something that's needing to be updated all the time, Google Sheets also has an "Export to HTML" feature that I've used. The HTML it produces isn't pretty, but it works for one-off things like the podcast sheet I was publishing.
Logged


Artifact Swap: Pink TulipEmerald OreAquamarine
BlazingCobaltX
Hero Member ⚓︎
*****
View Profile WWW


⛺︎ My Room
StatusCafe: blazingcobaltx
RSS: RSS

Guild Memberships:
Artifacts:
First 1000 Members!Joined 2023!
« Reply #3 on: an Autumn night » Embed

I don't know why I never got a notification for your replies! Thanks guys, I will continue sleuthing from here on. If I have an update on how it's going I'll post it here.

EDIT: For those looking at this thread, I also found this tutorial. It still uses Google, though.
« Last Edit: an Autumn night by BlazingCobaltX » Logged

https://blazingcobaltx.neocities.org/images/arceus.png
Pages: [1] Print Embed 
« previous next »
 

Melonking.Net © Always and ever was! SMF 2.0.19 | SMF © 2021 | Privacy Notice | Send Feedback | Supporters ♥ Forum Guide | Rules | RSS | WAP | Mobile


MelonLand Badges and Other Melon Sites!

MelonLand Project! Visit the MelonLand Forum! Support the Forum
Visit Melonking.Net! Visit the Gif Gallery! Pixel Sea TamaNOTchi
MelonLand @000

Minecraft: Online
Join: craft.melonking.net