The Scenario
You're a product manager and your quarterly competitive review is in two hours. You ran ScrapeGraph AI SmartScraper last week and the results landed in your Excel workbook: 10 competitors across columns A through D — name, plan name, monthly price, key features. Four tidy columns, 10 rows of data.
Now your VP wants a Markdown table she can paste directly into the review doc. She's done asking for slide decks. She wants the data in a format she can copy into Notion.
The bad version:
- Manually write the Markdown table header row: competitor name, plan, price, features
- Add the pipe characters and dashes for the alignment row
- Type each of the 10 data rows, making sure the pipes align, escaping any pipe characters inside the feature list cells that would break the table
- Get to row 6 and find a feature description that has a vertical bar in it and realize Markdown tables don't handle that without escaping
Your VP has used "can you just format it as a table" as a sentence before. She is not asking about the formatting process.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the scraped competitor data from your columns and uses its built-in ScrapeGraph AI integration to generate a single clean Markdown comparison table from the workbook data.
Paste this into the SheetXAI sidebar:
Take the scraped pricing data in columns A through D of my workbook (10 competitors, 4 columns: name, plan, price, features) and generate one clean Markdown comparison table I can paste into a document
What You Get
- A single, properly formatted Markdown table with four columns: Competitor, Plan Name, Monthly Price, Key Features
- One row per competitor, with feature lists formatted as comma-separated values inside each cell
- Pipe characters inside feature descriptions are escaped automatically
- The generated Markdown is written to a dedicated cell so you can copy it without touching the source data
What If the Data Is Not Quite Ready
Price values are mixed — some are monthly, some annual, some show "contact us"
Before generating the Markdown table, normalize the price values in column C: convert annual prices to a monthly equivalent, write "custom pricing" for rows that say "contact us" or "request a demo", then generate the table
Some competitors have multiple plans and should appear as multiple rows
Expand rows where column B contains multiple plan names separated by semicolons into separate rows, then generate the Markdown table with one row per plan
You want the table sorted by price ascending before generating
Sort the data by monthly price in column C ascending (treating "custom pricing" as highest), then generate the Markdown comparison table
Full pipeline: normalize, sort, expand multi-plan rows, and generate
For the 10-competitor dataset in columns A through D: normalize prices to monthly numeric values; expand any rows with multiple plans into separate rows; sort by monthly price ascending; generate a clean Markdown table with columns Competitor, Plan Name, Monthly Price, Key Features; write the Markdown output to cell A15
Two hours from now your VP has a table she can paste directly into the review doc.
Try It
If you have scraped competitor data sitting in workbook columns and need it formatted for a doc or presentation, Get the 7-day free trial of SheetXAI and generate the Markdown table in one prompt. For related workflows, see how to bulk scrape competitor pricing or dedup and normalize scraped output.