The Scenario
IT planning season is next month and your manager has asked for a review of the service catalog before the budget meeting. You need a complete inventory of every catalog item in Freshservice — name, display ID, category, and description — so the team can identify gaps, consolidate duplicates, and propose additions. You've never actually seen a full list. You know there are at least 45 items because someone mentioned it in a Slack thread, but the catalog UI shows twelve per page and there's no obvious way to export it.
The bad version:
- Go to the Freshservice service catalog, open page 1, manually copy item names and IDs into an Excel workbook. Navigate to page 2. Repeat.
- Hit page 4 and realize the category column in your workbook has been inconsistently formatted because you've been typing "Hardware" sometimes and "hardware" other times.
- Finish all 45 items, send the workbook to your manager, and get a reply asking why item 23 has no description — you missed the column because you were copying manually and it wasn't visible without scrolling right.
Forty-five items across multiple pages. Copied by hand. Into a workbook you're going to use for budget planning.
This is the kind of task that gets done wrong once and then silently becomes the source of truth for the next three quarters.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Freshservice and fetches the entire catalog in one pull — all pages, all items, every field you ask for.
Try this yourself — free for 7 days
SheetXAI installs in your Excel workbook in about a minute. Paste the prompt below and watch it run.
Open the SheetXAI sidebar in a blank Excel workbook and paste this prompt:
Fetch all items from the Freshservice service catalog and write their names, display IDs, categories, and descriptions into columns A, B, C, and D.
What You Get
- Every service catalog item in Freshservice written into columns A–D in a single operation.
- Item names, display IDs, categories, and descriptions all in consistent, structured format — no pagination, no manual copying.
- A workbook that's immediately useful as a planning document, filterable by category, sortable by name or ID.
- Any items with missing descriptions or blank categories visible at a glance because the structure makes gaps obvious.
What If the Data Is Not Quite Ready
You only want items in a specific category
List all Freshservice service catalog items in the "Hardware" category and write item name, display ID, and description into columns A, B, and C.
You want to flag items with missing descriptions
List all Freshservice service catalog items and write name, display ID, category, and description into columns A through D. In column E, write 'MISSING DESCRIPTION' for any item where column D is blank, and leave column E empty for the rest.
You want to compare the catalog against a list of expected items from another worksheet
List all Freshservice service catalog items and write name and display ID into columns A and B. Then compare column A against the list of expected catalog items in the "Expected" worksheet, column A. Write 'PRESENT' or 'MISSING FROM CATALOG' into column C for each expected item.
Full catalog audit for the planning meeting in one shot
Fetch all Freshservice service catalog items and write name, display ID, category, and description into columns A through D. Sort by category (column C) then alphabetically by name (column A). Flag rows with blank descriptions in column E with 'NO DESCRIPTION.' Then in a new worksheet called "Category Summary," write each unique category and the count of items in that category.
One pull — every item, sorted, flagged, and summarized — ready for the planning document.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before your next IT planning cycle, then ask it to pull the complete Freshservice service catalog for review. When you're done, check out how to look up ticket details by ID or return to the Freshservice hub.