Assign product types to a catalog
Bulk data processingEasyWhole-set scoringLatest run
Passed by all 12 products on their best model.
Prompt
In a new column
product_type, assign each product to a product type among: - Drinkware - Bags - Audio - Lighting - Furniture - Accessories
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.K2:K1001, headed "product_type": filled with "Drinkware", "Bags", "Audio", "Lighting", "Furniture" or "Accessories", matching each row's reviewed reference
Passed 22
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
Claude in Sheets Opus 5.5 · Medium
K2=IFERROR(INDEX($N$2:$N$9,MATCH(TRUE,INDEX(ISNUMBER(SEARCH(" "&$M$2:$M$9&" "," "&B2&" ")),0),0)),"Unassigned")
| 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 | product_type | keyword | product_type | |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | Bottle | Drinkware | ||||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | Mug | Drinkware | |||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio | Backpack | Bags | |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting | Headphones | Audio | |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | Lamp | Lighting | ||||
| 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… | Accessories | Chair | Furniture | ||
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | Keyboard | Accessories | ||
| 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… | Accessories | Watch | Accessories | |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
Claude Code + Autosheet 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
Claude in Excel Haiku 5.5 · High
K2=IFERROR(INDEX(Product_Map!$B$2:$B$9,MATCH(TRUE,ISNUMBER(SEARCH(Product_Map!$A$2:$A$9,B2)),0)),"Unclassified")
| 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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)), "Unassigned")
| 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 | product_type | product_noun | product_type | |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | Bottle | Drinkware | ||||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | Mug | Drinkware | |||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio | Backpack | Bags | |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting | Headphones | Audio | |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | Lamp | Lighting | ||||
| 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… | Accessories | Chair | Furniture | ||
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | Watch | Accessories | ||
| 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… | Accessories | Keyboard | Accessories | |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
Copilot in Excel Auto
K2=LET(_xlpm.t,LOWER(B2),IFS(OR(ISNUMBER(SEARCH("bottle",_xlpm.t)),ISNUMBER(SEARCH("mug",_xlpm.t))),"Drinkware",ISNUMBER(SEARCH("backpack",_xlpm.t)),"Bags",ISNUMBER(SEARCH("headphones",_xlpm.t)),"Audio",ISNUMBER(SEARCH("lamp",_xlpm.t)),"Lighting",ISNUMBER(SEARCH("chair",_xlpm.t)),"Furniture",OR(ISNUMBER(SEARCH("watch",_xlpm.t)),ISNUMBER(SEARCH("keyboard",_xlpm.t))),"Accessories",TRUE,"Unclassified"))
| 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Luna · High
K2=IFS(ISNUMBER(SEARCH("bottle",B2)),"Drinkware",ISNUMBER(SEARCH("mug",B2)),"Drinkware",ISNUMBER(SEARCH("backpack",B2)),"Bags",ISNUMBER(SEARCH("headphones",B2)),"Audio",ISNUMBER(SEARCH("lamp",B2)),"Lighting",ISNUMBER(SEARCH("chair",B2)),"Furniture",ISNUMBER(SEARCH("watch",B2)),"Accessories",ISNUMBER(SEARCH("keyboard",B2)),"Accessories")
| 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
Gemini in Sheets Auto
K2=IFERROR(__xludf.DUMMYFUNCTION("IFS(REGEXMATCH(B2, ""(?i)Bottle|Mug""), ""Drinkware"", REGEXMATCH(B2, ""(?i)Backpack""), ""Bags"", REGEXMATCH(B2, ""(?i)Headphones""), ""Audio"", REGEXMATCH(B2, ""(?i)Lamp""), ""Lighting"", REGEXMATCH(B2, ""(?i)Chair""), ""Furniture"", REGEXMATCH(B2, ""(?"&"i)Watch|Keyboard""), ""Accessories"", TRUE, """")"),"Drinkware")
| 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Astra · Medium
K2=IF(OR(ISNUMBER(SEARCH(" Bottle ",B2)),ISNUMBER(SEARCH(" Mug ",B2))),"Drinkware",IF(ISNUMBER(SEARCH(" Backpack ",B2)),"Bags",IF(ISNUMBER(SEARCH(" Headphones ",B2)),"Audio",IF(ISNUMBER(SEARCH(" Lamp ",B2)),"Lighting",IF(ISNUMBER(SEARCH(" Chair ",B2)),"Furniture",IF(OR(ISNUMBER(SEARCH(" Watch ",B2)),ISNUMBER(SEARCH(" Keyboard ",B2))),"Accessories","REVIEW"))))))
| 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Luna · High
K2=IF(OR(ISNUMBER(SEARCH("Bottle",B2)),ISNUMBER(SEARCH("Mug",B2))),"Drinkware",IF(ISNUMBER(SEARCH("Backpack",B2)),"Bags",IF(ISNUMBER(SEARCH("Headphones",B2)),"Audio",IF(ISNUMBER(SEARCH("Lamp",B2)),"Lighting",IF(ISNUMBER(SEARCH("Chair",B2)),"Furniture","Accessories")))))
| 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 | product_type |
| 2 | SKU-5000 | Nordisk Series 100 Stee… | Electronics | USD | 80 g | 5 x 5 x 2 cm | Premium steel bottle wi… | Drinkware | |||
| 3 | SKU-5001 | Lumen Series 101 Steel … | Lumen | 52.49 | USD | 163 g | 12 x 16 x 15 cm | Premium steel backpack … | Bags | ||
| 4 | SKU-5002 | Marisol Series 102 Stee… | Marisol | Outdoors | 99.95 | USD | 246 g | 19 x 27 x 28 cm | Assorted | Premium steel headphone… | Audio |
| 5 | SKU-5003 | Kettl Series 103 Steel … | Kettl | outdoor | 146.99 | USD | 329 g | 26 x 38 x 12 cm | Copper | wireless charging付きのプレミ… | Lighting |
| 6 | SKU-5004 | Basalt Series 104 Steel… | Electronics | USD | 412 g | 33 x 13 x 25 cm | Hochwertiges steel-chai… | Furniture | |||
| 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… | Accessories | |
| 8 | SKU-5006 | Vireo Series 106 Steel … | Vireo | 287.95 | USD | 578 g | 11 x 35 x 22 cm | Assorted | Premium steel mug with … | Drinkware | |
| 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… | Accessories |
| 10 | SKU-5008 | Lumen Series 108 Alumin… | Work | USD | 744 g | 25 x 21 x 19 cm | wireless charging付きのプレミ… | Drinkware |
10 of 1,001 rows