The Glooko PowerShell module streamlines the processing and conversion of exported diabetes data from Glooko into user-friendly formats. The module or the author are not affiliated to Glooko.com

It provides robust import functions for Glooko CSV files, zipped data sets, and entire folders, consolidating and parsing metadata to simplify analysis for technically inclined users. The module includes advanced export capabilities to generate detailed Excel summaries with separate worksheets for each dataset. Internal helper functions ensure accurate merging and transformation of data, while a comprehensive test suite and code analysis maintain reliability across Windows, Linux, and macOS. Designed for PowerShell 7+, this module is ideal for personal data exploration and custom analytics by tech-savvy individuals.

Looking ahead, future versions will build upon ongoing work to provide static analysis of imported data—including advanced CGM (Continuous Glucose Monitoring) statistics. This will enable automated quality checks, anomaly detection, and more insightful glucose metrics, further enhancing the analytical capabilities of the module.

Disclaimer: This module is intended as a technical tool to assist with personal data analysis. It is not a substitute for professional medical advice, diagnosis, or treatment. Always consult with qualified healthcare professionals regarding any medical concerns or decisions.

Note: This module requires PowerShell 7.0 or later. It is not compatible with Windows PowerShell 5.1.

The recommended way to install this module is from the PowerShell Gallery:

# Install the module
Install-Module -Name Glooko

# Verify the module is loaded
Get-Module Glooko -ListAvailable

To update to the latest version:

Update-Module -Name Glooko

1. Clone the repository:

git clone https://github.com/iricigor/Glooko.git

2. Import the module:

# Navigate to the module directory
cd Glooko

# Import the module
Import-Module .\Glooko.psd1

# Verify the module is loaded
Get-Module Glooko

For more import options including using Install-GitModule, see Alternative Import Methods.

This module provides the following functions:

• Import-GlookoCSV - Imports CSV data while skipping the first row, see detailed documentation.
• Import-GlookoFolder - Imports all CSV files from a specified folder using Import-GlookoCSV, see detailed documentation.
• Import-GlookoZip - Imports data from a Glooko zip file by extracting and processing CSV files, see detailed documentation.
• Get-GlookoDataset - Filters datasets by name and returns only their data, making it easy to work with specific dataset types like 'cgm' or 'alarms', see detailed documentation.
• Export-GlookoZipToXlsx - Converts a Glooko zip file to an Excel (XLSX) file with a Summary worksheet as the first tab, followed by each dataset in a separate worksheet, see detailed documentation.

• Get-GlookoCGMStats - Analyzes CGM data and provides basic statistics (below range, in range, above range) grouped by date with counts and percentages, see detailed documentation.
• Get-GlookoCGMStatsExtended - Provides flexible CGM analysis supporting both 3-category (low/in range/high) and 5-category (very low/low/in range/high/very high) analysis with date range filtering options, see detailed documentation.
• Get-GlookoDailyAnalysis - Analyzes CGM and insulin data grouped by day of week (Monday-Sunday) and workday vs weekend, with daily insulin dosages, percentages, and correlation analysis, see detailed documentation.

All functions include comprehensive help documentation. Use PowerShell's built-in help system:

# View basic help
Get-Help Import-GlookoCSV

# View examples
Get-Help Import-GlookoCSV -Examples

# View detailed help
Get-Help Import-GlookoCSV -Full

For information about help file generation, see Help Generation Documentation.

# Import a Glooko zip file
$data = Import-GlookoZip -Path "C:\data\export.zip"

# Get data from a specific dataset (e.g., CGM data)
$cgmData = $data | Get-GlookoDataset -Name "cgm"

# Or convert directly to Excel
Export-GlookoZipToXlsx -Path "C:\data\export.zip"
# Creates C:\data\export.xlsx with:
# - Summary worksheet (first tab) showing overview of all datasets
# - Each dataset in a separate worksheet

We welcome contributions! Please see our Contributing Guide for detailed information on how to contribute to this project.

For a detailed list of changes, see the CHANGELOG.md file.

This project is licensed under the MIT License - see the LICENSE file for details.

• Awesome-CGM - Curated list of publicly available Continuous Glucose Monitoring (CGM) datasets for research
• GlucoBench - Benchmark datasets and tasks for glucose prediction with machine learning
• iglu R Package - R package for interpreting blood glucose data (Broll et al., 2021)
• Nightscout - Open-source platform for collecting, storing, and visualizing CGM data
• Glooko.com - Official Glooko platform (this module is not affiliated with Glooko, Inc.)

This project uses the following PowerShell modules for development, testing, and functionality:

• Pester by @nohwnd - Testing framework for PowerShell
• PSScriptAnalyzer by @PowerShell - Static code checker for PowerShell scripts and modules
• ImportExcel by @dfinke - PowerShell module to import/export Excel spreadsheets without Excel
• platyPS by @PowerShell - Markdown-based help file generation for PowerShell modules

The mock data in this repository includes:

• Synthetic data: Manually created realistic diabetes datasets
• Research data: Adapted from the iglu dataset (Broll et al., GPL-2 license) distributed via GlucoBench

For complete information about mock data sources, licenses, and attribution, see the Mock Data README.