All AutosheetBench tasks

Split full names into first and last

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in A2:B5 to split each full name into first and last name.

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
People8 cells changed

A2=IFERROR(LEFT(C2, FIND(" ", C2) - 1), C2)

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

How each AI configuration did

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

Pass criteria

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

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed14s · 4¢
People8 cells changed

A2=IFERROR(LEFT(C2, FIND(" ", C2) - 1), C2)

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

Autosheet in Excel GPT-6 Astra · Low

Passed8s · 6¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2)-1)

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

Autosheet in Sheets Opus 5.5 · Medium

Passed10s · 3¢
People8 cells changed

A2=LEFT(C2, FIND(" ", C2) - 1)

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

Autosheet in Excel Sonnet 5.5 · Medium

Passed6s · 1¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2&" ")-1)

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

Claude in Excel Opus 5.5 · High

Passed13s · 8¢
People8 cells changed

A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2))-1)

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

Autosheet in Excel Haiku 5.5 · High

Passed8s · 0.1¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2)-1)

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

Claude in Sheets Opus 5.5 · Medium

Passed28s · 6¢
People8 cells changed

A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2))-1)

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

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed23s · N/A
People8 cells changed

A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2))-1)

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

Autosheet in Excel GPT-6.1 Sol · Medium

Passed13s · 2¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2&" ")-1)

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

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed55s · N/A
People8 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("REGEXEXTRACT(TRIM(C2), ""^\S+"")"),"Ana")

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

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed35s · N/A
People8 cells changed

A2=LEFT(C2, FIND(" ", C2) - 1)

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

Autosheet in Sheets Haiku 5.5 · High

Passed15s · 0.1¢
People8 cells changed

A2=LEFT(C2, FIND(" ", C2) - 1)

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

ChatGPT in Excel GPT-6 Astra · Medium

Passed14s · 40¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2)-1)

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

Claude in Sheets Haiku 5.5 · High

Passed1m 42s · 0.6¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2)-1)

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

Autosheet in Excel GPT-6 Luna · High

Passed7s · 0.2¢
People8 cells changed

A2=TEXTBEFORE(C2," ")

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

Copilot in Excel Auto

Passed21s · N/A
People8 cells changed

A2=TEXTBEFORE(C2," ")

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

ChatGPT + Drive MCP GPT-6 · Medium

Passed28s · N/A
People8 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("IF(TRIM(C2)="""","""",REGEXEXTRACT(TRIM(C2),""^\S+""))"),"Ana")

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

ChatGPT in Excel GPT-6 Luna · High

Passed20s · 0.4¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2)-1)

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

Gemini in Sheets Auto

Passed3m 8s · N/A
People8 cells changed

A2=LEFT(C2, FIND(" ", C2) - 1)

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

ChatGPT in Sheets GPT-6 Astra · Medium

Passed20s · 32¢
People8 cells changed

A2=LEFT(TRIM(C2),FIND(" ",TRIM(C2)&" ")-1)

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

ChatGPT in Sheets GPT-6 Luna · High

Passed24s · 0.3¢
People8 cells changed

A2=LEFT(C2,FIND(" ",C2)-1)

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

Failed 1

Claude in Excel Haiku 5.5 · High

Failed16s · 0.5¢
PeopleNo cell changedWrong value
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

Why it failed: A2:B5 hold no formula.