TilliT
HomepageChangelogDeveloper
  • Home
  • Introduction to TilliT
    • Introduction for New TilliT Customers
    • Videos
  • Getting Started
    • Overview
    • Definitions
    • Set up a Site & Assets
    • Set up an Activity
    • Create an Order
    • Start an Order
    • Next steps
  • Planning
    • Overview
    • Data Gathering
      • Site & Assets
      • Production Orders
      • Activities
      • Shifts & Calendars
      • Materials
      • Process Variables
      • Attributes
      • Articles
      • Checklist
  • Knowledge Base
    • Everyday Usage
      • Layout Overview
      • Login to TilliT
      • Basic functionality
      • Lock screen
      • Pinning Assets
      • Switch Site
      • Next Steps
      • Activities
        • Claiming
        • Completing
        • Manually starting
      • Orders
        • Create adhoc Order
      • Events
        • Raising an Event Using the UI
      • Notifications
    • Scheduler
      • Introduction
      • Feature Overview
      • Scheduler to Digital Operations integration
      • Scheduling
        • Scheduling
        • Orders
        • Scenarios
        • Inventory
      • Configuration
        • Operations
        • Equipment
        • Personnel
        • Materials
        • Availability
        • Optimisation
        • Changeovers
        • Loading data with excel Add-in
      • MVP Setup Guide
    • Insights
      • Activity report
      • Production Report
      • Dashboards
      • Advanced Analytics
        • Sharing dashboard
    • Users
      • User
        • User Confirmation
        • User channels
        • User subscriptions
      • Groups
      • Permissions
      • User authentication with SSO
    • Boards
    • Settings
      • Asset Hierarchy
        • Site
        • Asset
          • Asset Attributes
          • Asset Tolerances
          • Downtime periods
          • Attribute Group
          • Edge data tags
        • Asset class
        • Order Templates
          • Order Template with Unit Conversion
        • Calendar
          • Calendar item
        • Shifts Templates
          • Creating Shift Templates
          • Manual shift patterns
        • Asset Meter
      • Material Definition
        • Material
        • Material group
        • Material attributes
          • Example of material attributes
        • Material tolerance
          • Example of Material tolerance
        • Material component
        • Material conversion
      • Activity Templates
        • Activity template
          • Creating an activity
          • Where
          • When
          • Versioning
          • Building
          • Elements
            • Item types
              • Item properties
                • Active item & hidden expressions
                • Hint
                • Tolerance Source
              • Update Attribute
              • Board Item
              • Raise event
            • Data Types
              • Evaluate Data types & Dynamic Note
              • Note
              • Option list
              • Dynamic option list
              • Barcode
              • GS1 Barcode Scanner
              • Edge data
              • Material Component
              • Image capture
              • Sections
              • Digital Signature
              • Material
              • Dynamic Form Items
              • Inventory Key
        • Activity class
      • Events
        • Event Type
        • Event Relay
        • Event Schedule
      • Articles
      • Integrations
        • Adding Webhook Subscriptions
        • MQTT Integration
        • Receive the TilliT Event
        • Notifications
      • Configuration
        • Attribute
        • Attribute group
        • Tolerances
        • Dashboard group
        • Report Templates
          • Creating and Using Report Templates
        • Process variable
        • Unit of Measure
        • Run Rate Template
      • Translation
      • Audit Log
    • Edge
      • Introduction
      • Before You Start
        • Security / Firewall
        • TilliT Edge
        • Understanding your Networks
        • Common Installation Solutions
        • Managing and Publishing changes
      • Physical Device
        • Setup
      • Using Docker
        • Upgrading a docker container from before 2025
      • Common Data Sources
        • OPC-UA
        • Modbus TCP
        • Ethernet IP
        • Profinet
        • RTLE
        • Simulator
      • Data Tags
        • Data Tag Templates
        • Order Number Tag Template
        • Edge Data Tag Options
      • Edge Triggers
      • TilliT Sensors
        • Connect TilliT Edge to a Wireless Gateway
        • Bind a Wireless Counter to a Wireless Gateway
        • Configure FEN-20 PNP Sensor
      • Troubleshooting
      • Windows Edge Installer
    • History
    • OEE
      • Two Steps to Availability
      • Two Steps to Performance
      • A Step to Quality
    • Track and Trace
      • Before you begin
      • Transaction Types
      • Movement Types
      • Movement Types Field
      • Adding Material Movement to an Activity Template
      • Completing the Activity
      • Reporting
    • Mobile View
      • Device shortcut
      • Unable to enter Negative Numbers
    • Importing, Exporting and Cloning Entities
    • Troubleshooting
  • Tools
    • Excel add-in
      • How to Install the Excel Add-in
        • Excel Online
        • Desktop
      • How to Update the Excel Add-in
      • Loading multiple orders
      • Maintaining Master Data in Bulk
      • Downloading Time-Series Data
    • Staging Environment
    • Ignition Module
      • Installation
      • TilliT Tag Provider
        • Data From TilliT to Ignition
        • Data From Ignition To TilliT
      • Scripting Using the TilliT Module
      • Network Security
  • INFRASTRUCTURE
    • FAQ
    • Architecture
    • Disaster Recovery
    • Software Quality Assurance
Powered by GitBook
On this page
  • Overview
  • Accessing Timeseries Data
  1. Tools
  2. Excel add-in

Downloading Time-Series Data

PreviousMaintaining Master Data in BulkNextStaging Environment

Last updated 2 years ago

Overview

You can export all your timeseries data from TilliT to Excel using the add-in.

For time-series data to be stores in TilliT, you must first have configured Process Variables.

Once your Process Variables have been configured, and are capturing data, we can start pulling the data into Excel.

Accessing Timeseries Data

Depending on which environment you're accessing, click the TilliT DO Stage tab (Stage) or TilliT** ** tab (Production), then click the Timeseries button.

A menu will pop up on the right, asking to you to select an Asset from your config.

Next, select the Process Variable you wish to pull data from.

You have four (4) options for the Time selection.

  • Today - all data from the current day

  • Yesterday - all data from the previous day

  • Pick a date - all data from a specified single day

  • Pick a start and end time - all data from a specified single day during a specific time period (cannot be over 24 hours).

If you Pick a date, you will be presented with the Date selection dialogue box.

If you Pick a start and end time, you will be presented with the Date selection dialogue box.

After setting dates and times, or if you selected Today or Yesterday, you will be presented with the Load button.

Once you click Load, Excel will load the data into a new sheet, named after the Process Variable that was selected.