[CardinalSagehen]

Thanks BC.  That formatting sure looks pretty.  Perhaps a script can be created that exports the results data and writes the formatting tags into a text document that can be pasted into a post.  This might make this task simple.

Looks good!  One simple option is to generate the syntax that BC provided directly in your Google Sheet with the CONCATENATE function.  Let's assume BC's sample table exists in columns A through E.  You would create a final column F with a formula that concatenates columns A-E as follows:

Code:

=CONCATENATE("[tr]","[td]",A2,"[/td]","[td]",B2,"[/td]","[td]",C2,"[/td]","[td]",D2,"[/td]","[td]",E2,"[/td]","[/tr]")

The tags and header row from BC's example never change, so you'd keep those and simply copy/paste all of Column F just above your tag.  

Hope this helps!  I'm sure there are many other ways.  All of this said, if this proves to be a pain, I also think it would be reasonable to require interested users to click into a protected Google Sheet for the results.

[CardinalSagehen]

Thanks BC.  That formatting sure looks pretty.  Perhaps a script can be created that exports the results data and writes the formatting tags into a text document that can be pasted into a post.  This might make this task simple.

Looks good!  One simple option is to generate the syntax that BC provided directly in your Google Sheet with the CONCATENATE function.  Let's assume BC's sample table exists in columns A through E.  You would create a final column F with a formula that concatenates columns A-E as follows:

Code:

=CONCATENATE("[tr]","[td]",A2,"[/td]","[td]",B2,"[/td]","[td]",C2,"[/td]","[td]",D2,"[/td]","[td]",E2,"[/td]","[/tr]")

The tags and header row from BC's example never change, so you'd keep those and simply copy/paste all of Column F just above your tag.  

Hope this helps!  I'm sure there are many other ways.  All of this said, if this proves to be a pain, I also think it would be reasonable to require interested users to click into a protected Google Sheet for the results.