← How we score

BLIND TEST NO. 9

Mon 9 Nov. All five AIs answered each prompt once, with default settings. Answers are shown unedited. AI can make mistakes.

MAIN ROUND: TRIP PLANNING

“Suggest three ideas for a weekend in the mountains within three hours of Zurich, for someone who doesn't ski. One or two lines each.”

Claude Opus 5.5

anthropic/claude-opus-5.5 · served by Anthropic

  1. Rigi (about 1.5 hours): Take the cogwheel railway up, soak in the Botta-designed mineral spa at Rigi Kaltbad, and walk the panoramic trails. Winter adds snowshoe routes and sledging.

  2. Appenzell and Ebenalp (about 1.5 hours): Ride the cable car to Ebenalp, hike past the cliffside Aescher guesthouse down to Seealpsee, then spend the evening in Appenzell's painted village with local cheese and beer.

  3. Grindelwald and Lauterbrunnen (about 2.5 hours): Gondola up to First for the Cliff Walk, ridgeline hikes, or long sledge runs in winter. Spend the next day among Lauterbrunnen's waterfalls, including the glacier-fed Trümmelbach Falls inside the mountain (summer only).

Gemini 4 Argon

google/gemini-4-argon · served by Google AI Studio

  • Mount Rigi & Mineralbad Spa (approx. 1.5 hours): Ride Europe's oldest mountain railway up the "Queen of the Mountains" for panoramic winter hiking trails, then unwind in the indoor/outdoor thermal baths at Rigi Kaltbad overlooking Lake Lucerne.
  • Grindelwald & First Cliff Walk (approx. 2.5 hours): Experience the dramatic Bernese Alps by taking a gondola up to a thrilling suspension bridge, and spend the rest of the weekend enjoying some of the world's longest sledding runs.
  • Arosa on the Langwieser Viaduct (approx. 2.5 hours): Take a scenic train ride to this sunny valley to walk the famous "Squirrel Trail" where you can hand-feed local wildlife, followed by a romantic horse-drawn sleigh ride through the snow.

DeepSeek V4 Pro

deepseek/deepseek-v4-pro-0813 · served by DeepSeek

  • Arosa: A car-free alpine village about 2.5 hours from Zurich, with winter walking trails, an ice rink, horse-drawn sleigh rides, and a bear sanctuary—no skis needed.
  • Leukerbad: Soak in thermal hot springs surrounded by snowy peaks, then try easy snowshoe trails or a mountain spa day.
  • Engelberg/Titlis: Ride the cable car to the summit for glacier views and a suspension bridge, then enjoy winter hiking and fondue in the valley.

Kimi K3

moonshotai/kimi-k3 · served by Moonshot AI

Here are three mountain escapes that don't require skis:

  1. Mount Rigi & Rigi Kaltbad (~1.5 hrs) — Ride the cogwheel train up for easy groomed winter walks with lake views, then soak in the Mario Botta–designed mineral baths as the sun sets.

  2. Grindelwald & the Jungfraujoch (~2.5–3 hrs) — Take the train to the "Top of Europe" (3,454 m) for glaciers and an ice palace, then swap skis for the Eiger Run sledge run or a panoramic winter hiking trail.

  3. Flims & the Rhine Gorge (~2 hrs) — Hike snowy viewpoints above the "Swiss Grand Canyon," walk to frozen Lake Cauma, and warm up with fondue in a resort town that's pleasantly quiet away from the slopes.

All three are reachable by public transport, so you can skip the car and enjoy the scenery en route.

GPT-6 Sol

openai/gpt-6-sol · served by OpenAI

  • Mount Rigi (about 1½–2 hours): Take the cogwheel train up for panoramic views and an easy winter walk, then unwind at the Rigi Kaltbad mineral baths.
  • Engelberg (about 2 hours): Ride up to Titlis for glacier views and the ice cave, then spend a quieter afternoon exploring the village and its monastery.
  • Grindelwald (about 2¾ hours): Base yourself beneath the Eiger for winter walking, a ride to the First Cliff Walk, and a cosy mountain-hotel evening.

BONUS ROUND 1: RECIPES

“Plan five quick vegetarian weeknight dinners for two people, with one combined shopping list.”

Gemini 4 Argon

google/gemini-4-argon · served by Google AI Studio

Here is a 5-day vegetarian meal plan designed for two people. These recipes focus on bold flavors, minimal prep, and overlapping ingredients so nothing goes to waste (no half-used bunches of cilantro rotting in the fridge!).

All meals take 15 to 30 minutes to make.


The 5-Day Menu

Monday: 20-Minute Black Bean & Sweet Potato Tacos

  • The Prep: Peel and dice 1 large sweet potato into small (1/2-inch) cubes. Toss with oil, salt, cumin, and chili powder. Pan-fry in a skillet over medium-high heat for 12-15 minutes until tender and charred.
  • The Finish: Add 1 can of drained black beans to the skillet just to warm through. Serve in warmed corn tortillas topped with diced red onion, avocado, cilantro, a squeeze of lime, and cotija cheese.

Tuesday: Creamy Spinach & Chickpea Coconut Curry

  • The Prep: Start cooking 1 cup of jasmine rice. Meanwhile, sauté diced red onion (the rest from Monday), minced garlic, and ginger in a skillet. Stir in 2 tbsp curry powder for 30 seconds until fragrant.
  • The Finish: Pour in 1 can of coconut milk and 1 can of drained chickpeas. Simmer for 10 minutes until thickened. Stir in half a bag of baby spinach until wilted. Finish with a squeeze of lime juice and fresh cilantro. Serve over rice.

Wednesday: 15-Minute Peanut Sesame Noodles

  • The Prep: Boil 8 oz spaghetti (or ramen). In the last 2 minutes of boiling, throw 1 bag of coleslaw mix and 1 cup of shelled edamame directly into the pasta water to blanch. Drain everything together.
  • The Finish: Whisk together 1/3 cup peanut butter, 2 tbsp soy sauce, 1 tbsp sesame oil, juice of 1 lime, grated garlic, grated ginger, and 1/4 cup warm water. Toss the noodles and veggies in the sauce. Top with sliced green onions.

Thursday: Pesto Gnocchi with Burst Cherry Tomatoes

  • The Prep: Heat olive oil in a skillet. Add 1 package of shelf-stable gnocchi directly to the pan (do not boil them first!). Sauté for 5 minutes until crispy and golden.
  • The Finish: Toss 1 pint of cherry tomatoes and minced garlic into the skillet with the gnocchi; cook for 5 minutes until tomatoes burst. Turn off the heat and stir in the rest of the baby spinach and 1/3 cup store-bought pesto. Top with grated Parmesan.

Friday: Quick Veggie Fried Rice

  • The Prep: Use leftover jasmine rice from Tuesday (or cook a fresh batch). Whisk 4 eggs and scramble them in a hot skillet with sesame oil, then set aside.
  • The Finish: In the same pan, stir-fry 1 cup of edamame, diced bell pepper, and the whites of your green onions for 4 minutes. Add the cold rice, 2 tbsp soy sauce, and garlic/ginger. Stir-fry on high for 3 minutes. Toss the eggs and green onion tops back in and serve.

The Combined Shopping List

Check your pantry first! The "Pantry Staples" section lists items you likely already have.

Produce

  • 1 large sweet potato
  • 1 red onion
  • 1 bell pepper (any color)
  • 1 bunch green onions (scallions)
  • 1 head of garlic
  • 1 small knob of fresh ginger
  • 3 limes
  • 1 avocado
  • 1 pint cherry tomatoes
  • 1 bunch fresh cilantro
  • 1 bag (5-8 oz) baby spinach
  • 1 bag (10-12 oz) plain coleslaw mix (shredded cabbage & carrots)

Dairy, Fridge & Frozen

  • 1 dozen eggs (you only need 4)
  • 1 container fresh Pesto (usually near the refrigerated pasta)
  • 1 small wedge Parmesan cheese
  • 1 small package Cotija or Feta cheese (for tacos)
  • 1 bag (12 oz) frozen shelled edamame

Canned & Dry Goods

  • 1 can (15 oz) black beans
  • 1 can (15 oz) chickpeas (garbanzo beans)
  • 1 can (14 oz) full-fat coconut milk
  • 1 package (16 oz) shelf-stable potato gnocchi
  • 1 package (8 oz) corn tortillas
  • 1 box spaghetti (or 2 packs of ramen noodles, seasoning discarded)
  • 1 small bag Jasmine rice (you need about 2 cups uncooked total)
  • 1 jar creamy peanut butter

Pantry Staples (Check before buying)

  • Olive oil & neutral cooking oil
  • Toasted sesame oil
  • Soy sauce
  • Spices: Cumin, Chili powder, Curry powder, Salt, Black pepper
Prep-Ahead Tip:

On Tuesday, cook 2 cups of dry rice instead of 1. Use half for Tuesday's curry, and spread the other half on a plate to cool, then refrigerate it in a container. Cold, dried-out rice makes the best Fried Rice on Friday!

Claude Opus 5.5

anthropic/claude-opus-5.5 · served by Anthropic

5 Quick Vegetarian Weeknight Dinners for Two

Each meal takes about 30 minutes. Ingredients overlap across the week to cut waste. For example, Monday's rice becomes Thursday's fried rice.


Monday: Chickpea & Spinach Coconut Curry

Serve with: Jasmine rice (cook extra for Thursday)

  1. Cook 1½ cups jasmine rice. You'll eat half tonight and refrigerate the rest.
  2. Sauté 1 diced onion in oil for 5 min. Add 3 minced garlic cloves, 1 tbsp grated ginger, and 2 tbsp curry powder (or red curry paste). Cook 1 min.
  3. Add 1 can drained chickpeas, 1 can (14 oz) diced tomatoes, and 1 can coconut milk. Simmer 10–15 min.
  4. Stir in 3 big handfuls of spinach until wilted. Finish with lime juice, salt, and cilantro.
Tuesday: Crispy Black Bean Tacos with Lime Slaw
  1. Slaw: Toss 2 cups thinly sliced cabbage with juice of ½ lime, a drizzle of oil, salt, and chopped cilantro.
  2. Beans: Warm 1 can drained black beans with 1 tsp cumin, 1 tsp chili powder, and salt. Lightly mash.
  3. Fill tortillas with beans and pan-fry in a little oil until crisp, 2–3 min per side.
  4. Top with slaw, sliced avocado, crumbled feta, Greek yogurt, and hot sauce.
Wednesday: Lemon-Garlic Pasta with Tomatoes, Spinach & Feta
  1. Cook 8 oz spaghetti. Reserve ½ cup pasta water.
  2. Meanwhile, sauté 4 sliced garlic cloves and a pinch of red pepper flakes in 3 tbsp olive oil. Add 1 pint halved cherry tomatoes and cook until they burst, about 5–7 min.
  3. Toss in the pasta, the remaining spinach, the zest and juice of 1 lemon, and splashes of pasta water.
  4. Top with crumbled feta and black pepper.
Thursday: Veggie Fried Rice with Eggs
  1. Scramble 3 eggs in an oiled hot pan, then set them aside.
  2. Stir-fry 1 diced bell pepper, 1 cup shredded cabbage, and the white parts of 4 scallions for 3–4 min. Add 2 garlic cloves and 1 tsp ginger.
  3. Add Monday's cold rice and 1 cup frozen peas. Press the rice flat and let it crisp a bit.
  4. Season with 2–3 tbsp soy sauce and 1 tsp sesame oil. Fold in the eggs and top with scallion greens.
Friday: Shakshuka with Feta & Crusty Bread
  1. Sauté 1 diced onion and 1 sliced bell pepper for 8 min. Add 3 garlic cloves, 1 tsp cumin, and 1 tsp smoked paprika.
  2. Add 1 can (28 oz) crushed tomatoes and simmer 10 min. Season with salt.
  3. Make 4 wells in the sauce and crack in 4 eggs. Cover and cook 5–8 min until the whites are set.
  4. Top with feta and cilantro. Serve with warm crusty bread.

Combined Shopping List

Produce
  • Yellow onions: 2
  • Garlic: 1 large head
  • Fresh ginger: 1 small knob
  • Bell peppers: 2 (any color)
  • Cabbage: 1 small head (green or red)
  • Baby spinach: 1 large bag (10 oz)
  • Cherry tomatoes: 1 pint
  • Avocado: 1
  • Cilantro: 1 bunch
  • Scallions: 1 bunch
  • Limes: 2
  • Lemon: 1
Canned & Dry Goods
  • Chickpeas: 1 can (15 oz)
  • Black beans: 1 can (15 oz)
  • Coconut milk: 1 can (13.5 oz)
  • Diced tomatoes: 1 can (14 oz)
  • Crushed tomatoes: 1 can (28 oz)
  • Jasmine rice: 1½ cups
  • Spaghetti: 8 oz
  • Small tortillas (corn or flour): 6–8
  • Crusty bread: 1 loaf or baguette
Dairy & Eggs
  • Eggs: 1 dozen (you'll use 7)
  • Feta: 6–8 oz block or crumbles
  • Plain Greek yogurt or sour cream: 1 small container
Frozen
  • Peas: 1 small bag
Pantry Check (buy if you're out)
  • Olive oil and neutral oil
  • Salt and black pepper
  • Curry powder or red curry paste
  • Ground cumin
  • Chili powder
  • Smoked paprika
  • Red pepper flakes
  • Soy sauce
  • Toasted sesame oil
  • Hot sauce

Prep tips:

  • Cook the rice early on Monday so the leftovers chill well. Cold rice fries best.
  • Use the spinach by Wednesday and the cilantro by Friday. Store cilantro stems-down in a glass of water in the fridge.
  • Leftover cabbage keeps well and makes a quick side slaw anytime.

GPT-6 Sol

openai/gpt-6-sol · served by OpenAI

Five quick vegetarian dinners for two
Night Dinner Time Quick plan
1 Black bean and pepper quesadillas 20 min Sauté 1 bell pepper and ½ red onion. Fill 4 tortillas with the vegetables, 1 can drained black beans, and 4 oz shredded cheddar; toast until crisp.
2 Chickpea and spinach curry 25 min Soften the remaining ½ onion with garlic and 1 tbsp curry powder. Add 1 can chickpeas, 1 can diced tomatoes, and 1 can coconut milk. Simmer 15 minutes; stir in 2 oz spinach.
3 Pesto pasta with white beans 20 min Cook 6 oz pasta. Toss with 1 can drained white beans, 1 pint halved cherry tomatoes, 3 oz spinach, and about ⅓ cup pesto.
4 Ginger-soy tofu and broccoli rice bowls 30 min Cook 1½ cups dry rice; serve about 2 cups cooked tonight and refrigerate the rest. Pan-fry 1 block tofu and 1 head broccoli with garlic, ginger, and soy sauce.
5 Egg fried rice 15 min Stir-fry the leftover rice with a 12-oz bag of frozen peas and carrots, 3 scrambled eggs, garlic, soy sauce, and sliced scallions.
Combined shopping list

Produce: 1 bell pepper, 1 red onion, 1 garlic bulb, 1 small piece ginger, 1 head broccoli, 1 pint cherry tomatoes, 1 bunch scallions, 1 bag (5 oz) spinach.

Refrigerated: 4 oz shredded cheddar, 1 block (14 oz) firm tofu, 3 eggs, about ⅓ cup vegetarian pesto (check the label for animal rennet).

Canned and dry goods: 4 tortillas, 1 can black beans, 1 can chickpeas, 1 can white beans, 1 can diced tomatoes (14–15 oz), 1 can coconut milk (13–14 oz), 6 oz pasta, 1½ cups dry rice.

Frozen: 1 bag (12 oz) peas and carrots.

Pantry items to check: Oil, soy sauce (about 3 tbsp), curry powder (1 tbsp), salt, and pepper.

For the fried rice, cool and refrigerate the extra rice promptly after dinner on night 4.

Kimi K3

moonshotai/kimi-k3 · served by Moonshot AI

Five Vegetarian Weeknight Dinners for Two

1. Lemon-Garlic Pasta with Broccoli & White Beans (~20 min) Spaghetti tossed with sautéed broccoli, garlic, lemon zest and juice, cannellini beans, parmesan, and a pinch of red pepper flakes.

2. Tofu & Vegetable Stir-Fry (~25 min) Crispy pan-fried tofu with bell pepper, broccoli, and snap peas in a garlic-ginger-soy sauce, served over rice.

3. Sweet Potato & Black Bean Tacos (~30 min) Spiced, pan-roasted sweet potato cubes and black beans in warm tortillas with avocado, lime, cilantro, and pickled or raw red onion.

4. Chickpea & Spinach Curry (~25 min) Chickpeas simmered in a coconut-tomato curry sauce with garlic, ginger, and wilted spinach, served over rice.

5. Sheet-Pan Gnocchi with Tomatoes & Zucchini (~25 min) Shelf-stable gnocchi roasted with cherry tomatoes, zucchini, and red onion until the tomatoes burst into a sauce; top with parmesan and basil.


Combined Shopping List

Produce

  • 2 heads broccoli (dinners 1 & 2)
  • 2 bell peppers
  • 2 medium sweet potatoes
  • 1 bag (5 oz) fresh spinach
  • 1 pint cherry tomatoes
  • 2 zucchini
  • 2 avocados
  • 2 lemons, 3 limes
  • 1 large bulb garlic
  • 1 knob fresh ginger
  • 2 yellow onions, 1 red onion
  • 1 bunch scallions
  • 1 bunch cilantro
  • 1 small bunch basil (optional)
  • 1 small bag snap peas

Canned & Jarred

  • 1 can cannellini beans
  • 1 can black beans
  • 1 can chickpeas
  • 1 can coconut milk
  • 1 can diced tomatoes

Dry Goods

  • 1 box spaghetti (you'll use about half)
  • 1 package (1 lb) shelf-stable gnocchi
  • 1 small bag rice (2 dinners' worth)
  • 1 pack small tortillas (8–10 count)

Refrigerated

  • 1 block (14 oz) firm tofu
  • 1 wedge parmesan
  • Sour cream or Greek yogurt (optional, for tacos)

Pantry Staples (check before shopping)

  • Olive oil, sesame oil, soy sauce
  • Curry powder or garam masala, cumin, chili powder, red pepper flakes
  • Salt and pepper

Tip: Plan the tacos and curry for earlier in the week so the cilantro and spinach stay fresh — the pasta, stir-fry, and gnocchi ingredients all hold up well through Friday.

Happy to expand any of these into a full recipe with instructions if you'd like.

DeepSeek V4 Pro

deepseek/deepseek-v4-pro-0813 · served by DeepSeek

Here’s a quick 5-night vegetarian plan for two. It assumes you have basic pantry items like olive oil, salt, pepper, curry powder, cumin, turmeric, soy sauce, and sesame oil.

Weeknight Dinners
  1. Chickpea Coconut Curry with Spinach & Rice
    Sauté onion, garlic, and ginger. Add curry powder, canned tomatoes, coconut milk, and chickpeas. Simmer, then wilt in spinach. Serve over rice.
    Tip: Cook extra rice for Friday’s fried rice.

  2. Black Bean & Corn Quesadillas with Avocado-Lime Smash
    Mix black beans, corn, red onion, cilantro, and lime juice. Fill tortillas with cheese and the bean mixture; pan-fry until crisp. Mash avocado with lime and salt on the side.

  3. Zucchini, White Bean & Lemon Pasta
    Cook pasta. Sauté zucchini, garlic, and cherry tomatoes. Add white beans, cooked pasta, lemon zest/juice, basil, Parmesan, and a splash of pasta water.

  4. Halloumi Quinoa Bowls with Spinach & Tomatoes
    Cook quinoa. Pan-sear sliced halloumi. Serve over spinach with quinoa, cucumber, halved cherry tomatoes, red onion, lemon juice, and olive oil. Add hummus if you like.

  5. Egg & Veggie Fried Rice
    Sauté carrots, frozen peas, scallions, garlic, and ginger. Add leftover cooked rice, soy sauce, and sesame oil. Push to the side, scramble eggs, then mix everything together.


Combined Shopping List

Produce

  • 1 yellow onion
  • 1 small red onion
  • 1 head garlic
  • 1 knob fresh ginger
  • 2 lemons
  • 2 limes
  • 10 oz fresh spinach (2 bags)
  • 2 medium zucchini
  • 2 pints cherry or grape tomatoes
  • 1 English cucumber
  • 1 large avocado
  • 1 bunch fresh basil
  • 1 bunch fresh cilantro
  • 1 bunch scallions
  • 2 carrots
  • 1 cup frozen peas
  • 1 cup frozen or canned corn

Canned & Grains

  • 1 can chickpeas
  • 1 can black beans
  • 1 can white beans or cannellini beans
  • 1 can diced or crushed tomatoes
  • 1 can coconut milk
  • 2 cups dry jasmine or basmati rice
  • 1 cup dry quinoa
  • 8 oz pasta
  • 4 medium flour tortillas

Dairy & Eggs

  • 8 oz halloumi
  • 1 cup shredded Monterey Jack or cheddar
  • 1 small wedge Parmesan
  • 4 large eggs
  • Optional: hummus for bowls

Pantry Check

  • Olive oil
  • Neutral oil for frying
  • Salt and pepper
  • Curry powder
  • Ground cumin
  • Ground turmeric
  • Soy sauce or tamari
  • Toasted sesame oil
  • Optional: red pepper flakes

BONUS ROUND 2: SPREADSHEETS

“I have a list of expenses with a date, an amount and a category. What's the easiest way to see how much I spent per category each month in Excel? Step by step.”

Claude Opus 5.5

anthropic/claude-opus-5.5 · served by Anthropic

The easiest way is a PivotTable. It takes about a minute and updates with a click when you add more expenses.

Step 1: Check your data

Make sure your list looks like this:

  • One header row at the top (e.g., Date, Amount, Category)
  • No blank rows or columns in the middle
  • Dates are real dates, not text. A quick test: real dates are right-aligned by default, while text is left-aligned.
  • Amounts are numbers, not text.
Step 2: Turn your list into a Table (recommended)
  1. Click any cell in your data.
  2. Press Ctrl + T (Mac: Cmd + T).
  3. Make sure "My table has headers" is checked, then click OK.

Why: When you add new expenses later, the PivotTable will include them automatically.

Step 3: Insert the PivotTable
  1. Click any cell in your table.
  2. Go to Insert → PivotTable.
  3. Choose New Worksheet and click OK.
Step 4: Build the summary

In the PivotTable Fields pane on the right, drag:

  • Category → Rows
  • Date → Columns
  • Amount → Values
Step 5: Group the dates by month

Newer versions of Excel often group dates automatically into Years/Quarters/Months. If yours doesn't, or you want to adjust it:

  1. Right-click any date in the PivotTable's column headers.
  2. Choose Group…
  3. Select Months and Years. Include Years so that January 2024 and January 2025 aren't lumped together.
  4. Click OK.
Step 6: Make sure it's summing

The Values field should say "Sum of Amount." If it says "Count of Amount":

  1. Click it in the Values area and choose Value Field Settings.
  2. Select Sum and click OK.

(Seeing "Count" usually means some amounts are stored as text, so you may want to fix those.)

Step 7: Tidy up (optional)
  • Format as currency: Right-click a number → Number Format → Currency.
  • Sort categories by spending: Right-click a value → Sort → Largest to Smallest.
  • Add a chart: PivotTable Analyze → PivotChart, then choose a stacked column chart.
When you add new expenses

Add them to the bottom of your table, then right-click the PivotTable and choose Refresh. You can also use Data → Refresh All.


Alternative: formula approach

If you'd rather have a fixed grid with categories down the side and months across the top, use SUMIFS. With categories in column A, the first day of each month in row 1 (e.g., 1/1/2025), and your data in a table called Table1, put this in B2 and fill it across and down:

=SUMIFS(Table1[Amount], Table1[Category], $A2, Table1[Date], ">="&B$1, Table1[Date], "<="&EOMONTH(B$1,0))

For most people, though, the PivotTable is quicker and more flexible.

Gemini 4 Argon

google/gemini-4-argon · served by Google AI Studio

The absolute easiest and fastest way to do this in Excel is by using a Pivot Table. You don’t need to write a single formula, and it takes less than a minute.

Here is the step-by-step guide:

Step 1: Prep your data

Make sure your data is in a neat table with headers at the top (e.g., Date, Category, Amount). Ensure there are no completely blank rows or columns in your list.

Step 2: Insert a Pivot Table
  1. Click on any single cell inside your list of expenses.
  2. Go to the top ribbon and click the Insert tab.
  3. Click PivotTable (usually the first button on the far left).
  4. A pop-up box will appear. Just click OK (Excel will automatically select your data and create the table on a new worksheet).
Step 3: Build your report (Drag and Drop)

You will now see a blank table on the left, and a PivotTable Fields panel on the right side of your screen. At the bottom of that panel are four boxes: Filters, Columns, Rows, and Values.

Drag and drop your headers from the top list into the bottom boxes like this:

  1. Drag Category into the Rows box. (You will see your categories appear on the left).
  2. Drag Amount into the Values box. (It should say "Sum of Amount". This totals your spending).
  3. Drag Date into the Columns box.
Step 4: Fix the Months (Grouping)

When you drop the "Date" into the Columns box, modern versions of Excel will automatically group your dates into Years, Quarters, and Months.

  • If it grouped them automatically: Look at the Columns box. If you don't want to see "Quarters" or "Years", just click and drag those specific words out of the Columns box until only "Months" (or "Date") remains.
  • If it did NOT group them (you just see individual days): Right-click on any of the dates in your new Pivot Table, click Group, select Months (and Years if your data spans multiple years), and click OK.
Step 5: Make it look like money (Optional)

Your numbers might not have dollar signs yet.

  1. Right-click on any number in your Pivot Table.
  2. Click Number Format...
  3. Select Currency and click OK.

Done! You now have a grid showing your categories down the side, the months across the top, and your total spending for each.

Bonus Tip: If you add new expenses to your original list later, just right-click anywhere on your Pivot Table and click Refresh to update the numbers.

DeepSeek V4 Pro

deepseek/deepseek-v4-pro-0813 · served by DeepSeek

The easiest way is to use a PivotTable.

Assume your data has columns: Date, Amount, Category.

Step-by-step
  1. Click anywhere inside your expense list.

  2. Insert a PivotTable

    • Go to the Insert tab.
    • Click PivotTable.
    • Excel should automatically select your data range.
    • Choose New Worksheet.
    • Click OK.
  3. Build the PivotTable layout
    In the PivotTable Fields panel:

    • Drag Date to the Rows area.
    • Drag Category to the Columns area.
    • Drag Amount to the Values area.

    Excel will likely show Sum of Amount. If it shows Count of Amount, click the field in Values, choose Value Field Settings, then select Sum.

  4. Group the dates by month

    • Click any date in the PivotTable row labels.
    • Right-click and choose Group.
    • Select Months and Years.
    • Click OK.

    Selecting Years is important if your data covers more than one year, so January 2024 and January 2025 stay separate.

  5. Read the result
    Now you will see:

    • Rows: months/years
    • Columns: categories
    • Values: total spent per category per month
  6. Optional: Format as currency

    • Select the value cells.
    • Press Ctrl + 1.
    • Choose Currency or Accounting.
    • Click OK.
Tip

If you add more expenses later, right-click the PivotTable and choose Refresh.

If you want categories as rows and months as columns instead, just swap the fields: put Category in Rows and Date in Columns, then group the date column by months/years.

Kimi K3

moonshotai/kimi-k3 · served by Moonshot AI

A PivotTable is the easiest way — no formulas needed. Here's how:

Step-by-step
  1. Check your data layout: one header row (e.g., Date, Amount, Category) with no blank rows in the middle.

  2. Click any cell inside your data, then go to Insert → PivotTable and click OK (it will open in a new sheet by default).

  3. In the PivotTable Fields pane (right side):

    • Drag Date into the Rows area
    • Drag Category into the Columns area
    • Drag Amount into the Values area
  4. Group the dates by month: right-click any date in the table → Group → select Months → OK.

    • If your data spans more than one year, also select Years (hold Ctrl), otherwise January 2024 and January 2025 get lumped together.
    • In newer Excel versions, dates may auto-group by month already — if you see "Months" in the Rows area, you're done.
  5. Check the Values field: it should say "Sum of Amount." If it says "Count of Amount," click it → Value Field Settings → Sum.

You now have a matrix: months down the left, categories across the top, totals in the cells — plus automatic row/column grand totals.

Handy tips
  • New expenses later? Right-click the PivotTable → Refresh. Even better: convert your data to a Table first (select it, press Ctrl+T) before making the PivotTable — then it picks up new rows automatically on refresh.
  • Want it as currency? Select the value cells, right-click → Number Format → Currency.

Alternative: If you prefer formulas that update live, SUMIFS works too (e.g., sum amounts where category = X and date is between the 1st and end of month) — but for a quick overview, the PivotTable is faster to set up.

GPT-6 Sol

openai/gpt-6-sol · served by OpenAI

The easiest way is a PivotTable. It will show each month’s total for every category.

  1. Make sure your data has headers such as Date, Amount, and Category, and that the dates are actual Excel dates.
  2. Click anywhere in your data, then choose Insert → PivotTable → OK.
  3. In the PivotTable Fields pane, drag:
    • Date to Rows
    • Category to Columns
    • Amount to Values
  4. If Values says Count of Amount, click it, choose Value Field Settings, and select Sum.
  5. Right-click a date in the PivotTable and choose Group. Select Months and Years, then click OK. Including years keeps, for example, January 2025 separate from January 2026.

You’ll now have months down the side, categories across the top, and spending totals in the middle. When you add expenses later, right-click the PivotTable and choose Refresh.