One Mom’s Journey from Fat to Skinny to Confident


Keep Track of Your Weigh with Google Docs!

16 Comments 3124 views

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.

Leave a comment

I’d love to hear your story or thoughts on mine.

However, to prevent the massive amounts of spam I was receiving I have turned off comments on any post older than 5 days old. If you'd like to leave me a note regarding this post or anything really try me on twitter (@RoniNoone,) my Facebook page, or even IG (@RoniNoone) I'm so sorry for the inconvenience. I never thought I'd have to do this but it's gotten way out of hand and comment management has become simply too time consuming to manage.


There are 16 comments so far.


    November 15, 2012

    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!

    Evelyn Grace

    November 15, 2012

    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 :)


    November 15, 2012

    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! :)


    November 16, 2012

    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!!


      November 17, 2012

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


      November 21, 2012

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

    Kathy Winders O'Halloran

    November 16, 2012

    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?


      November 17, 2012

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

      Kathy Winders O'Halloran

      November 17, 2012


    Diana Schnuth

    November 16, 2012

    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!


    November 16, 2012

    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.

    weight loss solution

    November 17, 2012

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

    Karen P

    November 18, 2012

    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.


    November 20, 2012

    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.


    April 5, 2013

    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.


    December 6, 2013

    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?