The Scenario
You are an SEO analyst at a retail brand. Three months before a major product launch, you compiled 300 synonym pairs in an Excel workbook: brand-specific terms, product nicknames, common misspellings. Column A is the canonical term, column B is the alternate.
Algolia needs all of them in the products_en index before launch day. Release date: next Tuesday.
The bad version of Monday:
- You read the Algolia synonyms API documentation for an hour
- You write a Python script to loop through the rows and post each synonym
- The script works locally but times out when you run it against the production index
- You batch it into chunks of 50 and run it again
- The second batch duplicates 20 synonyms from the first batch
- Algolia deduplicates them automatically but you spend 30 minutes verifying the count
- Launch day arrives and you are not certain all 300 landed correctly
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the synonym pairs and batch-uploads them to Algolia, with no scripting required.
Open the SheetXAI sidebar and type:
Read all rows in the Synonyms tab where column A is the main term and column B is the alternate. Batch-upload them as one-way synonyms to my Algolia index 'products_en'. Report how many synonyms were successfully loaded.
SheetXAI reads every row in the Synonyms tab, constructs the synonym objects in the correct Algolia format, and sends them as a batch. It reports the count so you can verify all 300 landed.
What You Get
A fully loaded synonym set:
- 300 synonym pairs uploaded — no manual API calls, no chunking
- One-way synonym format — alternates map to the canonical term
- Completion count — reported back so you can confirm 300 of 300
- Launch-ready — customers using nicknames or misspellings find the right product
What If the Data Is Not Quite Ready
Synonym workbooks built over months accumulate inconsistencies. SheetXAI handles cleanup and upload in the same prompt.
When there are duplicate pairs in the workbook
You added rows over several weeks and some terms appear twice with slightly different capitalization.
Deduplicate the Synonyms tab by the term in column A, keeping the first occurrence. Then batch-upload the cleaned list as one-way synonyms to my Algolia index 'products_en' and report the final count.
When some rows should be two-way synonyms
Terms like "sneaker" and "trainer" are true equivalents and should work bidirectionally. You have flagged these with "two-way" in column C.
Read the Synonyms tab. For rows where column C says "two-way," upload as two-way Algolia synonyms. For all other rows, upload as one-way synonyms. Use column A as the canonical term and column B as the alternate. Target index: 'products_en'.
When you want to replace the entire synonym list, not append
The index already has last season's synonyms. You want a clean slate before loading the new list.
Clear all existing synonyms in my Algolia index 'products_en' then re-import every synonym pair from the Synonyms tab of this workbook. Column A is the main term, column B is the alternate. Upload as one-way synonyms and report the count on completion.
When the synonym pairs span two market tabs
The US tab has English synonyms, the UK tab has UK English variants. Both need to load into the same index.
Combine all rows from the US Synonyms tab and the UK Synonyms tab. Add a tag field to each synonym record indicating which market it came from. Then batch-upload the combined list to my Algolia index 'products_en' and report the total count by market.
The pattern: the workbook is the source of truth. SheetXAI handles the format conversion and the API call, so the distance between "workbook is ready" and "Algolia is updated" is one sentence.
Try It
Get the 7-day free trial of SheetXAI and open your synonym workbook, then ask it to batch-upload to Algolia. The Algolia integration is included in every SheetXAI plan. For related workflows, see how to export and audit your Algolia rules in Excel or the Algolia in Excel overview.