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

uploading character/monster info via spreadsheet?

Hi folks. First time roll20 GM here. I was just wondering if there is any way to upload stats of pcs via spreadsheets.  I would like an efficient way to set up sessions without creating all the attributes of every character. Also on a similar issue.  Is there a way to record the attributes of monsters?  I see people rolling against monsters Fortitude but how is that attribute inputed? Probably some real basic stuff that I am missing. Help appreciated.
1364699645
Gauss
Forum Champion
There is not currently a way to upload stats.  Regarding rolling against Fortitude, could you give further details on what you are seeing?  - Gauss
The character journals do work kind of sort of OK. I wish they would work a little more... reliably, I suppose is the best word, but... Monsters: 4th Edition and 3.5 AD&D use savings throws a lot. For just your normal every day monsters the best thing to do is just jot them down in a hand out or on a separate piece of paper or even on the GM Overlay if you are using maps. For NPCs, you can do it like a character. Create a character in the journal and use the table or bullet functions and such to keep a nice orderly list of stats for the NPC so you can quickly access them. If you are using the map, you can have 3 attributes show on the tokens. For 3.5 Health and AC are all I really use for most monsters. For 4E you'll need to have Health, Action Points, and perhaps healing surges if your NPC gets any. My main problem with the tables is that I like to use more than one. For example I'll use: STATS      Modifier                   Health:  10                  STR 17 +3 Fortitude: +2 Then I'll have some other stuff here. then another table here: Weapon Hit Roll Damage Critical Long Sword +3 +3 19-20/x2 But if I enter one table to add more rows or columns... nothing happens (Chrome and Firefox.) I think it gets confused on which table to add it to or something.
1364717561
Gauss
Forum Champion
Wesley, this bug report may be of help regarding the table issue.&nbsp; <a href="https://app.roll20.net/forum/post/102917/table-add-column-not-working-in-journal-character-sheet#post-103842" rel="nofollow">https://app.roll20.net/forum/post/102917/table-add-column-not-working-in-journal-character-sheet#post-103842</a> The workaround offered does work. :) - Gauss
Hey Wes and Gauss Wes pretty much answered my question there.&nbsp; The examples I have seen are written like 1d20+4 vs AC... or vs Fort.&nbsp; I was thinking that there was some way that Roll20 was looking this up against a monsters AC.&nbsp; I see now that its a 4th ed thing where some attacks are against Fort and some are against AC so that its pretty much just info from the player for the DM as to what the attack should be read against.&nbsp; Ok Wes that solution for keeping track of NPCs stats as a new character or on the GM Layout helps alot for me to organise myself. Thanks.