expanso-normalize-timestamps

Normalize diverse timestamp formats and timezones to UTC with Expanso.

1|Updated Feb 1, 2026
One-click install
npx skills add https://github.com/expanso-io/expanso-skills --skill expanso-normalize-timestamps
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: expanso-normalize-timestamps
Source: https://github.com/expanso-io/expanso-skills/tree/main/skills/recipes/normalize-timestamps
Command: npx skills add https://github.com/expanso-io/expanso-skills --skill expanso-normalize-timestamps

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the challenge of inconsistent timestamp formats and timezones in data by normalizing them all to a standard UTC format.

Core Features & Use Cases

  • Format Detection: Automatically identifies various timestamp formats (ISO 8601, Unix epoch, custom).
  • Timezone Conversion: Converts detected timestamps to Coordinated Universal Time (UTC).
  • Metadata Enrichment: Adds useful time-based metadata like year, month, day, hour, day of week, and quarter.
  • Quality Scoring: Provides a score indicating the success of parsing and conversion.
  • Use Case: Ingesting event data from multiple sources with different timestamp conventions and ensuring all events are logged and analyzed with a consistent, comparable UTC timestamp.

Quick Start

Run the normalize-timestamps skill pipeline using the provided pipeline.yaml configuration.

Frequently Asked Questions about expanso-normalize-timestamps

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I normalize timestamps to UTC when ingesting event data from multiple sources?

To normalize timestamps to UTC, this Skill automatically detects diverse formats from multiple sources and standardizes them to Coordinated Universal Time. It handles ISO 8601, Unix epoch, and custom formats, ensuring all ingested event data is logged with a consistent, comparable UTC timestamp for accurate analysis.

What timestamp formats can I convert to a standardized UTC format using a data pipeline?

You can convert ISO 8601, Unix epoch, and custom timestamp formats to a standardized UTC format. The data pipeline automatically identifies these diverse timestamp conventions and converts them, enriching the resulting data with time-based metadata like year, month, day, hour, and quarter.

How do I add time-based metadata like year and quarter during timezone conversion?

To add time-based metadata during timezone conversion, the normalization process enriches your data by extracting year, month, day, hour, day of week, and quarter. This happens automatically as diverse timestamp formats are converted to a standardized UTC format.

How do I check the quality score of parsing and conversion for Unix epoch timestamps?

To check the quality score of parsing and conversion for Unix epoch timestamps, the Skill provides a specific score indicating the success of the operation. This quality scoring mechanism evaluates how effectively the detected timestamps are parsed and converted to the standardized UTC format.

Can I use Expanso to handle custom timestamp formats without additional dependencies?

Yes, you can use Expanso to handle custom timestamp formats without additional dependencies. The Skill operates with an empty dependencies list, automatically detecting and normalizing diverse timestamp formats to UTC using the provided pipeline configuration.