The Scenario
Your CTO asked for a quarterly technology audit. The output she wants: a clean table showing every programming language the engineering team touched in Q1, total hours coded, and percentage of total coding time — sorted descending. She wants it in the shared Excel workbook, not a screenshot from a dashboard.
You manage developer tooling and you have access to the team's WakaTime account. This should be a pull, not a manually assembled pivot table. The last time you built one of these by hand you spent three hours counting rows in a CSV export before realizing you had double-counted TypeScript because WakaTime reported it separately from TSX.
The bad version:
- You export the WakaTime language stats CSV for Q1, open it in Excel, and try to pivot by language summing hours across all users.
- The pivot includes languages like "Other" and "Plain Text" that inflate the percentages — you manually delete those rows and re-run the percentage formula.
- You realize the date range exported includes January 1 through March 30, not March 31, because you forgot WakaTime's date filter is exclusive on the end date.
The CTO's presentation is Monday. This is Friday afternoon.
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 language-level stats directly — no CSV pivot, no manual percentage recalculation.
Open your shared audit workbook and paste this:
Pull WakaTime language breakdown for the date range in A1:A2, fill this Excel table with Language, Hours, Share% and add a totals row at the bottom
What You Get
- One row per language, sorted from most to least hours.
- Hours as a decimal, Share% as a number (e.g., 34.2 for 34.2%).
- A totals row at the bottom summing hours and confirming the percentages add to 100.
- All languages WakaTime detected — you can filter out noise with a standard workbook filter.
What If the Data Is Not Quite Ready
You want to exclude noise languages
"Plain Text," "Other," and "Markdown" inflate the percentages without representing engineering work:
Fetch WakaTime user stats for Q1. Exclude any language whose name is Plain Text, Other, Markdown, or Git Config. Fill this workbook with Language, Total Hours, Percentage of Total — sorted descending by hours. Add a totals row.
You need to include only languages above a minimum threshold
The CTO only wants languages that account for at least 1% of total coding time:
Fetch WakaTime user stats for Q1. Only include languages where Share% is at least 1. Fill this workbook with Language, Total Hours, Share% — sorted descending. Add a totals row at the bottom.
You want a rank column for the slide deck
The quarterly deck uses a ranked table format:
Fetch WakaTime language breakdown for the date range in A1:A2. Add a Rank column starting at 1 for the highest-hours language. Fill this workbook starting at row 3 with Rank, Language, Total Hours, Share% — sorted descending. Add a totals row.
Filtered, ranked, and ready for the slide deck in one go
Fetch WakaTime user stats for Q1. Exclude Plain Text, Other, Markdown, and Git Config. Only include languages where total hours exceed 5. Sort descending by hours. Add a Rank column (1 for highest). Add a totals row at the bottom. Fill this workbook starting at row 3 with Rank, Language, Total Hours, Share%.
The output drops directly into the deck with no reformatting needed.
Try It
Get the 7-day free trial of SheetXAI and open the technology audit workbook you build each quarter — ask it to pull Q1 language stats from WakaTime, ranked and filtered, and skip the CSV pivot entirely. See also how to analyze developer productivity patterns from WakaTime in Excel, or return to the WakaTime integration overview.