My Great Big Spreadsheet of Ideas - Tips for Writers

I get ideas everywhere. A funny story, a cool name, an interesting place to hide a body, a movie to watch, or a book to read…I had little pieces of paper and Post-it notes everywhere, and it was difficult to keep all the information in one place. I finally consolidated them into a spreadsheet. One column defines what it is (e.g. story idea, cool name, fun location, etc.) Then I have a short description or a link to remind me of what it was or who told me about it. If I see an interesting news article, I save it. Who knows, it may be good material later. By tagging each entry, I can sort it in multiple ways to see what I’m looking for.

When I get ready to start a story or novel, I cruise through my spreadsheet. I also mark the entry if I’ve used it before. What started out as twenty notes is now a spreadsheet with hundreds of lines. I have interesting poisons, funny quotes, descriptions of interesting people, or whatever catches my attention that I want to remember. My desk is much neater now, too. There aren’t twenty Post-its stuck to it and my monitor.

I have a big, giant promotional spreadsheet, too. It has a tab for every kind of promotion or marketing effort that I’ve done in the past. I collect contacts and recommendations and add them to the tab. Then, when I’m ready to start planning a book launch, I have a starting point. I have tabs for everything from blogs and podcasts to Facebook parties and reviewers.

I had to get organized. My writing time is limited, and I couldn’t spend it searching for things I wrote somewhere.

How do you organize your ideas or bits of information?