I'm Tammy. 

COPYRIGHT INFO:  All content [words, photos, images, artwork, descriptions, designs] is copyright Daisy Yellow. Please use the contact form if you'd like to use content. Copying art + ideas is not cool. If you pin my stuff, please kindly attribute. Thanks!

Newsletter Sign-Up!
This form does not yet contain any fields.
    Login
    « Selective Noticing No. 3 | Main | a wish »
    Monday
    Mar052012

    Creative Geek: Turn your quotes into random phrases

    To turn your favorite quotes into random phrases, there are a few requirements:

    1. You are intrigued by wierd, random phrases like those below
    2. You are adept with Excel or Numbers or someone who is adept owes you a favor
    3. You've got a collection of quotes in a digital file OR favorite quotes saved on Goodreads

    As much as I like to make art, I like to use Excel! Another place where my creative and analytical sides meet. But I am warning in advance that I won't do Excel tech support. 

    The general idea is to get a bunch of quotes in digital format, merge the words together and sort a bunch of times. So here are the steps:

    1. Export your quotes from goodreads: go to Explore, Quotes, My Quotes, Export My Quotes

    2. The CSV file you've downloaded will look something like this in Excel or Numbers

    3. Here are the Excel commands from the older version of Excel (I use the older version (prior to Vista) because I can use it without having to figure out where Microsoft has decided to hide all of my favorite commands in the version I got with Vista). If you are an accountant or Excel junkie you will get the idea. This will work fine in Numbers, with slightly different commands of course. If you figure out the commands in Numbers, please let me know.

    delete all columns except column titled Quotes
    select column titled Quotes
    format - column width - 25
    select column titled Quotes
    edit - fill - justify
    select column titled Quotes
    data - sort (ascending or descending)
    select column titled Quotes
    format - column - width - 100
    select column titled Quotes
    edit - fill - justify
    select column titled Quotes
    format - column - width - 25
    select column titled Quotes
    edit - fill - justify
    select column titled Quotes
    data - sort (ascending or descending)
    select column titled Quotes
    format - column - width - 100
    select column titled Quotes
    edit - fill - justify
    format - column - width - 50

    change the font every few rows

    When you get all of your quotes set up as you want them, just print on transparency paper, tissue paper or heavy cardstock. Then as you work in your art journal and make collages you will have this assortment of random words with intriguing phrases not of your own invention.

    Perfect journal fodder, right?

    EmailEmail Article to Friend

    Reader Comments (8)

    fascinating. neither my husband nor I was familiar with the "Fill" command (we're both engineers, but neither of us uses excel all that extensively) so I just copied in a few quotes to give it a try. Not sure whether I'll use the phrases or not, but it is an interesting idea. They'd make interesting ATCs, too.

    So interesting and clever.... Guess I better start typing up all those post-its of quotes that I have all over the house! :-)

    Oh, how fun! I'm looking forward to playing with this!

    03.6.2012 | Unregistered CommenterPrairieJill

    The use of Excel with my favorite quotes also hits on both sides of my brain. I'm a math teacher by trade and a writer/artist always. What a fun idea! I can even imagine turning some of these seemingly random collections of words into a poetry writing prompt! Thank you for continuing to share such really interesting ideas.

    03.6.2012 | Unregistered Commentermeme

    Fabulous! This is like a computerised version of my fridge poetry magnetic words - only faster and more varied :D I wonder if David Bowie utilises this for his song lyrics - apparently he does a paper version of this (or at least used to) for his songs *hehe!*

    this is a pretty cool idea, thanks for sharing!

    03.7.2012 | Unregistered CommenterCaatje

    Hum- interesting concept but techno Queen I am not. That would be a good stretch - more like the Grand canyon for me. Thanks for inspiration.

    03.7.2012 | Unregistered CommenterCarol

    I can't even tell you how much this appeals to my geek side!

    04.11.2012 | Unregistered CommenterNatasha

    PostPost a New Comment

    Enter your information below to add a new comment.

    My response is on my own website »
    Author Email (optional):
    Author URL (optional):
    Post:
     
    Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>