Assign clean product categories
Bulk data processingEasyWhole-set scoringLatest run
Passed by 11 of 12 products on their best model. Failed: Gemini in Sheets.
Prompt
Add a new column with the header
category_cleanin column K. Fill it for every row with exactly one of the following categories: -Kitchenfor bottles, mugs, cookware, and food preparation or storage products -Electronicsfor headphones, keyboards, and other electronic devices -Apparelfor watches, clothing, and wearable accessories -Outdoorsfor backpacks, camping products, and travel gear -Officefor lamps, chairs, desks, and workplace equipment -Otherfor products that cannot reasonably be assigned to the categories above Be careful, thecategory_rawcolumn (column D) can be inconsistent, sometimes empty, and may be incorrect.
Starting spreadsheet
Sheet1 · rows 1–21 of 1,001| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description |
| 2 | SKU-5000 | Nordisk Series 100 Steel Bottle Midnight Blue 80g 5x5x2cm | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle with wireless charging. Ref SKU-5000. Ideal for everyday use. Designed for daily commuting; backed by a 6-month warran… | |||
| 3 | SKU-5001 | Lumen Series 101 Steel Backpack Ivory 163g 12x16x15cm | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack with wireless charging. Ref SKU-5001. Ideal for everyday use. Designed for long-haul travel; backed by a 9-month war… | ||
| 4 | SKU-5002 | Marisol Series 102 Steel Headphones Slate 246g 19x27x28cm | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphones with wireless charging. Ref SKU-5002. Ideal for everyday use. Designed for weekend camping; backed by a 12-month w… |
| 5 | SKU-5003 | Kettl Series 103 Steel Lamp Copper 329g 26x38x12cm | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミアムsteellamp。参照 SKU-5003。毎日の使用に最適。 fitness training向けに設計。students向けの15か月保証付き。 Model Series 103. |
| 6 | SKU-5004 | Basalt Series 104 Steel Chair Rose 412g 33x13x25cm | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chair mit wireless charging. Ref SKU-5004. Ideal fuer taeglichen Gebrauch. Fur studio recording entwickelt; 18 Monate Ga… | |||
| 7 | SKU-5005 | Aveo Series 105 Steel Watch Sand 495g 40x24x9cm | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch with wireless charging. Ref SKU-5005. Ideal for everyday use. Designed for remote work; backed by a 21-month warranty f… | |
| 8 | SKU-5006 | Vireo Series 106 Steel Mug Graphite 578g 11x35x22cm | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with wireless charging. Ref SKU-5006. Ideal for everyday use. Designed for home offices; backed by a 24-month warranty fo… | |
| 9 | SKU-5007 | Nordisk Series 107 Steel Keyboard Forest Green 661g 18x10x6cm | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premium com wireless charging. Ref SKU-5007. Ideal para uso diario. Criado para small kitchens; garantia de 27 meses para… |
| 10 | SKU-5008 | Lumen Series 108 Aluminum Bottle Midnight Blue 744g 25x21x19cm | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミアムaluminumbottle。参照 SKU-5008。毎日の使用に最適。 daily commuting向けに設計。students向けの30か月保証付き。 | |||
| 11 | SKU-5009 | Marisol Series 109 Aluminum Backpack Ivory 827g 32x32x3cm | Marisol | home & kitchen | 132.49 | USD | 827 g | 32 x 32 x 3 cm | Premium aluminum backpack with wireless charging. Ref SKU-5009. Ideal for everyday use. Designed for long-haul travel; backed by a 33-month… | |
| 12 | SKU-5010 | Kettl Series 110 Aluminum Headphones Slate 910g 39x7x16cm | Kettl | Clothing | 179.95 | USD | 910 g | 39 x 7 x 16 cm | Assorted | Hochwertiges aluminum-headphones mit wireless charging. Ref SKU-5010. Ideal fuer taeglichen Gebrauch. Fur weekend camping entwickelt; 36 Mo… |
| 13 | SKU-5011 | Basalt Series 111 Aluminum Lamp Copper 993g 10x18x29cm | Basalt | home & kitchen | 226.99 | USD | 993 g | 10 x 18 x 29 cm | Copper | lamp de aluminum premium con wireless charging. Ref SKU-5011. Ideal para uso diario. Disenado para fitness training; garantia de 8 meses pa… |
| 14 | SKU-5012 | Aveo Series 112 Aluminum Chair Rose 1076g 17x29x13cm | outdoor | USD | 1076 g | 17 x 29 x 13 cm | chair en aluminum haut de gamme avec wireless charging. Ref SKU-5012. Ideal au quotidien. Concu pour studio recording; garantie de 11 mois … | |||
| 15 | SKU-5013 | Vireo Series 113 Aluminum Watch Sand 1159g 24x40x26cm | Vireo | apparel | 24.49 | USD | 1159 g | 24 x 40 x 26 cm | Hochwertiges aluminum-watch mit wireless charging. Ref SKU-5013. Ideal fuer taeglichen Gebrauch. Fur remote work entwickelt; 14 Monate Gara… | |
| 16 | SKU-5014 | Nordisk Series 114 Aluminum Mug Graphite 1242g 31x15x10cm | Nordisk | 71.95 | USD | 1242 g | 31 x 15 x 10 cm | Assorted | mug de aluminum premium con wireless charging. Ref SKU-5014. Ideal para uso diario. Disenado para home offices; garantia de 17 meses para s… | |
| 17 | SKU-5015 | Lumen Series 115 Aluminum Keyboard Forest Green 1325g 38x26x23cm | Lumen | office | 118.99 | USD | 1325 g | 38 x 26 x 23 cm | Forest Green | Premium aluminum keyboard with wireless charging. Ref SKU-5015. Ideal for everyday use. Designed for small kitchens; backed by a 20-month w… |
| 18 | SKU-5016 | Marisol Series 116 Cotton Bottle Midnight Blue 1408g 9x37x7cm | Work | USD | 1408 g | 9 x 37 x 7 cm | Hochwertiges cotton-bottle mit wireless charging. Ref SKU-5016. Ideal fuer taeglichen Gebrauch. Fur daily commuting entwickelt; 23 Monate G… | |||
| 19 | SKU-5017 | Kettl Series 117 Cotton Backpack Ivory 1491g 16x12x20cm | Kettl | 212.49 | USD | 1491 g | 16 x 12 x 20 cm | backpack en cotton haut de gamme avec wireless charging. Ref SKU-5017. Ideal au quotidien. Concu pour long-haul travel; garantie de 26 mois… | ||
| 20 | SKU-5018 | Basalt Series 118 Cotton Headphones Slate 1574g 23x23x4cm | Basalt | Tech | 259.95 | USD | 1574 g | 23 x 23 x 4 cm | Assorted | Premium cotton headphones with wireless charging. Ref SKU-5018. Ideal for everyday use. Designed for weekend camping; backed by a 29-month … |
| 21 | SKU-5019 | Aveo Series 119 Cotton Lamp Copper 1657g 30x34x17cm | Aveo | apparel | 10.99 | USD | 1657 g | 30 x 34 x 17 cm | Copper | Premium cotton lamp with wireless charging. Ref SKU-5019. Ideal for everyday use. Designed for fitness training; backed by a 32-month warra… |
A passing output
Autosheet in Excel · Opus 5.5| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.K2:K1001, headed "category_clean": filled with "Kitchen", "Electronics", "Apparel", "Outdoors", "Office" or "Other", matching each row's reviewed reference
Passed 21
Autosheet in Excel Opus 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Autosheet in Excel GPT-6 Astra · Low
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Autosheet in Sheets Opus 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Autosheet in Excel Sonnet 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Claude in Excel Opus 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Autosheet in Excel Haiku 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Claude in Sheets Opus 5.5 · Medium
K2=IFERROR(__xludf.DUMMYFUNCTION("IFS(REGEXMATCH(LOWER($B2),""\b(bottle|mug|cookware|pan|pot|kettle|container)\b""),""Kitchen"",REGEXMATCH(LOWER($B2),""\b(headphones|keyboard|speaker|charger|mouse)\b""),""Electronics"",REGEXMATCH(LOWER($B2),""\b(watch|shirt|jacket|hat|scarf)\b""),""Appare"&"l"",REGEXMATCH(LOWER($B2),""\b(backpack|tent|sleeping bag|luggage)\b""),""Outdoors"",REGEXMATCH(LOWER($B2),""\b(lamp|chair|desk)\b""),""Office"",TRUE,""Other"")"),"Kitchen")
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Claude Code + Sheets MCP Opus 5.5 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
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 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Claude Code + Autosheet MCP Opus 5.5 · Medium
L1=COUNTIF(F2:F1001,"Empty raw")
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | row | sku | product name | category_raw | category_clean | issue | raw (normalized) | maps to | Empty raw | 146 | ||
| 2 | 2 | SKU-5000 | Nordisk Series 100 Steel Bottle Midnight Blue 80g 5x5x2cm | Electronics | Kitchen | Mismatch | apparel | Apparel | Mismatch | 686 | ||
| 3 | 3 | SKU-5001 | Lumen Series 101 Steel Backpack Ivory 163g 12x16x15cm | Outdoors | Empty raw | clothing | Apparel | |||||
| 4 | 4 | SKU-5002 | Marisol Series 102 Steel Headphones Slate 246g 19x27x28cm | Outdoors | Electronics | Mismatch | electronics | Electronics | ||||
| 5 | 5 | SKU-5003 | Kettl Series 103 Steel Lamp Copper 329g 26x38x12cm | outdoor | Office | Mismatch | tech | Electronics | ||||
| 6 | 6 | SKU-5004 | Basalt Series 104 Steel Chair Rose 412g 33x13x25cm | Electronics | Office | Mismatch | kitchen | Kitchen | ||||
| 7 | 8 | SKU-5006 | Vireo Series 106 Steel Mug Graphite 578g 11x35x22cm | Kitchen | Empty raw | home & kitchen | Kitchen | |||||
| 8 | 9 | SKU-5007 | Nordisk Series 107 Steel Keyboard Forest Green 661g 18x10x6cm | kitchen | Electronics | Mismatch | office | Office | ||||
| 9 | 10 | SKU-5008 | Lumen Series 108 Aluminum Bottle Midnight Blue 744g 25x21x19cm | Work | Kitchen | Mismatch | work | Office | ||||
| 10 | 11 | SKU-5009 | Marisol Series 109 Aluminum Backpack Ivory 827g 32x32x3cm | home & kitchen | Outdoors | Mismatch | outdoors | Outdoors |
10 of 833 rows
ChatGPT + Autosheet MCP GPT-6 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Autosheet in Sheets Haiku 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Astra · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Claude in Excel Haiku 5.5 · High
K2=IF(OR(ISNUMBER(SEARCH("Bottle",B2)),ISNUMBER(SEARCH("Mug",B2))),"Kitchen",IF(OR(ISNUMBER(SEARCH("Headphones",B2)),ISNUMBER(SEARCH("Keyboard",B2))),"Electronics",IF(OR(ISNUMBER(SEARCH("Watch",B2)),ISNUMBER(SEARCH("Clothing",B2))),"Apparel",IF(OR(ISNUMBER(SEARCH("Backpack",B2)),ISNUMBER(SEARCH("Camping",B2)),ISNUMBER(SEARCH("Travel",B2))),"Outdoors",IF(OR(ISNUMBER(SEARCH("Lamp",B2)),ISNUMBER(SEARCH("Chair",B2)),ISNUMBER(SEARCH("Desk",B2))),"Office","Other")))))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Claude in Sheets Haiku 5.5 · High
K2=IFERROR(INDEX($N$2:$N$9,MATCH(TRUE,ISNUMBER(SEARCH($M$2:$M$9,B2)),0)),"Other")
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean | product_keyword | category_clean | |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | Bottle | Kitchen | ||||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | Mug | Kitchen | |||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics | Keyboard | Electronics | |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office | Headphones | Electronics | |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | Watch | Apparel | ||||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | Backpack | Outdoors | ||
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | Lamp | Office | ||
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics | Chair | Office | |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Autosheet in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Copilot in Excel Auto
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
ChatGPT + Drive MCP GPT-6 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Astra · Medium
K2=IF(OR(ISNUMBER(SEARCH("bottle",B2)),ISNUMBER(SEARCH("mug",B2))),"Kitchen",IF(OR(ISNUMBER(SEARCH("headphones",B2)),ISNUMBER(SEARCH("keyboard",B2))),"Electronics",IF(ISNUMBER(SEARCH("watch",B2)),"Apparel",IF(ISNUMBER(SEARCH("backpack",B2)),"Outdoors",IF(OR(ISNUMBER(SEARCH("lamp",B2)),ISNUMBER(SEARCH("chair",B2))),"Office","Other")))))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Luna · High
K2=IF(OR(ISNUMBER(SEARCH("bottle",B2)),ISNUMBER(SEARCH("mug",B2)),ISNUMBER(SEARCH("cookware",B2)),ISNUMBER(SEARCH("kitchenware",B2)),ISNUMBER(SEARCH("food prep",B2)),ISNUMBER(SEARCH("food storage",B2)),ISNUMBER(SEARCH("container",B2)),ISNUMBER(SEARCH("kettle",B2)),ISNUMBER(SEARCH("blender",B2)),ISNUMBER(SEARCH("knife",B2)),ISNUMBER(SEARCH("cutting board",B2)),ISNUMBER(SEARCH("pan",B2)),ISNUMBER(SEARCH("pot",B2))),"Kitchen",IF(OR(ISNUMBER(SEARCH("headphone",B2)),ISNUMBER(SEARCH("keyboard",B2)),ISNUMBER(SEARCH("mouse",B2)),ISNUMBER(SEARCH("speaker",B2)),ISNUMBER(SEARCH("monitor",B2)),ISNUMBER(SEARCH("laptop",B2)),ISNUMBER(SEARCH("tablet",B2)),ISNUMBER(SEARCH("camera",B2)),ISNUMBER(SEARCH("phone",B2)),ISNUMBER(SEARCH("charger",B2)),ISNUMBER(SEARCH("electronic",B2))),"Electronics",IF(OR(ISNUMBER(SEARCH("watch",B2)),ISNUMBER(SEARCH("clothing",B2)),ISNUMBER(SEARCH("wearable",B2)),ISNUMBER(SEARCH("apparel",B2)),ISNUMBER(SEARCH("jacket",B2)),ISNUMBER(SEARCH("shirt",B2)),ISNUMBER(SEARCH("pants",…
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Kitchen | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Outdoors | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Electronics |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Office |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Office | |||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | Apparel | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Kitchen | |
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | Electronics |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Kitchen |
10 of 1,001 rows
Failed 1
Gemini in Sheets Auto
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | sku | raw_title | brand | category_raw | price | currency | weight_raw | dimensions_raw | color | supplier_description | category_clean |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | ||||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | |||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | ||||
| 7 | SKU-5005 | Aveo Series 105 Steel W… | Aveo | apparel | 240.49 | USD | 495 g | 40 x 24 x 9 cm | Premium steel watch wit… | ||
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | ||
| 9 | SKU-5007 | Nordisk Series 107 Stee… | Nordisk | kitchen | 38.99 | USD | 661 g | 18 x 10 x 6 cm | Forest Green | keyboard de steel premi… | |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | ||||
| 11 | SKU-5009 | Marisol Series 109 Alum… | Marisol | home & kitchen | 132.49 | USD | 827 g | 32 x 32 x 3 cm | Premium aluminum backpa… | ||
| 12 | SKU-5010 | Kettl Series 110 Alumin… | Kettl | Clothing | 179.95 | USD | 910 g | 39 x 7 x 16 cm | Assorted | Hochwertiges aluminum-h… | |
| 13 | SKU-5011 | Basalt Series 111 Alumi… | Basalt | home & kitchen | 226.99 | USD | 993 g | 10 x 18 x 29 cm | Copper | lamp de aluminum premiu… | |
| 14 | SKU-5012 | Aveo Series 112 Aluminu… | outdoor | USD | 1076 g | 17 x 29 x 13 cm | chair en aluminum haut … | ||||
| 15 | SKU-5013 | Vireo Series 113 Alumin… | Vireo | apparel | 24.49 | USD | 1159 g | 24 x 40 x 26 cm | Hochwertiges aluminum-w… |
15 of 1,001 rows
Why it failed: All cells were left empty.