Claude Sheets Just Took On Excel. I REALLY Tested It — Transcript
Full transcript
- 0:00Claude just took on Excel and one prompt
- 0:02built this game in about three minutes.
- 0:04Anthropic put its own spreadsheet and
- 0:06whiteboard inside Claude for every paid
- 0:09user.
- 0:10That's a shot at a tool behind over 450
- 0:13million Microsoft 365 business seats.
- 0:17But even Anthropic says you'll still
- 0:19need Excel.
- 0:20So I gave Claude five real jobs from an
- 0:23Excel file to a game and kept score.
- 0:26[music]
- 0:26Every test is on camera.
- 0:28By the end of this video, you'll learn
- 0:30Claude sheets step by step. You'll learn
- 0:33Claude's whiteboard step by step. You'll
- 0:35see a app and a game from Fable 5 to the
- 0:38new model and you'll learn when you
- 0:40still need [music] Excel.
- 0:42Before that, I regularly create videos
- 0:44about artificial intelligence on my
- 0:45YouTube channel. So do subscribe and
- 0:47click the bell icon to stay tuned and
- 0:49make sure you click the like button so
- 0:50this video can be helpful for many
- 0:52others like you. Round one is Claude
- 0:54sheets, a spreadsheet that Claude builds
- 0:56and edits with you. [music]
- 0:58Here's how you use it step by step.
- 1:00Step one, in Claude, open artifacts and
- 1:04click the sheets tile.
- 1:05Step two, pick Fable 5.2 from the model
- 1:08menu under the chat box.
- 1:10Step three, click import from Excel and
- 1:13choose your file.
- 1:14I used public sales data from Montgomery
- 1:16County, Maryland with over 4,000 rows.
- 1:20Step four, send the message it writes
- 1:23for you, then read the reply. My file
- 1:26had 120 formulas, the sums that update
- 1:29when your data changes. Claude kept
- 1:31everyone working,
- 1:33but it told me it lost the chart, the
- 1:35dropdown, and the color rules. Step
- 1:38five, ask for one thing at a time
- 1:40[music] in plain words. I asked for a
- 1:43summary by a month, then a dropdown, a
- 1:45lookup, and a chart. I never said the
- 1:48word formulas, but it used formulas
- 1:50anyway.
- 1:51Step six, [music] click a total and the
- 1:53bar at the top shows its formula and
- 1:57every key number matched my own
- 2:00worked out beforehand.
- 2:01Step seven, change the dropdown and the
- 2:04totals and the chart change with it.
- 2:06Step eight, [music]
- 2:07open the title menu, click export and
- 2:10pick Excel.
- 2:11It warns you that three things are
- 2:13different in Excel, like the color
- 2:15rules. In my exported file, the totals
- 2:18moved when I changed a number.
- 2:21To be fair, Microsoft's own Copilot in
- 2:24Excel does similar work and it can use
- 2:26Claude models too.
- 2:28So for a light shared sheet you build in
- 2:30a chat, Claude Sheets works, but check
- 2:32what it drops. Round two is the
- 2:34whiteboard, a shared board where you
- 2:37brainstorm with Claude. Step one, open
- 2:40Artifacts again and click the whiteboard
- 2:42tile.
- 2:43Step two, pick Fable 512 from the model
- 2:46menu.
- 2:47Step three, type your plan in plain
- 2:49words or say it with the microphone.
- 2:52I typed a short plan for the game I
- 2:54build later and sent it.
- 2:56In about 70 seconds, it drew a plan in
- 2:59four phases with dates and a color for
- 3:02who does what. Step four, click Expand
- 3:06[music] to see the whole board. One
- 3:08catch, you can save a board only as a
- 3:10picture. So for a quick project plan,
- 3:12you get a first board in about a minute.
- 3:15To build the app and the game, I used
- 3:17Abacus AI.
- 3:18Abacus AI has an agent that builds and
- 3:20edits whole web apps from a prompt. In
- 3:23its max mode, every app building prompt
- 3:26goes [music] to Claude Fable 512.
- 3:29Max mode uses the most credits of any
- 3:31mode, so you'd keep it for the jobs that
- 3:33matter most. On its homepage, you can
- 3:36see the kinds of apps you can build from
- 3:38websites to phone apps. Each app gets a
- 3:41login and a database built in. You
- 3:44preview it first, then deploy it when
- 3:46you're happy.
- 3:47You can roll back to an earlier version
- 3:50and put it on your own domain.
- 3:52The link is in the description. Round
- 3:54three is a real app built in Abacus with
- 3:57Fable 512. I asked for a task board for
- 4:00a small team with a login, a database,
- 4:04and an [music] AI button.
- 4:05In my one run, it took about 15 minutes
- 4:09and it needed no follow-up messages from
- 4:10me.
- 4:11Then I tested it the way your team
- 4:13[music] would use it.
- 4:14Sign up and log in worked and a card I
- 4:17moved to done stayed there after a
- 4:19reload. The AI button turned one goal
- 4:22into five task cards in a few [music]
- 4:24seconds
- 4:25and a second test account was kept out
- 4:27of my board.
- 4:28But it missed one thing. It never checks
- 4:30that your email address is real. A
- 4:32made-up address became a working account
- 4:35[music] at once. So it's a solid first
- 4:38version, but ask for email checks before
- 4:41real people use it.
- 4:43Round four is a game built in Abacus
- 4:45with the same max mode.
- 4:47I asked for a full brick breaker game
- 4:50you can play in a browser from one
- 4:51prompt.
- 4:52In my one run, it took about three
- 4:55minutes with no follow-up messages from
- 4:57me.
- 4:58Then a script ran five checks on it.
- 5:01Does it load? Do the controls work? Does
- 5:03the score go up? Can you lose? And does
- 5:06it restart?
- 5:07It passed all five checks.
- 5:09Here it is running.
- 5:11You can see it reached 210 points in 42
- 5:14seconds. [music] Then the ball drops
- 5:16three times. It's game over and one key
- 5:20starts a fresh game. So if you want a
- 5:22small game, you can play today. One
- 5:24prompt is enough. Round five is about
- 5:27effort and what it costs you on a plan.
- 5:30Effort is how much thinking Claude puts
- 5:32into each answer. More effort means more
- 5:34careful work, but it takes longer and
- 5:37uses more of your plan.
- 5:39Medium is the default includes apps and
- 5:41includes code.
- 5:43So I gave the same game prompt to Claude
- 5:45code Anthropic's coding app on my own
- 5:48Claude plan.
- 5:49I ran it once at each level medium,
- 5:51high, and max on the same machine with
- 5:54the same prompt. Your plan has a usage
- 5:57meter that refills every five hours and
- 6:01I read mine before and after each run.
- 6:04Medium finished in about 70 seconds and
- 6:06used three points of that meter. High
- 6:09took over six minutes, six points.
- 6:12Max run for 40 minutes and I stopped
- 6:14[music] it because it never said it was
- 6:16done. One of its answers thought for 22
- 6:19minutes, hit its length limit and wrote
- 6:21nothing. [music]
- 6:22Max used 26 points
- 6:24and all three games passed all five
- 6:26checks from round four.
- 6:27So Max used about nine times medium's
- 6:30share for the same result.
- 6:32At list price, that's 32 cents against
- 6:35$5.90, but my plan charged nothing
- 6:38extra.
- 6:39One run each, so take these as a guide.
- 6:42Then I typed the three results into a
- 6:43Claude sheet.
- 6:45Claude made the table and the chart. It
- 6:47worked out the share per check about
- 6:500.6, 1.2, and 5.2%.
- 6:54So for a job like this, medium is enough
- 6:57and you'll save your plan for other
- 6:59work.
- 7:00So here's the score. Five real jobs from
- 7:03the Excel file to the game and Claude
- 7:05got all five done. Each one came with a
- 7:08catch. You've seen them all. [music] Is
- 7:11Excel dead? No. Despite what the launch
- 7:13suggests, Claude is a starting point,
- 7:16not a replacement for Excel.
- 7:18Here's where Claude already wins and
- 7:21where Excel still wins.
- 7:23Claude wins when you want a fast first
- 7:25version. From one prompt each, [music]
- 7:28you get a working sheet with live
- 7:29formulas, a plan board, an app, and a
- 7:32game.
- 7:33Excel still wins [music] when you need
- 7:35the full set of features and that's
- 7:37Anthropic's own view.
- 7:39A Claude sheet has no pivot tables or
- 7:42macros yet
- 7:43and my chart dropped down and colors got
- 7:45lost on the way in. [music] In one
- 7:47survey, 96% of finance planners still
- 7:50use spreadsheets to plan.
- 7:52So I think Claude is better than Excel
- 7:55for a quick first draft and worse for
- 7:57the finished [music] fall.
- 7:59Here's the short version for you. Claude
- 8:01now has its own spreadsheet [music] and
- 8:03whiteboard, but Anthropic still sends
- 8:06you to Excel for the full job. In
- 8:08Abacus, Fable 5.2 built a working app
- 8:11from one prompt, but it never checked
- 8:14email addresses. [music] And the game
- 8:15you saw it build there passed all five
- 8:18checks from one prompt. On effort,
- 8:21medium is all you need. Max used about
- 8:23nine times the share for the same
- 8:25result. Do let me know in the comments
- 8:27below what you think about this.
- 8:29Considering you already like this video,
- 8:31you might also like the video shown
- 8:33above. I'll see you there.
About this transcript
This page contains the full transcript of Claude Sheets Just Took On Excel. I REALLY Tested It by Mervin Praison, generated from the public captions YouTube serves with the video. The transcript has 1,454 words across 227 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.
What you can do with it
Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.
Free YouTube transcript tool
YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.