The Scenario
Your product team's web analytics export landed in Excel. Five thousand rows. Column A is full of raw User-Agent strings — the kind that look like a paragraph of browser engine identifiers. Your product analyst needs a mobile-vs-desktop breakdown for the quarterly product review. The analytics platform doesn't parse User-Agents. You have the export and access to Neutrino. That's it.
The bad version:
- Attempt to write a regex formula in Excel to classify device type from the User-Agent string
- Spend 90 minutes tuning it, find it misclassifies iPad strings as mobile and certain bot agents as desktop
- Look for a batch User-Agent parsing service, find one that accepts CSV uploads capped at 1,000 rows
- Plan five upload batches, download five results files, merge them in a new sheet
You have 5,000 rows and the quarterly review is Thursday. The regex is not accurate enough. Five CSV batches is not how your afternoon is supposed to go.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. Through its built-in Neutrino integration, it parses every User-Agent string in column A and writes device type, browser name, and OS into the columns you specify — all 5,000 rows in one operation.
For each User-Agent string in column A, run Neutrino UA lookup and write device type in column B, browser name in column C, and OS name in column D.
What You Get
- Column B: device type (desktop, mobile, tablet, bot) for every row
- Column C: browser name
- Column D: operating system name
- All 5,000 rows processed in one pass — ready to pivot for the quarterly breakdown
What If the Data Is Not Quite Ready
You only need mobile vs. desktop — not the full breakdown
For each User-Agent string in column A, use Neutrino to parse it and write TRUE in column B if the device is mobile, FALSE if it is desktop or tablet. Write the browser name in column C.
Session ID and User-Agent are concatenated in the same cell
For each row in column A, extract only the User-Agent portion. Then run Neutrino UA lookup and write device type in column B, browser name in column C, and OS in column D.
You want bot traffic flagged separately before the analysis
Parse all User-Agent strings in column A with Neutrino. Write device type in column B, browser name in column C, OS in column D. Flag any row where the device type is bot with BOT in column E and highlight those rows gray.
Full analytics prep in one shot
Parse all 5,000 User-Agent strings in column A with Neutrino. Write device type in column B, browser name in column C, OS in column D. Flag bot rows with BOT in column E and highlight them gray. Add a summary table below the data showing the count and percentage breakdown by device type.
Try It
Get the 7-day free trial of SheetXAI and open your analytics workbook, then ask SheetXAI to parse every User-Agent string in column A with Neutrino and write device type and browser into the columns your product analyst needs for Thursday's quarterly review. See also the IP geolocation spoke if you have IP addresses in this export that also need country and city enrichment.