The Scenario
You are building a portfolio site. You want a data-driven stats section: total lifetime hours coded, top five languages all-time, top five projects all-time. The kind of numbers that belong on a developer page the way follower counts belong on a social profile.
You have a WakaTime account that has been running for three years. You know the data exists — you have seen it on the WakaTime dashboard. Getting it into a structured Excel workbook so you can wire it to a dashboard template is another matter.
You spent 20 minutes last week trying to export the "all-time" stats from WakaTime. There is no export button for lifetime totals. There is a dashboard. There is a share page. Neither of those is a workbook.
The bad version:
- You navigate to your WakaTime profile page, read the lifetime hours number off the screen, and type it into cell B1 by hand.
- You switch to the languages section, read the top five languages and their hours, type those in too.
- You realize WakaTime only shows the top five by default on the dashboard. You do not know if there are more languages below the fold that belong in the table.
Now you have a workbook full of numbers you typed manually from a webpage, with no record of when you pulled them. When the portfolio site launches, you will have to update these by hand again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you are looking at, and through its built-in WakaTime integration it pulls lifetime stats directly — no manual reading from dashboards, no typed-in numbers.
Open a new workbook and paste this:
Get my WakaTime all-time-since-today stat and full user stats, then populate this Excel sheet with a summary table: Metric, Value — covering total hours, daily average, best day, top language, top project
What You Get
- A clean two-column summary table: Metric in column A, Value in column B.
- Rows covering total lifetime hours, daily average, best day coding total, top language all-time, and top project all-time.
- Data pulled live from WakaTime — not a cached dashboard view.
- Formatted consistently so the table feeds directly into a dashboard component.
What If the Data Is Not Quite Ready
You want a positional layout instead of a summary table
Your portfolio template expects specific cells, not a table:
Fetch my WakaTime all-time totals and user stats, then fill this workbook: row 1 total lifetime hours, rows 3 onward top languages with hours, rows 10 onward top projects with hours.
You want more than the default top-five languages
WakaTime tracks far more languages than the five shown on the dashboard:
Fetch my WakaTime user stats all-time. List all languages in this workbook with Language in column A and Lifetime Hours in column B — sorted descending by hours. Include every language regardless of rank.
You want a snapshot date recorded alongside the data
Your portfolio site will show "as of [date]" next to the stats:
Fetch my WakaTime all-time totals and user stats. Fill this workbook with a summary table: Metric, Value, Snapshot Date — where Snapshot Date is today's date for every row. Include total hours, daily average, best day, top 5 languages, top 5 projects.
Full portfolio data pull with snapshot and rank in one pass
Fetch my WakaTime all-time user stats. Build a table with columns: Section, Rank, Name, Hours, Snapshot Date. Rows 1 through 5: Section = Languages, ranked 1-5. Rows 7 through 11: Section = Projects, ranked 1-5. Row 13: Section = Summary, Name = Total Lifetime Hours, Hours = the all-time total. Use today's date as Snapshot Date throughout.
One prompt produces a structured table your portfolio template can read directly.
Try It
Get the 7-day free trial of SheetXAI and open a new Excel workbook for your developer portfolio stats — ask it to pull your WakaTime all-time totals, top languages, and top projects into a structured table, and update it whenever you want a fresh snapshot. See also how to export a language breakdown from WakaTime in Excel, or return to the WakaTime integration overview.