📥

Data Export to Excel

Professional reports ready to present

Overview

The export module generates Excel files (.xlsx) with professional formatting, ready to include in reports, presentations or further analysis.

📊

Multi-sheet Excel File

Instant generation with a single click • Professional format • Ready for presentations

Excel File Contents

The exported file contains multiple sheets organized logically:

Sheet 1: Executive Summary

The first sheet presents a high-level summary ideal for managers:

  • Study information: Name, dates, company, technician
  • Statistical parameters: Confidence level, error margin
  • Key metrics:
    • Total observations performed
    • % Productive / Non-productive / Delays
    • Required vs. completed observations
  • Conclusions: Summary of main findings

Sheet 2: Data by Task

Detailed table with the complete analysis per task:

Column Description
Station Work station name
Task Activity name
Category Productive / Non-productive / Delay
Observations Number of times observed
Percentage (%) % of total time
Hours/Day Estimated time per workday
Lower Interval Lower limit of confidence interval
Upper Interval Upper limit of confidence interval

Sheet 3: Raw Observations

Complete record of all observations performed:

  • ID: Unique identifier
  • Scheduled Date/Time: Scheduled moment
  • Registration Date/Time: Actual capture moment
  • Station: Observed station
  • Task: Registered activity
  • Category: Classification
  • Rating: Performance rating (if applicable)
  • Notes: Additional comments

Sheet 4: Summary by Station

Analysis grouped by each work station:

  • Total observations per station
  • % Productive per station
  • Top 3 most frequent tasks per station
  • Comparison between stations

Sheet 5: Methodology

Study documentation for reference:

  • Description of the Work Sampling technique
  • Parameters used
  • Statistical formulas applied
  • Category definitions
  • Study period

How to Export

Steps to export:

  1. 1
    Open the study

    From the dashboard or study list

  2. 2
    Go to the "Report" tab

    Or "Settings" depending on the version

  3. 3
    Click on "Export to Excel"

    Button with download icon

  4. ✓
    File downloaded

    Saves automatically to your downloads folder

File Format

File Name

The file is automatically named following the pattern:

Sampling_[StudyName]_[Date].xlsx

Example: Sampling_Production_Line_A_2025-01-15.xlsx

Visual Format

The file includes professional formatting:

  • Headers: Colored backgrounds, bold text
  • Borders: Tables with defined lines
  • Column widths: Auto-adjusted
  • Number format: Percentages with decimals, localized dates
  • Category colors: Green/Red/Yellow for quick identification

Other Export Formats

JSON Export

For technical integrations or backup, you can also export in JSON format:

  • Complete data structure
  • Ideal for importing into other tools
  • Technical backup of the study

Configuration Export

You can export only the configuration (stations and tasks) without the observation data. Useful for:

  • Replicating the structure in a new study
  • Sharing templates with colleagues
  • Documenting the methodology

💡 Pro tip

Export and save the Excel file at the end of each study. It is your permanent backup and the basis for presentations, although data is also safe in the cloud.

Compatibility

The generated Excel files are compatible with:

  • Microsoft Excel 2010 and later
  • Google Sheets
  • LibreOffice Calc
  • Numbers (macOS)
  • Any .xlsx format reader