Looking for Google Sheet export to Markdown

JohnnFour

Game Master
Staff member
CL Add-on Dev
Demonplague Author
Wizard of Adventure
Beta-Tester
Has anyone found a tool, script, or service that will take each row of a Google sheet and export as Markdown?
 

ELF

Generator Sage
Staff member
CL Add-on Dev
Beta-Tester
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:
I haven't tested any of these, so cannot recommend any particular solution. A potential downside of a copy/paste operation (Ctrl+A, Ctrl+C, Ctrl+V) is that the copied formatting will include the spreadsheet cells as well.

But the paste destination does not have to be Google Docs, you could try for example this site:

The MarkItDown service removes the spreadsheet table formatting, so it could be your best and least complicated option.
 

JohnnFour

Game Master
Staff member
CL Add-on Dev
Demonplague Author
Wizard of Adventure
Beta-Tester
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.
 

ELF

Generator Sage
Staff member
CL Add-on Dev
Beta-Tester
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?
 
Top