-
Hello game master! Welcome to our growing community. Please take a moment to Register (top right button, see how: Slides).
If you use Campaign Logger, you can use the same login details - we've linked the app to this forum for secure and easy single sign-on for you.
And please drop by the Introductions thread and say hi.
Looking for Google Sheet export to Markdown
- Thread starter JohnnFour
- Start date
What kind of formatting you need to preserve? For plain text, just a copy and paste (without formatting) operation should produce usable Markdown text.
For formatted cells, you could simply copy the sheet to a Google Doc via clipboard (that preserves the formatting). From Google Docs there are several conversion paths available, for example:
But the paste destination does not have to be Google Docs, you could try for example this site:
http://markitdown.medusis.com/
The MarkItDown service removes the spreadsheet table formatting, so it could be your best and least complicated option.
For formatted cells, you could simply copy the sheet to a Google Doc via clipboard (that preserves the formatting). From Google Docs there are several conversion paths available, for example:
- https://chrome.google.com/webstore/detail/docs-to-markdown/igffnbdfnodiaphfmfaiiaegmoljbghf
- https://chrome.google.com/webstore/detail/export-as-markdown/hbojhdcnbcondcdfpfocpkjkfkbnbdad
- https://github.com/mangini/gdocs2md
But the paste destination does not have to be Google Docs, you could try for example this site:
http://markitdown.medusis.com/
The MarkItDown service removes the spreadsheet table formatting, so it could be your best and least complicated option.
JohnnFour
Game Master
Staff member
Adamantium WoA
Wizard of Story
Wizard of Combat
Gamer Lifestyle
Demonplague Author
My use case right now is:
Google Form => all entries get automatically added to a Google Sheet
Google Sheet => rapid output to a CL data file
For example, if I run an NPC contest and want to take the best entries and make them into a CL file with basic formatting.
Google Form => all entries get automatically added to a Google Sheet
Google Sheet => rapid output to a CL data file
For example, if I run an NPC contest and want to take the best entries and make them into a CL file with basic formatting.
That is an interesting use case!
If you run a contest asking for complex entries like NPCs, it would probably make sense to use multiple Google Form text fields for one contest entry. That way you will have more control over the format and will produce a Google Sheet whose processing is easier to automatize.
Perhaps the permissively licensed gdocs2md script could be taken as a starting point and modified to automatically apply also some additional, CL-specific log entry formatting to the Markdown export?
If you run a contest asking for complex entries like NPCs, it would probably make sense to use multiple Google Form text fields for one contest entry. That way you will have more control over the format and will produce a Google Sheet whose processing is easier to automatize.
Perhaps the permissively licensed gdocs2md script could be taken as a starting point and modified to automatically apply also some additional, CL-specific log entry formatting to the Markdown export?
i found an online spreadsheet table to markdown converter, if this is still relevant 
sorry a few years late to the conversation lol
sorry a few years late to the conversation lol
JohnnFour
Game Master
Staff member
Adamantium WoA
Wizard of Story
Wizard of Combat
Gamer Lifestyle
Demonplague Author
What is the URL @BahneGorkDK?