Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account

Excel to HTML

February 08 (8 years ago)
I know nothing.


If I have an excel sheet of a character sheet I made, how hard would it be to make a decent character sheet from the excel file?
February 08 (8 years ago)

Edited February 08 (8 years ago)
vÍnce
Pro
Sheet Author
I believe you'll have to make a sheet from scratch Wade. If there is something out there that converts an excel spreadsheet to an html document it wouldn't be properly setup for roll20.  I assume the sheet is in a excel because it has some auto-calculation?  Even a static sheet converted to html would have to be thoroughly gone thru to work with roll20.

The good news is you can use the spreadsheet and it's formulas to help you construct a working sheet for roll20. ;-)
February 09 (8 years ago)

Vince said:



The good news is you can use the spreadsheet and it's formulas to help you construct a working sheet for roll20. ;-)

So when you say that, you mean if you have a good understanding of HTML right?

I'm just trying to get something going for my Gamma World game at the end of the month and we are using the 4th edition 1992 rules.
Would the best thing be to use the excel sheet and just create macros on the tokens, old school style?
February 09 (8 years ago)

Edited February 09 (8 years ago)
vÍnce
Pro
Sheet Author
I still have my Gamma World box in the attic.  ;-)
Yes, creating a sheet will require a little knowledge of HTML/CSS.  It doesn't take much to make a basic sheet.  You can use another sheet as a guide.  Lot's tutorials out there and roll20 has many resident sheet authors that wilkl always offer help when you get stuck. Of course the sky is the limit when it comes to these sheets.
You could use your excel  sheet off-site(maybe even open it google sheets in another tab) and just manually create some attributes and macros  ala "roll20 pre-character sheets".
There is a Gamma World 7ed sheet on github (https://github.com/Roll20/roll20-character-sheets/tree/master/GammaWorld7e)
Not sure if this one is available as one of the standard sheet's on the list.  Pro can always use a custom sheet. You might be able to use that as a template as well, or "upgrade" to 7th.  ;-)

You can also put in a request for an old school gamma world sheet.
February 09 (8 years ago)

Vince said:


Pro can always use a custom sheet. You might be able to use that as a template as well, or "upgrade" to 7th.  ;-)

You can also put in a request for an old school gamma world sheet.

Do you mind pointing me in the right direction on how to open an existing sheet and edit it?

I think a request for an older gamma world has been asked already.

Thanks,
Wade
February 09 (8 years ago)
vÍnce
Pro
Sheet Author
Have you tried using the Gamma World 7e sheet?  I noticed something in the description.  ;-)
February 09 (8 years ago)
Yeah we are playing the 4th (1992) edition Gamma World and that is the 7th edition (2010 4th edition dnd) it gets confusing but the 7th edition is way different and that Character Sheet needs an overhaul to be used with the 4th edition.

How do I copy all of that code from that edition so I can change it to 4th (1992)
February 09 (8 years ago)

Edited February 09 (8 years ago)
vÍnce
Pro
Sheet Author
Sorry. My ignorance.

So, you can copy the code from the github folder I linked to above(or another sheet on github's repo if want/need).  Copy the raw html and css text files from the repo.  I recommend creating a new "test" game since you'll want to make changes and you WILL break the sheet as you work on it.  

While you can make edits directly in the game settings console(btw the preview tab is near worthless, more about that later...), I would recommend using a text editor like notepad++ or similar to make any changes and doing a lot of copy/paste to your game settings console and save your changes.  Open your game in another tab or window, open a sheet to see your latest changes.  

Plan on refreshing your game and sheet quite often as you make changes.  You can use your browser's Inspecting tool(right-click on something in your sheet and "inspect element") to look and temporarily make changes of the loaded html and css.  I often use this method to tweak the sheet's code and then I go back to my editor and make the changes there, copy/paste to roll20, save, refresh game, re-open a sheet,... rinse and repeat until you get something to your liking.  

Of course this all assumes some basic knowledge of html/css.  Lot's tutorials out there and you really MUST read the roll20 wiki on Building character sheets.  MUST.  There are some nuances of how roll20 interacts with and allows in the characters sheet code. The CSS wizardry thread is also a wealth of info for any sheet author.  the adventure begins...  ;-)   
February 09 (8 years ago)
Ohh I missed that link!! THANK you so much ill poke around with that now and see how much I can break lol.

Tthanks again,
Does roll20 forum have a "cheer" or "praise" system for those that take their time to help? I cant see to find a button to click to say thank you.

Wade
February 09 (8 years ago)
vÍnce
Pro
Sheet Author

Wade said:

Ohh I missed that link!! THANK you so much ill poke around with that now and see how much I can break lol.

Tthanks again,
Does roll20 forum have a "cheer" or "praise" system for those that take their time to help? I cant see to find a button to click to say thank you.

Wade
You said it.  ;-)