Free Blood Sugar Log Sheets

John Crowley
By John Crowley Latest Reply 2018-04-25 01:24:17 -0500
Started 2009-11-11 11:22:56 -0600

We've been working together with Diabetic Connect member Father Fred to make it simple to download an Excel spreadsheet that is set up for tracking your blood sugar.

We're excited to offer these free diabetic log sheets to the community to help you better track your blood sugar tests and see trends. I'm familiar with a study of diabetics on insulin that showed that there was a direct correlation between how often a patient tested their blood sugar and lower A1c values. More testing = lower A1c.

So here are a few different spreadsheets to help you track your blood sugar. Each one is set up a little differently. You're welcome to download them all and see which one works best for you.

The "official" Diabetic Connect Blood Sugar Log

Father Fred's Blood Sugar Spreadsheets:

107 replies

Waxtadpole 2014-08-29 23:19:20 -0500 Report

Are there any instructions for the Diabetic Connect Blood Sugar Log Sheet? I don't know that much about Excel. Does the sheet do the charts at the bottom automatically? I'd appreciate it if there is a set of instructions.

John Crowley
John Crowley 2014-09-02 16:23:15 -0500 Report

Waxtadpole, thanks for asking. Yes, all of the charts and such are automatic. Here are the instructions for using the sheet:

1. Enter the date for the first of the month on the appropriate day of the week.
For example, if the month starts on a Wednesday, enter the mm/dd/yy on Wednesday on the first week of the new worksheet.

2. Click on the lower right-hand corner of the cell containing the date for the first day of the month, then drag down to Saturday of the first week.
The dates for the remainder of the month will automatically fill in.

3. Record your blood sugar readings and the time you tested your blood sugar by clicking in the appropriate cell for the reading, typing in the number, and then hitting return/enter on your keyboard. Use the colored columns to enter your blood sugar readings. Remember to enter the date and time of your test as well.

4. Use the averages and charts to analyze your blood sugar control.
Below the section where you enter your blood sugar readings, you'll find the analysis section. Pay attention to your averages from different times of the day to see where you need to make changes.

Glenn119 2014-04-01 08:06:23 -0500 Report

I downloaded the 4 week master and find some of the cells in week 2 locked? Anyone else have this problem? Really would like to continue using this sheet

John Crowley
John Crowley 2014-04-01 16:12:34 -0500 Report

Glen, sadly Father Fred, the member who made the 4 week master, has passed away. And we were never able to get from him that password. We've tried to update his sheet however, he also locked all of the cells for the calculations. So even though we can create a new sheet to input your data, we can't get the sheet to include that data in the weekly summaries. Sorry about that.

Glenn119 2014-04-02 06:25:44 -0500 Report

I was able to unlock all the cells, with the help of an IT friend :)

Glenn119 2014-04-02 13:18:58 -0500 Report

My friend used a program called "Excel Password Recovery Pro" and that gave us the password. Did you want me to post the password here?

valjean 2014-03-16 12:54:12 -0500 Report

Thank you so much for this. I downloaded one years back and was using it until my computer died and then I couldn't find another. I have ben on this computer for four hours searching. I am so happy to find this.

Chuck Fisher
Chuck Fisher 2013-11-13 09:14:50 -0600 Report

If you have an iOS device, I would recommend "bant", which can be downloaded FREE from the App Store. You can store a considerable amount of data and send an email to yourself (or doctor) with values in CSV format which is suitable for virtually all spreadsheets, including Excel.

randsboy 2011-11-10 16:23:57 -0600 Report

Ok - being new at this thing I have to say that I truly do not understand the pourpos of this spreed sheet. I only test twice daily and since there is only one computor - i don't have much access during certain times of the day. I also tent to sleep way too much of the time, especially since some of my other meds have been drastically reduced. I attempted to print the spread sheet but alas is much larger than is truly posible to print even one entire sheet. Also how exactly does the sheet function?? Is it any different than my paper or hard copy log i use on a daily basis?? Does this calculate an average or is there something i am truly missing here?

valjean 2014-03-17 17:25:55 -0500 Report

I have modified the sheet which gives me much information to control my blood sugar. I have added spaces for insulin taken, food eaten, how I feel for day, appts, etc. Select only what you want to print and print only the selection. This info is important for the doctor to see and it also helps you to see which foods raise your glucose level and other things. It does calculate the average. If you would like I can send you my Master sheet. It is priceless. Send me your emaill address and I will send it to you. My email address is small.

GabbyPA 2011-11-11 09:21:47 -0600 Report

Nope, do what works for you. There is not "right" way. Just a way to track it for you and your doctor. I am a paper hound and tend to go to paper just for the reason you are saying. I can have that with me everywhere. I'm not an i-pad or i-phone user, so paper is my friend.

jayabee52 2011-11-10 16:33:41 -0600 Report

To really get full use of it you'd need to use it on the computer. Then you can get it to do some interesting things like average your numbers every month and even send it to your dr via email.

I use a spreadsheet of my on design but it is nowhere near this fancy.

Blessings to you


OldTrojan 2011-11-07 21:15:46 -0600 Report

Page 2 is Protected and requires a password ! Anybody here know that password? Thanks. Page 1, 3, 4 are not protected. Regards,

John Crowley
John Crowley 2011-11-08 13:27:43 -0600 Report

Which one are you using? The "official" Diabetic Connect spreadsheet should only have one page. I'm not sure about the Father Fred ones as I haven't used those.

OldTrojan 2011-11-08 17:28:58 -0600 Report

You're right, I was using one of Father Fred's and it is one of those that has week #2 protected. But, I have switched to another 3 month log of 4 times a day for my loved one. I found the link for that farther down in this discussion. I think the file name is like BG2.xls. It figures the estimated A1C from the values you enter. I want to see how the A1C calculation from that spread matches the actual at the doctor's office. This site is an excellent resource and guide to resources.

OldTrojan 2011-11-09 14:40:00 -0600 Report

hi kaiya, Those were not on this site/thread as I thought, but I found them again. They are at: >> << The files are BGV1.xls and BGV2.xls. I am currently using BGV2.xls. They are not fancy, they work, they are very straightforward — and are not protected, like I found Page 2 of Father Fred's to be.

jayabee52 2011-11-08 22:37:54 -0600 Report

The kinks are in the original post above. You might want to look at them all. I checked further down in the discussions and the only link was in a reply by Kirla to loan

But when I tried it it was all about banking and making loans. I tried to do a search in that site, but every search term for the logs proved fruitless. But reading around in the site there had been some changes recently so perhaps the logs were deleted from the loan universe site

Rustydip 2011-09-26 11:53:18 -0500 Report

This is what I want but I can't get any of them to open… I had it in my Microsoft Works but it accidentally got changed & is gone now! How can I get it back???

PastorBob 2011-09-26 21:37:38 -0500 Report

I'm no expert, but I would try downloading it again and see if that works for ya. I use it all of the time, it's what I was wanting. Good luck!

Flustrated 2011-04-07 16:25:15 -0500 Report

Got into spreadsheet but can not open, said something about changing password. Any ideas.

John Crowley
John Crowley 2011-04-07 17:58:37 -0500 Report

None of these spreadsheets is password protected. I'm not sure why you would be getting that message.

What version of Excel are you using?

LabRat90 2011-03-02 16:18:10 -0600 Report

I just found these files. It sure would have helped me not have to create one for myself. But alas - It's almost the same. Good job! I'm so sorry to read that Father Fred has died. He was a good man to want to help so many. These files are life savers to some I sure.

julyanne 2011-02-05 20:32:09 -0600 Report

the bayer is able to go on line i think in spread sheet form it will download your sugars .Pretty neat

mugglemom 2010-10-04 08:31:17 -0500 Report

I get an file error on the "Official" Blood Sugar Log. "Data May Have Been Lost". I run Windows XP and have Office 2007. Does this make a difference?

John Crowley
John Crowley 2010-10-04 09:58:42 -0500 Report

Yes, we've recently been made aware that Microsoft for some unknown reason decided to stop supporting macros. The "official" Diabetic Connect Blood Sugar Log used macros to make it easier to set up a new sheet for each month. We're working on an alternate version that doesn't use macros.

Sorry about the inconvenience. If you download the Father Fred versions, those should work without any problem.

rcmodelr 2013-11-13 17:24:57 -0600 Report

In what version of Office did Microsoft stop supporting macros? I have Office 2010 on 2 computers and Office 2013 on my tablet, and even in Office 2013, Excel and the other applications still support macros. However, they used to use, I think it was XML or XLM programming language for the office macros until Office 97. Since Office 97 & Office 2000 however, they now use VBA as the macro programming language. Their macros are now, for at least the past 13 years, use a version of Visual Basic or VBA unless they've decided to totally dump macros in an Office version NEWER than Office 2013.

Thomas508 2010-10-04 10:32:41 -0500 Report

Microsoft has ruined all of their products under the name of security! If it would work I would love to go back to Windows 98! Each new version of each product has more security stuff so that you can not do all the things you used to do! I think they should allow us to use what we want how we want at our own risk.

Son Sean
Son Sean 2010-06-18 16:36:46 -0500 Report

My name is Sean Munzlinger or Kenneth Munzlinger which ever you prefer. My Dad, Fred, usually called me by my middle name Sean but most know me by my first name Kenneth or Ken.

I am regretfully writing all of you to inform you that Frederick D. Munzlinger has died. Fred died on May 4th 2010 (Star Wars day!) after a two week battle with a very aggressive leukemia and receiving an equally aggressive chemo treatment. May the 4th be with my Dad… always.

Before Dad died I was aware that he was making free Excel based charts for fellow diabetics to download. What I did not know was the number of people that his efforts were helping. I am collecting information regarding his project so that I can help “Father Fred” to keep helping others.

I will be assisting Fred with his little project as best I can but I do have a day job, software development projects of my own, and a two year old boy. What I am hoping to do is continue to offer the same tools that my Dad has created and to also improve them. I have some very good software development tricks up my sleeve as I am a software developer by trade. Hopefully the end result will be some mobile versions of his ideas for Android or iPhone users.

My first step is to gather all the information I can that Fred left behind and make certain that his work is made available for free. This includes going through his email and replying to messages that have gone unanswered. My second step is to learn a considerable amount about Diabetes and I know nothing about Diabetes. Lastly, I hope to improve upon his idea and help Dad accomplish his goal of helping even more people, for free.

Warm regards,

Kenneth Sean Munzlinger

MAYS 2010-06-18 17:28:18 -0500 Report

That is very kind and thoughtful of you to continue his work.
I wish for you nothing but the best and much success in doing so.


Splender 2010-01-15 17:27:05 -0600 Report

The last two look a lot easier to use to me. I think when I decide it probably by the 4 week one that I will try to use. It really beats using up book after book and not knowing when you will get your next one from when you run out. I think I'm going to like it.

Helene (Splender)

Bobbie1 2010-01-15 12:34:23 -0600 Report

I can't seem to download them :(

John Crowley
John Crowley 2010-01-15 14:47:18 -0600 Report

What happens when you click on the links?

Bobbie1 2010-01-15 22:53:37 -0600 Report

I showed my boyfriend and he said that I need ( excel ) which I dont have so I can't down load it yet I'll see if I can have some one print it out for me thank you

Father Fred
Father Fred 2010-01-17 16:24:21 -0600 Report

you can use open office instead of Excel. Google open office the download the files. It is very similar to Microsoft Office only it is free.
Fred Munzlinger

Danni-the-diabetic 2010-01-10 16:08:31 -0600 Report

Call me stupid! But I cant copy this anywhere on my cp…I am so computer illiterate!!

John Crowley
John Crowley 2010-01-15 14:44:31 -0600 Report

Clicking on the link should bring up a box that asks you what you want to do with the file. Are you getting that box?

If you're getting that box, you should choose to Save the file to your computer. Depending on what kind of system you're on, it will either let you choose where to save it (in this case be sure to save it in a folder that you know how to find again like "Documents") or save to a pre-set place in your computer (usually the desktop or a folder called downloads).

I hope that helps.

nerdse 2010-01-07 14:20:29 -0600 Report

THANKS! I've been trying to make my own work, but these save me further work. If it's OK, I'd like to put these links in my blog, plus maybe share with people on other boards for my other chronic conditions. Many of them also have diabetes, or care for/know someone who does.
BTW more questions: Who would I ask for permission to link to this site? Is dc on facebook? Ifnot, can I share these links on my FB page?

PastorBob 2009-12-01 18:05:01 -0600 Report

This looks pretty good! It'll be better than jotting it down in a notebook.

gregsDAD 2009-12-01 20:33:29 -0600 Report

i downloaded them just a few days ago and tehy seem very easy to use.

Anonymous 2009-12-12 22:05:57 -0600 Report

This looks good to me.

The "teacher" in me insists that I suggest you check the spelling of Saturday.

Father Fred
Father Fred 2009-12-14 13:38:48 -0600 Report

You are absolutely correct about the misspelling of Saturday. I also copied the misspelled word throughout the spreadsheet. I apologize for my spelling. My only excuse is that I am an engineer and a computer geek. Thank you for your observation, I will be making changes to the spreadsheets. I check and I check and I test and I test but I still make mistakes. Your feedback is greaty appreciated.
Father Fred

Julie Ann
Julie Ann 2010-01-09 11:16:42 -0600 Report

greeting Bob and blessing in the name of Christ!!!!

I don't come on to this site but rarely and alas this talk about down loading an easy to use spread sheet for charting caught my eye. can you please tell me what and where to get it?

Mckenzieann 2009-11-29 19:33:50 -0600 Report

I am unable to download these spreadsheets. Very dissapointed.

John Crowley
John Crowley 2009-11-30 10:46:53 -0600 Report

So sorry you're having trouble. You should get a pop up box that asks you if you want to open the document or save it to your computer. Do you get any kind of message or pop up box?

Father Fred
Father Fred 2009-11-24 22:02:48 -0600 Report

Well John you got a lot of views but I wonder how many people are downloading the spreadsheets. I hope they are helping a lot of people. I noticed that you have it in the newly diagnosed category which I think is great.
Fred Munzlinger

judy makowski
judy makowski 2009-11-17 20:17:49 -0600 Report

John for some reason I can't get this to print. I gt the wording but not the sheet. I disabled macros and still can't get it. Am I doing something wrong.

texaswoman 2009-11-17 20:24:20 -0600 Report

I have also downloaded the spreadsheets to track blood sugars, but can't seem to get them to work,
also was wondering if I could use flash/thumb drive to run them, as I do some travling and need to use my laptop.

John Crowley
John Crowley 2009-11-18 09:52:00 -0600 Report

There are a couple of tricks to printing what you want in a spreadsheet. First, you need to click on the top left cell and drag to the bottom right cell of the entire area that you want to print. This should highlight the area. Then click on "File" in the menu and to to "Print Area > Set Print Area."

Then if you want it to print the gridlines around each cell, go to "File > Page Setup." Click on the "Sheet" option, then look under the "Print" heading for a checkbox that says "Gridlines" and make sure that box is checked.

If you want everything you highlighted in step one to be printed on one page, go to "File > Page Setup" again and this time click on the "Page" option. Under the "Scaling" heading, click the button next to "Fit to:" and then enter 1 page wide by 1 page tall and click OK.

Then you should be able to print.

2rs 2009-11-16 14:01:35 -0600 Report

Fred! these charts are fantastic!! I'm an unreformed Lotus Lover, now Excel Enthusiast & know what it takes to build a spreadsheet such as yours. Thanks for expending the time & dedication & your willingness to share! The best to you, Gay Rose

2rs 2009-11-16 14:03:45 -0600 Report

forgot to tell you - I just celebrated by 3rd anniversary & doing pretty good, even if I do say so. But, it is sooooo easy to slip back into bad eating habits, especially this time of year. Which means its more imortant than ever to track BS levels.

Father Fred
Father Fred 2009-11-16 19:38:22 -0600 Report

I am glad you have the spreadsheets. I hope they help you control your blood sugar level. Keep track of everything you eat and analyze your data. You can do it. You can change your eating habits but it takes a lot of work.
Best wishes
Fred Munzlinger

Next Discussion: .Veterans Day »