The Scenario
You are a technical SEO consultant. You ran an on-page crawl for a 500-page e-commerce site and the crawl task is complete in DataForSEO.
Now you need to extract all duplicate title tags and duplicate meta descriptions into an Excel workbook so you can prioritize fixes for the client. The report is due Monday morning.
It is Friday at 3 PM.
The bad version:
- You pull the raw crawl results from DataForSEO via the API
- The response is a nested JSON you need to parse
- You write a Python script, run it, and the output CSV has 12 columns you do not need
- You open the CSV in Excel and delete the unwanted columns
- The client calls and asks for it in a specific workbook template you now have to re-paste everything into
- You email Monday's report at 11 PM Sunday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your DataForSEO crawl task ID, fetches the duplicate tag findings, and writes them into a structured tab — no JSON parsing, no Python script.
Open the SheetXAI sidebar and type:
Fetch duplicate title tags and duplicate meta descriptions from my DataForSEO on-page task ID and write each duplicate group — URLs sharing the same tag — into the TechnicalAudit tab with columns for Page URL, Issue Type, and Duplicate URLs.
SheetXAI calls the DataForSEO on-page summary endpoint with your task ID, extracts all duplicate groups, and writes them into the TechnicalAudit tab in a readable format.
What You Get
A TechnicalAudit tab with one row per duplicate group:
- Issue Type — duplicate_title or duplicate_description
- Shared Tag Text — the exact title or description that is duplicated
- Duplicate URLs — the pages sharing that tag
- Count — how many pages share this tag
Every duplicate group surfaced. Sort by count to fix the worst offenders first, or filter by issue type to tackle all duplicate titles before moving to descriptions.
What If the Data Is Not Quite Ready
Technical SEO clients have specific formatting requirements. SheetXAI handles them in one prompt.
When you want to exclude pagination URLs from the duplicate analysis
The site has /page/2, /page/3 URLs that share titles intentionally and should be excluded.
Fetch duplicate title tags and meta descriptions from my DataForSEO crawl task. Exclude any URLs containing "/page/" from the duplicate groups. Write the remaining groups into the TechnicalAudit tab.
When you need one row per URL instead of one row per group
The client's team filters at the row level and cannot work with multi-URL cells.
Fetch duplicate title and meta description groups from my DataForSEO crawl task. Write one row per URL in each duplicate group, repeating the Issue Type and Shared Tag Text columns on each row. Write into TechnicalAudit.
When you need to prioritize by traffic impact
The client has a Traffic tab with page-level traffic data and wants highest-traffic duplicates addressed first.
Fetch duplicate title and meta description groups from my DataForSEO crawl task. For each page in each duplicate group, look up its organic traffic from the Traffic tab. Sort results by the maximum traffic of any page in the group, highest first. Write into TechnicalAudit.
When you need the full audit export plus a prioritization brief
The client does not read spreadsheets without context. You need the data and a written brief.
Fetch all duplicate title tags and duplicate meta descriptions from my DataForSEO crawl task. Write each duplicate group into TechnicalAudit. Then create a Recommendations tab and write a short paragraph identifying the top three duplicate groups to fix first, based on number of affected pages, with a one-sentence rationale for each.
The pattern: the data extraction and the written brief happen in one prompt — you send the client the full package, not a raw workbook.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you want to capture on-page audit findings, then ask it to pull DataForSEO crawl results. The DataForSEO integration is included in every SheetXAI plan. For related workflows, see how to run a bulk on-page audit into Excel or the DataForSEO in Excel overview.