The Scenario
You are a product marketer. Your team just completed a competitive analysis sprint and the output is an Excel workbook: 15 competitors, each with company name, website, estimated revenue, and bullet-point strengths and weaknesses.
Your VP wants all 15 in Fireberry's competitor tracker before the product strategy meeting on Thursday. The tracker is where sales reps look up SWOT data when they are in a live deal with a competitor in the room. Right now it is empty.
The slow version of Tuesday:
- You log into Fireberry and navigate to the competitor tracker
- You create the first record: copy the company name, type the website, paste the revenue, copy-paste strengths, copy-paste weaknesses
- The bullet-point formatting from Excel does not paste cleanly into Fireberry's rich text field
- You manually strip the bullets for each entry
- After four records you check the time
- It is 3:45 PM and you have four of fifteen done. Thursday is two days away.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that creates the Fireberry competitor records row by row, handling field mapping and text cleanup inline.
Open the SheetXAI sidebar and type:
For every row in this workbook, create a Fireberry competitor record using company name in column A, website in column B, estimated revenue in column C, and strengths from column D. Clean up any bullet-point formatting in the strengths column before writing to Fireberry so it reads as plain prose. Write the returned competitor GUID into column E for each row.
SheetXAI creates all 15 records, strips the bullet formatting, and logs each GUID into column E.
What You Get
A populated Fireberry competitor tracker:
- 15 competitor records created — one per row, with website, revenue, and strengths
- Column E filled — the Fireberry GUID for each competitor
- Strengths as clean prose — no bullet-point artifacts from the Excel workbook
Sales reps can now look up competitor profiles during live deals without asking you for the spreadsheet.
What If the Data Is Not Quite Ready
Competitive intelligence workbooks built in a sprint have common rough edges.
When weaknesses are in a separate column that needs to be included
Column D has strengths, column E has weaknesses.
For every row, create a Fireberry competitor record. Map company name from column A, website from column B, estimated revenue from column C, strengths from column D, and weaknesses from column E. Clean up bullet formatting in both fields. Write GUIDs into column F.
When revenue estimates are in inconsistent formats
Some rows say "$50M," some say "50 million," some say "unknown."
Before creating the records, normalize the revenue estimates in column C: convert all values to a consistent format like "$50M." For cells that say "unknown" or are blank, write "Revenue unknown." Then create the records and write GUIDs into column E.
When some competitors are already in Fireberry and you only want to add the new ones
You ran a partial import last month and do not want duplicates.
For each row, check if a Fireberry competitor record already exists with the same company name. If it already exists, write "Already exists" into column E. If it does not exist, create the record and write the new GUID into column E.
When you want the full batch creation plus a summary for the VP
Create a Fireberry competitor record for each row, mapping all fields and cleaning up bullet formatting. Write GUIDs into column F. After all rows, check which company names already existed in Fireberry before the run. Write a summary to a new 'Import Summary' tab: total new records created, any rows skipped because they already existed, and any rows where creation failed.
The pattern: the workbook is the source of truth for competitive intelligence. One prompt turns it into a live CRM dataset.
Try It
Get the 7-day free trial of SheetXAI and point it at your competitive analysis workbook, then ask it to push every row into Fireberry's competitor tracker. The Fireberry integration is included in every plan. For related workflows, see how to bulk-import opportunities from an Excel workbook or the Fireberry in Excel overview.