Standardize messy countries and revenues
Bulk data processingEasyWhole-set scoringLatest run
Passed by all 12 products on their best model.
Prompt
Standardize two messy columns into clean ones.
country_raw(column F) uses abbreviations and variants;annual_revenue_raw(column E) mixes formats like$3.4M,3,400,000, and3400000. Add two new columns: -country_cleanin column J: the full country name (United States, United Kingdom, Germany, France, Brazil, Japan). -annual_revenue_usdin column K: the revenue as a plain number of US dollars.
Sheet1
Starting sheet · rows 1–21 of 1,001| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Aster Analytics is evaluating Analytics Cloud fo… | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Atlas Analytics is evaluating Forecasting Pro for a … |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Aurora Analytics is evaluating Research Workspace for … |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Beacon Analytics is evaluating Workflow Suite for a team o… |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Bluebird Analytics is evaluating Security Hub for a team of 71… |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Cedar Analytics is evaluating Support Desk for a… |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Cirrus Analytics is evaluating Data Connector for a … |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Cobalt Analytics is evaluating Billing Automation for … |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Delta Analytics is evaluating Analytics Cloud for a team o… |
| 11 | Ember Analytics | emberanalytics.com | Logistics | 900 | $33.8M | Japan | Leila Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Ember Analytics is evaluating Forecasting Pro for a team of 15… |
| 12 | Evergreen Analytics | evergreenanalytics.com | manufacturing | 60 | 37,500,000 | Germany | Priya Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Evergreen Analytics is evaluating Research Works… |
| 13 | Fjord Analytics | fjordanalytics.com | saas | 6000 | 41200000 | USA | Andrei Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Fjord Analytics is evaluating Workflow Suite for a t… |
| 14 | Harbor Analytics | harboranalytics.com | Software | 320 | $44.9M | United States | Haruto Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Harbor Analytics is evaluating Security Hub for a team… |
| 15 | Helio Analytics | helioanalytics.com | SaaS | 25 | 48,600,000 | Germany | Mina Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Helio Analytics is evaluating Support Desk for a team of 2… |
| 16 | Juniper Analytics | juniperanalytics.com | retail | 2500 | 52300000 | Germany | Sofia Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Juniper Analytics is evaluating Data Connector for a team of 2… |
| 17 | Keystone Analytics | keystoneanalytics.com | saas | 140 | $56M | United States | Diego Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Keystone Analytics is evaluating Billing Automat… |
| 18 | Lattice Analytics | latticeanalytics.com | Fintech | 8 | 59,700,000 | FR | Kai Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Lattice Analytics is evaluating Analytics Cloud for … |
| 19 | Lumina Analytics | luminaanalytics.com | Manufacturing | 2500 | 63400000 | GER | Pavel Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Lumina Analytics is evaluating Forecasting Pro for a t… |
| 20 | Meridian Analytics | meridiananalytics.com | 140 | $67.1M | Brazil | Amina Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Meridian Analytics is evaluating Research Workspace for a … | |
| 21 | Nimbus Analytics | nimbusanalytics.com | retail | 8 | 70,800,000 | United States | Hanna Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Nimbus Analytics is evaluating Data Connector for a team of 28… |
Sheet2
Starting sheet · rows 1–21 of 41| A | |
|---|---|
| 1 | BR |
| 2 | BRA |
| 3 | Brasil |
| 4 | Brazil |
| 5 | Brzil |
| 6 | Brzl |
| 7 | BZ |
| 8 | DE |
| 9 | Deutschland |
| 10 | Deutscland |
| 11 | Fance |
| 12 | Farnce |
| 13 | FR |
| 14 | France |
| 15 | Frnace |
| 16 | G.B. |
| 17 | GB |
| 18 | GER |
| 19 | Geramny |
| 20 | Germany |
| 21 | Germnay |
A passing output
Autosheet in Excel · Opus 5.5| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.Sheet1!J2:J1001: filled with text, matching the expected answersSheet1!K2:K1001: filled, matching the expected answers
Passed 21
Autosheet in Excel Opus 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
Autosheet in Excel GPT-6 Astra · Low
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | AMBIGUOUS:DEU | 30100000 |
10 of 1,001 rows
Autosheet in Sheets Opus 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Autosheet in Excel Sonnet 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Claude in Excel Opus 5.5 · High
J2=XLOOKUP(TRIM(F2),Country_Map!$A$2:$A$48,Country_Map!$B$2:$B$48,"Unmapped")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
Autosheet in Excel Haiku 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Claude in Sheets Opus 5.5 · Medium
J2=IFERROR(VLOOKUP(TRIM(F2),'Country Map'!$A$2:$B1001,2,FALSE),"UNMAPPED")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Claude Code + Sheets MCP Opus 5.5 · Medium
J2=IFERROR(__xludf.DUMMYFUNCTION("ARRAYFORMULA(IF(F2:F1001="""","""",IFERROR(VLOOKUP(REGEXREPLACE(LOWER(F2:F1001),""[^a-zà-ÿ]"",""""),{""us"",""United States"";""usa"",""United States"";""unitedstates"",""United States"";""unitedstatesofamerica"",""United States"";""unitedstatesamerica"","&"""United States"";""unitedstateofamerica"",""United States"";""uintedstates"",""United States"";""uk"",""United Kingdom"";""gb"",""United Kingdom"";""unitedkingdom"",""United Kingdom"";""uintedkingdom"",""United Kingdom"";""unitedkigndom"",""United Kingdo"&"m"";""de"",""Germany"";""deu"",""Germany"";""ger"",""Germany"";""germany"",""Germany"";""geramny"",""Germany"";""germnay"",""Germany"";""deutschland"",""Germany"";""deutscland"",""Germany"";""fr"",""France"";""france"",""France"";""farnce"",""France"";""f"&"ance"",""France"";""frnace"",""France"";""républiquefrançaise"",""France"";""br"",""Brazil"";""bra"",""Brazil"";""bz"",""Brazil"";""brazil"",""Brazil"";""brasil"",""Brazil"";""brzil"",""Brazil"…
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
Autosheet in Excel GPT-6.1 Sol · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Claude Code + Autosheet MCP Opus 5.5 · Medium
J2=IFERROR(__xludf.DUMMYFUNCTION("IF(F2="""", """", IFERROR(XLOOKUP(UPPER(REGEXREPLACE(F2, ""[^A-Za-zÀ-ÿ]"", """")), Country_Map!$A$2:$A1001, Country_Map!$B$2:$B1001), """"))"),"United States")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
ChatGPT + Autosheet MCP GPT-6 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Astra · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000. | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000. |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000. |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000. |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000. |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000. |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000. |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000. |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000. |
10 of 1,001 rows
Claude in Excel Haiku 5.5 · High
J2=IFERROR(VLOOKUP(TRIM(F2),'Country Map'!$A$2:$B$48,2,FALSE),"Unmapped")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
Claude in Sheets Haiku 5.5 · High
J2=IFERROR(VLOOKUP(TRIM(F2),'Country Map'!$A$2:$B$48,2,FALSE),"UNMAPPED")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | $500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | $4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | $7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | $11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | $15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | $19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | $22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | $26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | $30,100,000 |
10 of 1,001 rows
Autosheet in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Copilot in Excel Auto
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
ChatGPT + Drive MCP GPT-6 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
Gemini in Sheets Auto
J2=IFERROR(__xludf.DUMMYFUNCTION("IF(F2="""", """", IFS(REGEXMATCH(F2, ""(?i)^(us|u\.s|united state|uinted state)""), ""United States"", REGEXMATCH(F2, ""(?i)^(uk|u\.k|gb|g\.b|united\s*k|uinted\s*k)""), ""United Kingdom"", REGEXMATCH(F2, ""(?i)^(de|ger|deutsc)""), ""Germany"", REGEXMATCH("&"F2, ""(?i)^(fr|fa|république)""), ""France"", REGEXMATCH(F2, ""(?i)^(br|bz)""), ""Brazil"", REGEXMATCH(F2, ""(?i)^(jp|jap)""), ""Japan"", TRUE, F2))"),"United States")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Astra · Medium
J2=SWITCH(UPPER(SUBSTITUTE(SUBSTITUTE(TRIM(F2),".","")," ","")),"US","United States","USA","United States","UNITEDSTATES","United States","UNITEDSTATESOFAMERICA","United States","UNITEDSTATESAMERICA","United States","UNITEDSTATEOFAMERICA","United States","UINTEDSTATES","United States","UK","United Kingdom","GB","United Kingdom","GBR","United Kingdom","GREATBRITAIN","United Kingdom","UNITEDKINGDOM","United Kingdom","UNITEDKIGNDOM","United Kingdom","UINTEDKINGDOM","United Kingdom","DE","Germany","DEU","Germany","GER","Germany","GERMANY","Germany","DEUTSCHLAND","Germany","GERMNAY","Germany","DEUTSCLAND","Germany","GERAMNY","Germany","FR","France","FRA","France","FRANCE","France","FRNACE","France","FARNCE","France","FANCE","France","RÉPUBLIQUEFRANÇAISE","France","BR","Brazil","BRA","Brazil","BRAZIL","Brazil","BRASIL","Brazil","BRZIL","Brazil","BRZL","Brazil","BZ","Brazil","JP","Japan","JPN","Japan","JAPAN","Japan","JAPNA","Japan","JPAN","Japan","JAPN","Japan","REVIEW")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30100000 |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Luna · High
J2=IF(OR(LOWER(TRIM(F2))="us",LOWER(TRIM(F2))="u.s",LOWER(TRIM(F2))="u.s.",LOWER(TRIM(F2))="usa",LOWER(TRIM(F2))="u.s.a.",LOWER(TRIM(F2))="usa.",LOWER(TRIM(F2))="united states",LOWER(TRIM(F2))="united states of america",LOWER(TRIM(F2))="united states america",LOWER(TRIM(F2))="united state of america",LOWER(TRIM(F2))="uinted states"),"United States",IF(OR(LOWER(TRIM(F2))="uk",LOWER(TRIM(F2))="u.k",LOWER(TRIM(F2))="u.k.",LOWER(TRIM(F2))="united kingdom",LOWER(TRIM(F2))="unitedkingdom",LOWER(TRIM(F2))="uinted kingdom",LOWER(TRIM(F2))="united kigndom",LOWER(TRIM(F2))="gb",LOWER(TRIM(F2))="g.b."),"United Kingdom",IF(OR(LOWER(TRIM(F2))="de",LOWER(TRIM(F2))="deu",LOWER(TRIM(F2))="ger",LOWER(TRIM(F2))="germany",LOWER(TRIM(F2))="deutschland",LOWER(TRIM(F2))="germnay",LOWER(TRIM(F2))="geramny",LOWER(TRIM(F2))="deutscland"),"Germany",IF(OR(LOWER(TRIM(F2))="fr",LOWER(TRIM(F2))="france",LOWER(TRIM(F2))="frnace",LOWER(TRIM(F2))="farnce",LOWER(TRIM(F2))="fance",LOWER(TRIM(F2))="république française"),…
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500,000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4,200,000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7,900,000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11,600,000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15,300,000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Brazil | 19,000,000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22,700,000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26,400,000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Germany | 30,100,000 |
10 of 1,001 rows
Failed 1
Autosheet in Sheets Haiku 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | country_clean | annual_revenue_usd |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | United States | 500000 | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | Brazil | 4200000 |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States of America | Luca Ahmed | CTO | Renewal at risk, champi… | United States | 7900000 |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | Germany | 11600000 |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | US | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | United States | 15300000 |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | Unknown | 19000000 |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | Germany | 22700000 |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | United Kingdom | 26400000 |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DEU | Elena Ahmed | IT Director | Expansion opportunity: … | Unknown | 30100000 |
| 19 | Lumina Analytics | luminaanalytics.com | Manufacturing | 2500 | 63400000 | GER | Pavel Ahmed | CTO | Renewal at risk, champi… | Unknown | 63400000 |
| 45 | Beacon Cloud | beaconcloud.com | Health | 25 | 159,600,000 | BZ | Amina Alvarez | VP of Sales | Expansion opportunity: … | Unknown | 159600000 |
12 of 1,001 rows
Why it failed: 78 cells didn't match the expected value.
- Row 68 · country_raw
United State of America
- Written
- Unknown
- Expected
- United States
- Row 7 · country_raw
Brasil
- Written
- Unknown
- Expected
- Brazil