The Etsy Goal Spreadsheet for 2011

The last two years on my other blog, I’ve given away Etsy Goal Spreadsheets for that year. Keeping an Etsy Goal Spreadsheet remains one of the best things I’ve ever done for my little business. I’ve heard great things from others who have started using it, too. Naturally, we’ve got to keep that going!
Picture of the Etsy Goal Spreadsheet
I’ve been using it for two years now. It’s given me clarity on how much I’ve been selling week by week. I can see on what days people have been buying stuff. I have gratitude that I have been selling regularly. It’s also made me conscious of how things are going for the shop.
All this from just a simple little spreadsheet.

But just tracking isn’t enough. You have to know where you’re going. So I set an audacious goal. Audacious, but hopefully achievable. What this does for me is enable me to really know how well I am doing from week to week, how close I am (or not) to reaching my goals. And then I can adjust accordingly.

So without any further ado:
Download the Etsy Goal Spreadsheet for 2011

Here’s how you use it.
First, add your sales goal (where you’d like to be, sales wise at the end of the year) in the cell below the GOAL cell. (I’ve put 500 in randomly, but change it to whatever your goal is.)
The first column has weekly dates in it. Along the top are the days of the week. Enter how many sales you’ve had on any given day. They’ll automatically subtract from the Left to Go cell. That’s it!

Notes:
* Feel free to share & change this willy nilly, but please let people know you found it at http://absolutelysmall.com/blog
* This spreadsheet is an .xls file. In other words, it’s made to be opened with Excel, but can (hopefully) also be opened by a number of other programs. (Numbers, Open Office, etc.)
* It may be titled Etsy, but of course this spreadsheet would work equally well for Artfire, your own site, or whatever else it is you need to track.

*1/1/11 – The dates have been corrected. However, dates pulling up as #### has been reported. This is not a spreadhseet error. Simply widen the column to make those pound signs go away.
(Thank you Chrystal S & Madeline from the comments for pointing this out!)

About Claire

Absolutely Small is textile artist Claire Chambers. Claire Chambers is a crazy-pants artist/crafter who spends most of her time indoors, very near to Portland, Oregon. She likes making people laugh, chickens and pugs, and writing about herself in the third person. She is utterly obsessed with making things out of fabric.

Comments

  1. Oooh, this is great! I’m working on a blog post for Thursday about setting goals, so I’ll be adding this in. Thanks for sharing!

  2. Thank you so much for making this! I used the 2010 one and loved it! It was rather interesting to see when I was really busy, but seeing the dry spells sometimes can be a little discouraging. xD I did reach my goal of 200 sales though and got 50 more! Woohoo! :D Here’s to a great 2011!

  3. Thank you so much for sharing this brilliant tool! I just read your post on the Etsy forums about it and popped by. Tracking goals is a great way to stay focused and this sheet will help me to see the days that are busy and ones that are less so.
    Thanks again.

  4. Great little tool! I’ve downloaded it and will be linking to it in a blog post later this week as well. Thanks!!

  5. Thanks for the post..I saw this some time ago..maybe the 2010 version and forgot about it…well now its on the desktop:)

  6. I downloaded, and will share on FB business page…now I just need to make myself use this….the computer should kick out a treat if I fill in a column…don’t you think?

  7. I’ll try it out, thanks. Shared on Twitter and Facebook. :)

  8. Thanks for making this spreadsheet! I set a lofty goal but I am going to give it a whirl!

  9. Thank you, this is such a great tool!

  10. ok, I’ll give it a try.

  11. thank you for this. i hope that you reach your goal & above for sharing this with us!!may the universe reward you with what you want.

  12. Thank you so much – I’m planning to open up my ETSY store this year so this will help loads!

  13. Thanks. Downloaded it and will try to use this tool in 2011.

  14. thank you so much! I love this idea and look forward to seeing how I do this year.. you rock!

  15. Thank you soooo much for sharing this spreadsheet. It is EXACTLY what I need to start the year off on the right foot. Love it!

  16. Thank you so much, I love statistics and will give this a really good go.

  17. I’m going to try this out and then recommend it to all my team. Thanks for sharing! :)

  18. Brilliant! So kind of you to share this!

  19. Thank u so much for sharing !

  20. Chrystal S says:

    This is very cool! Thank you so much for sharing! You are awesome! :)
    As for the # #### coming up in the date column, the column just needs to be a little wider… Works like a charm!
    Thanks again!!! :)

  21. Thanks so much for making this! I can’t wait to try it out! And also, fyi, when dates come up as ######, all you have to do is widen the column.

  22. Brilliant – thank you!

  23. Thank you so so so so much! This was an extremely useful tool for me in 2010. Felt so good about almost reaching my little goal! This year, I intend to aim a LOT higher! :D

    Goddess bless you for sharing such a lovely gift with all of us! :)

  24. Thank you so so much! I love having something to motivate and record my sales, but generally I’m too impatient to make my own spreadsheet! This is perfect.

  25. This is great, thanks for sharing!

Speak Your Mind

*