[mhstar99]

Is there a way to export the logs from the GB website to Excel?

If not, this would be very handy.

Thank you,
Mysi

[lmadsen]

I just want to add my vote to mhstar99's. I've been keeping Excel records since I was diagnosed 5 years ago. If possible I'd like to avoid entering everything twice. Thanks...

[dano]

There is a way to create an Excel file from the current GB information. First you have to "push" email the logs to yourself. Then you have to copy and paste this information into a text file. Next you have to open a new Excel file and import the text file into the Excel file. It works great, you will just have to play with it to know how it works. I will tell you that the key is using the delimited text, with commas, see the Excel Help by searching for import text file. I know that you have to jump through a few hoops to get what you want, I just wanted to let you both know that this is possilbe to do. Here is a Screen Shot of the final product. I hope that this information helps!

[mpace]

This only works if you mail them from your phone, I *really* need to be able to export to Excel from the web.

Apparently I use GB a bit differently than most - my son is a T1 and we both have the Touch. He (the school nurse) uses his to enter in his BG numbers during the school day and upload them to the web when he comes home, and we'll use either one during meals, and mine when I check him overnight. Being able to sync both iPods to the web is fantastic, but makes getting the data to his diabetes team a bit problematic.

[dano]

I do agree with you that it would be most benificial to have the ability to create reports, from the GB webiste, in several different formats.

However, I am afraid that your only current solution is to push the information from both iPod Touchs and implement this information into the text file by time and date stamp. I am sorry that I can't be of more help.

[newbeginning]

Put me down in favor of exporting to Excel. That couldn't be easier to implement, I'm sure. You can also copy and paste your date straight from the website into a text editor, and then do a series "Find and Replace" actions (for example, find "BG" and replace with "BG" + TAB).

[tmeehling]

Importing into Excel or Access is fairly simple to do, however, we would benefit greatly if the format of the CSV file could be tweaked. In order for Excel or Access to import the Date and Time fields they need to be in a format of mm/dd/yyyy hh:nn:ss. Currently they are broken into mmm dd, yyyy, hh:nn AM. With this format you can only import as text fields and therefore cannot create meaningful graphs/reports. I've tried many of these applications and GB is the best I've tried so far. It just needs a few tweaks. If GB could provide the Date/Time field as ONE field formatted as mentioned above, it would be a great improvement.

[dobrecht]

A couple of things:

If you have a large log, it will be truncated to around 3800 characters when emailing.

It would also be nice if the values were strictly numeric (ex: 140) vs alphanumeric (ex: 140 mg/dL). I would like to graph the out of bed values over time to determine if the Metformin is doing its job. Do trend lines, etc.

[superchop]

Try Copy/Past from Website to Excel. You'll have to format the results to match your older Excel logs.

[hoj201]

Originally Posted by tmeehling

Importing into Excel or Access is fairly simple to do, however, we would benefit greatly if the format of the CSV file could be tweaked. In order for Excel or Access to import the Date and Time fields they need to be in a format of mm/dd/yyyy hh:nn:ss. Currently they are broken into mmm dd, yyyy, hh:nn AM. With this format you can only import as text fields and therefore cannot create meaningful graphs/reports. I've tried many of these applications and GB is the best I've tried so far. It just needs a few tweaks. If GB could provide the Date/Time field as ONE field formatted as mentioned above, it would be a great improvement.

I agree, we desire a flexible CSV format in order to use this data more effectively. (BTW: Watchout, your competitors at ``iabetics'' are offering this feature).