Hugo, Nebula, World Fantasy Awards Combined Novel List

In the Google Docs link below, you’ll find a combined list, without duplicates, of all the winners and nominees of the Hugo, Nebula, and World Fantasy awards for Best Novel. The novels are sorted by author’s last name (to aid in book shop hunts).

Feel free to save your own copy using “File -> Make a copy”. With your own copy, you can use the green filter icons at the top of each column to sort or filter the table by that column. For example, if you only wanted to see winners, and not nominees, you would filter by the first “won/nom” column for only “won”.

Google Docs Spreadsheet link: https://docs.google.com/spreadsheets/d/1GJAWbhrUa9qEM16YZEZNMnEJpQDuwreOqCZgAwHjAns/edit?usp=sharing

If you are interested in chatting about novel writing, check out our Discord Server, The Library, a chatroom for fiction writers. Discord is a free and easy-to-use chat application for the web, desktop, and mobile devices.

Snowflake Method Spreadsheet for Google Docs

What is the Snowflake Method?  It’s a way to outline your novel, starting with a single sentence, and then building that into a paragraph, then several paragraphs, then pages, and then a full story.*

The Snowflake Method was popularized by Randy Ingermanson and you can read more about it on his website.  He also publishes software that lets you do a much deeper dive into the method than this simple spreadsheet.

Here is the link to the Google Spreadsheet:
https://docs.google.com/spreadsheets/d/1MQjikpzlNqADSwS0LUOGNM4D3imu1gPAck1q2kW2gFo/edit?usp=sharing

If you want to walk through the entire Snowflake Method, then you can start at the first tab and work your way to the right.  If you like to keep track of your scenes and characters in a spreadsheet, you may want to copy only those two sheets out of this file, as they are the most useful once you get your basic plot outlined.

Once you open the spreadsheet, you can go to “File” -> “Make a copy” to save a copy to your own Google Drive.

Good luck!

*  Really, it should be called the snowball method, as that is a much more accessible metaphor than something about fractals.

Google Docs Add-ons for Writers

Here are some useful Add-ons that you can use within Google Docs™.

To install an Add-on, go to the Add-ons menu and click “Get Add-ons”.

Writer’s Highlighter

This useful plugin allows you to highlight words from a word list in a Google Spreadsheet™.  You can highlight from a word list, highlight a selection, highlight continuously as you type, and highlight sentences by length. It also has functions to clear highlights from the entire doc or a selection.  It also includes a stats viewer for word count, word frequency, lists of all the sentences, and readability statistics.  The help file is here.

 

OneLook Thesaurus

While you can get some synonyms from Google’s thesaurus by selecting a word, right-clicking it, and choosing “Define”, it’s not comprehensive.

OneLook Thesaurus provides standard synonyms, rhymes, and frequently used words that often appear near the word you are looking up.

  

Word Cloud Generator

This plugin generates a word cloud from your source material.  This can be very useful to understand the frequency of occurrence of the words in your document, or just to share word clouds with friends.  The word clouds are generated as transparent-background .png files, you can can copy-and-paste them into any website or social app.

  

Better Word Count

This simple tool allows you to get a word and character count, but exclude certain sections of the document, such as headers or titles.

  

Google Translate

First written as a demo app by Google to highlight the extensibility of Google Docs™, this app has useful tools for quick and easy translations.

  

Screenplay Formatter

For some reason that has been lost to time, screenplays are still put in an archaic manuscript format, despite the fact that no one has written a screenplay on a typewriter in twenty years.  However, if you are writing a screenplay, you must play by the rules.  This add-on will help you do that.

  

How to organize your work in Google Docs

Put each story in its own folder

This will help keep your stories separate.  I recommend making a folder for story ideas, where you keep notes for future stories.

Here is an example where the writer is working on three stories:

Make sub-folders for drafts, reference material, etc.

As you write stories, you may want to save spreadsheets, reference material, older drafts etc. and you may want to make sub-folders for these items.

I recommend dividing longer works (novels) into chapters to make it easy to find things.

Use spreadsheets to keep information organized

Spreadsheets may seem intimidating, but they are just boxes that hold text or numbers.  We’re not doing anything fancy; we just need to stay organized.

If you like to keep your notes on characters and scenes in a Document, that’s fine too, but you may find spreadsheets much quicker to work with.

Creating a character sheet

If you’re working on a novel, you most likely have many characters.  Even if you only have a few, a spreadsheet can help you keep track of descriptions, motivations, backstories, etc. so that you don’t slip up and confuse the reader.

All the data on one page can also help you compare characters and avoid too many similar characters.

I recommend running the character names across the top, and putting a list of information that you want to track on the left (in Column A).

Create a scene sheet

A list of scenes, usually in chronological order, can help you immensely in organizing your work.  You can keep track of timelines, locations, points-of-view (what character is narrating the scene), and which characters are present.

You can also keep track of scenes to see how long they are, or if they have the requisite story structure of Goal>Conflict>Result or Dilemma>Decision>New Goal.  This can be useful for identifying weak scenes that lack important components of good scene structure.

I recommend one line per scene, with the information you want to track running horizontally.

Example spreadsheet

Check out our Snowflake Method Spreadsheet which contains both of these spreadsheets, and other helpful ways to outline your novel.

List of items to potentially include in a character sheet

You can copy and paste this list into Column A of your spreadsheet.

Name:
One sentence desc:
Motivation (abstract):
Goal(s) (specific):
What’s at stake?
External conflicts:
Internal conflicts:
Epiphany/Evolution:
Backstory prior to this story:
Storyline within this story:
Epilogue after this story:
Loves:
Hates:
Secrets/Shames:
Prides/Abilities:
Flaws/Challenges:
Values/Alignment:
Birthday / age:
Place of birth:
Parents:
Siblings:
Ethnic background:
Places lived:
Education:
Special training:
Jobs:
Wealth:
Travel:
Friends:
Enemies:
Dating, marriage:
Children:
Physical appearance:
Physical build:
Posture:
Head shape:
Eyes:
Nose:
Mouth:
Hair
Skin:
Tattoos / piercings / scars / etc.:
Voice:
Right- or left-handed:
Handicap:
What you notice first:
Clothing:
Health/disabilities:
Characteristics:
How would character describe self:
Interests and favorites:
Collections, talents:
Political leaning:
Food, drink:
Music:
Books:
Movies:
Sports, recreation:
Color:
Hobbies:
Religious beliefs:
A great gift for this person:
Favorite subject in school:
Pets:
Vehicle:
Emotions
Fears:
Idiosyncrasies:
Typical expressions:
When happy:
When angry:
When sad:
Laughs or jeers at:
Ways to cheer up this person:
Ways to annoy this person:
Hopes and dreams:
Overall outlook on life:
Does this character like him/herself:
Wants to change anything about his/her life?
Is s/he lying to himself about something?
S/he is the kind of person who:
How much self-control and self-discipline does he have:
History
Worst thing ever done and why:
Greatest success:
Biggest trauma:
Cares about most in the world:
Does he have a secret:
Most embarrassing thing that ever happened:
Strongest/weakest character traits:
Other people
People the character admires most:
How is the character viewed by others:
What people like best about him/her:
What people dislike about him/her:
What does this character like best about the other main character(s):
What does this character dislike about the other main character(s):
If s/he could do one thing and succeed at it, what would it be:
Why will the reader sympathize with this character:

List of items to potentially include in a scene sheet

These are the column headers for each scene, some of which are shown in the example image above.

Scene Name (for example, a chapter title or your scene’s title)

Scene Summary (one sentence description of what happens)

Time/Day

Location

Point of View (whose point of view is this scene written in?)

Scene or Sequel? (is this a scene, or is this a sequel to a scene)

Goal / Dilemma (what is the goal for the scene, or if this is a sequel, what is the dilemma)

Conflict / Decision (what is the conflict in the scene, or if this is a sequel, what is the decision they reach)

Result / New Goal (what is the result of the conflict, or if this is a sequel, what is the new goal that is a result of the decision)

Characters Present (which characters are here? are they all being involved in the scene)

Significant point in a character arc? (If this scene is a significant moment in a character arc, why?  Which character?  You may want to create a character arc column for each character, to track their development through the scenes)

How to share your work in Google Docs

Sharing your work in Google Docs is easy!

First, find the big blue “Share” button in the upper right corner:

 

A box will pop up with sharing settings.  To share with specific people, enter their email addresses in the box.  To share with anyone by sending them a link, click “Get shareable link” in the upper right:

 

The box will change.  If you want people to be able to leave comments on your writing within the document (highly recommended), change “can view” to “can comment”:

 

Finally, click “Copy link” to copy the link to your clipboard.  Paste it anywhere else (email, chat, etc.) with Ctrl+V