After posting yesterdays weigh in I was inpired to dig up my old weigh loss tracking spread sheets and port everything into a google doc. Do you guys use google docs? I’m obsessed!

Anyway, I have my old weight loss tracker page but honestly, it’s a beast to upkeep and navigate. I love having the data (I’m a bit of geek) but keeping it in a nice, friendly, accessible format for the blog is another story.

Now that’s it’s in a google doc I can publish and embed it on the site. Look how cool…

I have over 7 years of data because I’m a dork, so I created a sheet for each year and accounted for the years I didn’t track. If you are just starting, it’s way less complicated!

Go to google docs

Click Create –> Spreadsheet

Enter Date,Weight and Notes in the first 3 columns.

Start tracking!

See, easy.

Now, if you want to include a chart which I find REALLY fun (cause geeks love data) all you need to do is click the…

Chart button.

Then select your data range using, choose “line” as the type and viola! Chart.

When you create your document it’s defaultly set to private but you can allow specific people access to it or make it public. Just go to File –> Share, to grant access.

You can also publish the spreadsheet and embed it in your blogs like I did here. That’s also found under the file menu –> Publish to the Web. There you can grab the link to the document or choose HTML and copy the code for your blog. The best part… when you make edits to the spreadsheet all you have to do is “republish” and your blog is automatically updated!

Man, I wish I thought of this earlier!! Let me know if you have any questions. This is how I’ll be tracking from now on.

 
  • Cindy

    OMG – Thank you so much! This is EXACTLY what I’ve been wanting to do but never could be bothered to figure out how to do it. I’m tired of graph paper!

  • http://www.facebook.com/evelyn.whitelaw Evelyn Grace

    This is awesome! I had a frustrating weigh in this morning and this really helped me to visualise the big picture. Thank you so much, it’s exactly what I needed right now :)

  • Gray

    Hi Roni,

    This is great! I’m a college student, and my height is about 2 inches on you, my high school graduation weight and my current weight as a junior follows your numbers. I’ve known that I’ve been slowly gaining weight and keep telling myself I need to do something about it. This tracker is a great inspiration! I keep telling myself that it’s ok to have gained 10-15 pounds in college and that it happens, but deep down, I know i’m just trying to make myself feel better when I decide to eat something “bad.” I’ve been telling myself this for awhile, but I know that it’s not what I need. I actually do love how exercising and eating healthy makes me feel, but I’m easily pushed back to comfort foods during stressful periods and forget to exercise. I’ve been a reader for awhile and love all you write and it just shows me how important it is to get myself on track now! I love your recipes too! Thanks for being a great inspiration to this young girl who knows she struggles with her relationship to food and was unable to articulate it until reading this wonderfully funny and honest blog! :)

  • Svanhvit

    This is sooooo cool! I think I will actually do that. You will still be doing the wednesday weigh in here, though, won’t you?? I really like the accountability and control. And with Holiday Season coming up I think we can all use that.
    Can you believe someone just came and asked me to buy a box with like 5 lbs of candy? I flat out said no. If I have it, I eat it. So I would rather just not have it in the house!!

    • RoniNoone

      Yup! We’ll still be weighing in! :)

    • Svanhvit

      Awesome! I like that. December has me worried a bit.

  • http://www.facebook.com/profile.php?id=1619955238 Kathy Winders O’Halloran

    Hi Roni,

    I’m clueless when it comes to this type of thing. Do I enter the Date, Weight, and Notes in the line #1 or where it says A,B, and C?

    • RoniNoone

      You start typing in line 1. The A, B, and C are just column markers like the 1,2,3, etc.

    • http://www.facebook.com/profile.php?id=1619955238 Kathy Winders O’Halloran

      Thanks!

  • http://twitter.com/dianaschnuth Diana Schnuth

    Great tip, Roni! I too have an Excel spreadsheet of my weight, going back to my obese, pre-marriage days in 2003. I should totally upload that to Google Docs — I’ve copied it from computer to computer as I’ve upgraded over the years, and I’d HATE to lose all that data. Plus, being able to automatically publish it on my blog would be a bonus!

  • Tami@NutmegNotebook

    That is a great tool. I use the free My Fitness Pal to track my food, exercise and weight and it works well for me.

  • http://twitter.com/weightlossnow9 weight loss solution

    Wow….this is amazing! What a great tool to lose weight and to keep the weight off!!

  • Karen P

    HW: 187.4
    CW: 113.4
    Goal weight 115.4
    Height 5’1”
    Age- mid 40′s.
    Time at maintenance 9.5 months.

    I love the idea of graphing weight. I’m going to try tracking my walking steps from my pedometer with my weight over one month. I recently discovered that the two are very closely related. Thanks again for sharing this tip. Fabulous.

    So much to learn from the weight graph when correlated to eating and exercising habits- IMO. Powerful tool.

  • jamie

    Ha. This is awesome. I totally have the same thing. I used to keep excel sheets but ported it all over to Google Docs this past summer. Then I went nuts and dug up weights from old gym cards/high school notebooks, etc. I even asked my Mom for my baby/childhood records and graphed them. So I basically have my weight across my entire life. It’s very interesting to see the changes in trends and note specifically what was going on in my life during that period. I did this before meeting with a nutritionist and while impressed, she may have thought I was nuts. ;) I’ve thought about posting it to my blog but I guess I’m always waiting to be a “success story” – not the healthiest way to view yourself but an honest one. I know we are all progress stories.

  • http://www.weightplan.com/ Justin

    Thanks for sharing a great information about weight loss here. I think these all tips are very effective and useful to who want to lose your weight. Definitely I will apply your weight loss tips.

  • http://twitter.com/KaylaWildflower @KaylaWildflower

    Roni, I know you posted this a year ago, but I’m having a problem. The Google line chart won’t recognize the dates. Instead it’s using 1/1/2000, 1/1/2010, 1/1/2020 etc! A LOT of people can’t get dates to work with charts – just look online. How did you get it to work?

BlogToLose

A Community of Weight Loss Bloggers. We are here to support, cheer on, pick up and reach our goals together! Join Us!
Check out Roni's Other Sites... Just Roni | GreenLiteBites | The Unworldly Travelers | FitBloggin' | BlogToLose | SkinnyMinnyMedia