All AutosheetBench tasks

Extract domains from email addresses

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in E2:E5 to pull the domain from each email address.

Starting spreadsheet

People
ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.com42
3JeanVan DammeJean Van Damme…@contoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.com9102

A passing output

Autosheet in Excel · Opus 5.5
People4 cells changed

E2=MID(D2, FIND("@", D2) + 1, LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • E2:E5 hold the expected values, from formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed8s · 2¢
People4 cells changed

E2=MID(D2, FIND("@", D2) + 1, LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Excel GPT-6 Astra · Low

Passed8s · 5¢
People4 cells changed

E2=RIGHT(D2,LEN(D2)-FIND("@",D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Sheets Opus 5.5 · Medium

Passed8s · 2¢
People4 cells changed

E2=IF(D2="", "", MID(D2, FIND("@", D2) + 1, LEN(D2)))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 1¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Claude in Excel Opus 5.5 · High

Passed8s · 11¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Excel Haiku 5.5 · High

Passed5s · 0.1¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2)-FIND("@",D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Claude in Sheets Opus 5.5 · Medium

Passed17s · 3¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed28s · N/A
People4 cells changed

E2=IFERROR(LOWER(TRIM(MID(D2,FIND("@",D2)+1,LEN(D2)))),"")

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Excel GPT-6.1 Sol · Medium

Passed17s · 5¢
People4 cells changed

E2=RIGHT(D2,LEN(D2)-FIND("@",D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed32s · N/A
People4 cells changed

E2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(REGEXEXTRACT(D2, ""@(.+)$""), """")"),"example.com")

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed33s · N/A
People4 cells changed

E2=MID(D2, FIND("@", D2) + 1, LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Sheets Haiku 5.5 · High

Passed16s · 0.1¢
People4 cells changed

E2=RIGHT(D2, LEN(D2) - FIND("@", D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

ChatGPT in Excel GPT-6 Astra · Medium

Passed17s · 39¢
People4 cells changed

E2=RIGHT(D2,LEN(D2)-FIND("@",D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Claude in Excel Haiku 5.5 · High

Passed7s · 0.5¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Claude in Sheets Haiku 5.5 · High

Passed13s · 0.3¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Autosheet in Excel GPT-6 Luna · High

Passed7s · 0.1¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Copilot in Excel Auto

Passed19s · N/A
People4 cells changed

E2=RIGHT(D2,LEN(D2)-FIND("@",D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

ChatGPT + Drive MCP GPT-6 · Medium

Passed35s · N/A
People4 cells changed

E2=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(REGEXEXTRACT(D2,""@(.+)$""),"""")"),"example.com")

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

ChatGPT in Excel GPT-6 Luna · High

Passed16s · 0.4¢
People4 cells changed

E2=TEXTAFTER(D2,"@")

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

Gemini in Sheets Auto

Passed42s · N/A
People4 cells changed

E2=MID(D2, FIND("@", D2) + 1, LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

ChatGPT in Sheets GPT-6 Astra · Medium

Passed25s · 31¢
People4 cells changed

E2=RIGHT(D2,LEN(D2)-FIND("@",D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102

ChatGPT in Sheets GPT-6 Luna · High

Passed23s · 0.3¢
People4 cells changed

E2=MID(D2,FIND("@",D2)+1,LEN(D2))

ABCDEFG
1First NameLast NameFull NameEmailDomainIDPadded ID
2AnaMartinezAna Martinez…@example.comexample.com42
3JeanVan DammeJean Van Damme…@contoso.frcontoso.fr381
4MinaOkaforMina Okafor…@northwind.co.uknorthwind.co.uk7
5LucaBianchiLuca Bianchi…@fabrikam.comfabrikam.com9102