📝

Data Wrapped Generator

Turn any dataset into a fun, shareable "Wrapped" summary like Spotify Wrapped. Works with CSVs, spreadsheets, JSON, email exports, bank statements, watch history, order history, chat logs, calendar data, and more.

Creator

J
jamie

Categories

datavisualizationwrappedanalysisfun

title: Data Wrapped Generator description: | Turn any dataset into a fun, shareable "Wrapped" summary like Spotify Wrapped. Works with CSVs, spreadsheets, JSON, email exports, bank statements, watch history, order history, chat logs, calendar data, and more. tags:

  • data
  • visualization
  • wrapped
  • analysis
  • fun tool: true

Data Wrapped Generator

Transform any dataset into a personalized "Wrapped" experience with quirky stats, oddly specific insights, and shareable moments.

What You Need

The user should provide ONE of these:

  • A file path to their data (CSV, XLSX, JSON, etc.)
  • A connected app to pull data from (Gmail, Google Calendar, Spotify, etc.)
  • Raw data pasted in the chat

Available Connected Apps

If the user doesn't specify, ask which they'd like to use:

AppWhat You Can Wrap
GmailEmail habits, top contacts, response times, thread lengths, busiest inbox days
Google CalendarMeeting hours, event types, busiest days, recurring commitments, free time gaps
SpotifyTop artists, listening hours, genre breakdown, discovery rate, mood patterns
Google DriveFile creation patterns, collaboration stats, storage usage, doc types
NotionPage activity, workspace habits, most edited docs, creation streaks

Common File Types

File TypeExamples
Food deliveryDoordash, UberEats, Grubhub CSV exports
BankingCredit card statements, bank transaction exports
Watch historyNetflix, YouTube, streaming service exports
Health/FitnessApple Health, Fitbit, Strava exports
ShoppingAmazon order history, retail purchase exports
Social mediaTwitter/X archive, Instagram data export
CodeGitHub contribution data, commit logs

If User Doesn't Provide Data

Ask them:

what data would you like wrapped? (・ω・) **connected apps:** - gmail - email habits - google calendar - meeting stats - spotify - listening wrapped - google drive - file patterns - notion - workspace activity **or give me a file:** - csv, xlsx, json from your workspace - order history export - bank statement - watch history - any data export you have

Your Task

1. Analyze the Data

First, understand what kind of data you're working with:

  • Time-based: dates, timestamps, durations
  • Categorical: types, categories, names, labels
  • Quantitative: amounts, counts, prices, scores
  • Text: messages, titles, descriptions

2. Extract Wrapped-Style Insights

Generate these types of stats (adapt based on data type):

The Big Numbers
  • Total count of [thing] this year/period
  • Hours/minutes/days spent on [activity]
  • Money spent on [category]
  • Messages sent/received
Top Lists
  • Top 5 most [frequent/expensive/longest/etc.]
  • Your #1 [thing] of the year
  • Categories ranked by [metric]
Oddly Specific Stats

These make it feel personal and shareable:

  • "You ordered pad thai 23 times. That's mass every 16 days."
  • "Your most active hour was 2am. Night owl much?"
  • "You mass 47 times in December alone. Holiday spirit?"
  • "Your longest [session/streak/gap] was [X days/hours]"
  • "If your mass were [comparison], it would [funny analogy]"
Personality Insights

Based on patterns, assign fun labels:

  • "Your ordering personality: The Creature of Habit (same 3 restaurants)"
  • "Your email style: The Novel Writer (avg 847 words per email)"
  • "Your calendar vibe: Meeting Survivor (127 hours in meetings)"
Time Patterns
  • Most active day of week
  • Most active time of day
  • Busiest month
  • Longest streak / biggest gap
Comparisons & Context
  • "That's mass than mass% of users" (if you have benchmarks)
  • "Equivalent to mass [relatable comparison]"
  • "You could have mass with that time/money"
The Unexpected
  • Find the weird outliers
  • Spot unusual patterns
  • Surface forgotten moments ("Remember that mass at 3am in March?")

3. Create the Output

Generate a markdown file with the wrapped summary:

# [Name]'s [Category] Wrapped [Year/Period] ## The Big Picture [Hero stat with large number] ## Your Top 5 [Things] 1. **[#1]** - [stat] 2. **[#2]** - [stat] ... ## Oddly Specific Stats About You - [quirky stat 1] - [quirky stat 2] - [quirky stat 3] ## Your [Category] Personality **[Fun Label]**: [Description of their pattern/style] ## Time Patterns - Peak day: [day] - Peak hour: [time] - Busiest month: [month] ## The Moment That Defined Your Year [Highlight a specific memorable data point] ## Your [Year] in Numbers | Stat | Value | |------|-------| | Total [X] | [N] | | Average [Y] | [N] | | Days with [Z] | [N] | --- *Generated with zo.computer (^_^)*

4. Optional: Generate Visuals

If requested, create shareable graphics:

  • Use the generate_image tool for stylized stat cards
  • Create ASCII art versions for terminal aesthetic
  • Generate a simple chart/visualization

Examples of Data Types This Works With

Data SourceExample Insights
Food deliveryTop restaurants, cuisine breakdown, late night orders
Bank/Credit cardSpending categories, merchant frequency, splurge days
EmailResponse time, busiest contacts, email length trends
CalendarMeeting hours, busiest days, recurring events
Watch historyGenres, binge sessions, rewatch count
MusicTop artists, listening hours, genre evolution
Chat logsMost active convos, emoji usage, response patterns
Exercise/HealthWorkout types, streaks, peak performance times
ReadingBooks/articles read, genres, reading speed
ShoppingCategories, brands, seasonal patterns
TravelDestinations, miles traveled, booking patterns
Social mediaPost frequency, engagement patterns, topic trends
Code commitsLanguages, repos, commit times, streak days

Tone Guidelines

  • Fun and celebratory, not judgmental
  • Use "you" language to make it personal
  • Include at least 3 "oddly specific" stats that feel like "wow, that's so me"
  • Add humor where appropriate
  • Keep comparisons relatable (not "mass giant planets" but "mass to Tokyo and back")
  • End on a positive/fun note

Output Location

Save the wrapped summary to: [name]-[category]-wrapped-[date]


tip: try "analyze my mass and make it wrapped" (・ω・)