YouTube2Text

Claude Sheets Just Took On Excel. I REALLY Tested It — Transcript

by Mervin Praison · 1,454 words · 227 segments · language en · Watch on YouTube

Full transcript

  1. 0:00Claude just took on Excel and one prompt
  2. 0:02built this game in about three minutes.
  3. 0:04Anthropic put its own spreadsheet and
  4. 0:06whiteboard inside Claude for every paid
  5. 0:09user.
  6. 0:10That's a shot at a tool behind over 450
  7. 0:13million Microsoft 365 business seats.
  8. 0:17But even Anthropic says you'll still
  9. 0:19need Excel.
  10. 0:20So I gave Claude five real jobs from an
  11. 0:23Excel file to a game and kept score.
  12. 0:26[music]
  13. 0:26Every test is on camera.
  14. 0:28By the end of this video, you'll learn
  15. 0:30Claude sheets step by step. You'll learn
  16. 0:33Claude's whiteboard step by step. You'll
  17. 0:35see a app and a game from Fable 5 to the
  18. 0:38new model and you'll learn when you
  19. 0:40still need [music] Excel.
  20. 0:42Before that, I regularly create videos
  21. 0:44about artificial intelligence on my
  22. 0:45YouTube channel. So do subscribe and
  23. 0:47click the bell icon to stay tuned and
  24. 0:49make sure you click the like button so
  25. 0:50this video can be helpful for many
  26. 0:52others like you. Round one is Claude
  27. 0:54sheets, a spreadsheet that Claude builds
  28. 0:56and edits with you. [music]
  29. 0:58Here's how you use it step by step.
  30. 1:00Step one, in Claude, open artifacts and
  31. 1:04click the sheets tile.
  32. 1:05Step two, pick Fable 5.2 from the model
  33. 1:08menu under the chat box.
  34. 1:10Step three, click import from Excel and
  35. 1:13choose your file.
  36. 1:14I used public sales data from Montgomery
  37. 1:16County, Maryland with over 4,000 rows.
  38. 1:20Step four, send the message it writes
  39. 1:23for you, then read the reply. My file
  40. 1:26had 120 formulas, the sums that update
  41. 1:29when your data changes. Claude kept
  42. 1:31everyone working,
  43. 1:33but it told me it lost the chart, the
  44. 1:35dropdown, and the color rules. Step
  45. 1:38five, ask for one thing at a time
  46. 1:40[music] in plain words. I asked for a
  47. 1:43summary by a month, then a dropdown, a
  48. 1:45lookup, and a chart. I never said the
  49. 1:48word formulas, but it used formulas
  50. 1:50anyway.
  51. 1:51Step six, [music] click a total and the
  52. 1:53bar at the top shows its formula and
  53. 1:57every key number matched my own
  54. 2:00worked out beforehand.
  55. 2:01Step seven, change the dropdown and the
  56. 2:04totals and the chart change with it.
  57. 2:06Step eight, [music]
  58. 2:07open the title menu, click export and
  59. 2:10pick Excel.
  60. 2:11It warns you that three things are
  61. 2:13different in Excel, like the color
  62. 2:15rules. In my exported file, the totals
  63. 2:18moved when I changed a number.
  64. 2:21To be fair, Microsoft's own Copilot in
  65. 2:24Excel does similar work and it can use
  66. 2:26Claude models too.
  67. 2:28So for a light shared sheet you build in
  68. 2:30a chat, Claude Sheets works, but check
  69. 2:32what it drops. Round two is the
  70. 2:34whiteboard, a shared board where you
  71. 2:37brainstorm with Claude. Step one, open
  72. 2:40Artifacts again and click the whiteboard
  73. 2:42tile.
  74. 2:43Step two, pick Fable 512 from the model
  75. 2:46menu.
  76. 2:47Step three, type your plan in plain
  77. 2:49words or say it with the microphone.
  78. 2:52I typed a short plan for the game I
  79. 2:54build later and sent it.
  80. 2:56In about 70 seconds, it drew a plan in
  81. 2:59four phases with dates and a color for
  82. 3:02who does what. Step four, click Expand
  83. 3:06[music] to see the whole board. One
  84. 3:08catch, you can save a board only as a
  85. 3:10picture. So for a quick project plan,
  86. 3:12you get a first board in about a minute.
  87. 3:15To build the app and the game, I used
  88. 3:17Abacus AI.
  89. 3:18Abacus AI has an agent that builds and
  90. 3:20edits whole web apps from a prompt. In
  91. 3:23its max mode, every app building prompt
  92. 3:26goes [music] to Claude Fable 512.
  93. 3:29Max mode uses the most credits of any
  94. 3:31mode, so you'd keep it for the jobs that
  95. 3:33matter most. On its homepage, you can
  96. 3:36see the kinds of apps you can build from
  97. 3:38websites to phone apps. Each app gets a
  98. 3:41login and a database built in. You
  99. 3:44preview it first, then deploy it when
  100. 3:46you're happy.
  101. 3:47You can roll back to an earlier version
  102. 3:50and put it on your own domain.
  103. 3:52The link is in the description. Round
  104. 3:54three is a real app built in Abacus with
  105. 3:57Fable 512. I asked for a task board for
  106. 4:00a small team with a login, a database,
  107. 4:04and an [music] AI button.
  108. 4:05In my one run, it took about 15 minutes
  109. 4:09and it needed no follow-up messages from
  110. 4:10me.
  111. 4:11Then I tested it the way your team
  112. 4:13[music] would use it.
  113. 4:14Sign up and log in worked and a card I
  114. 4:17moved to done stayed there after a
  115. 4:19reload. The AI button turned one goal
  116. 4:22into five task cards in a few [music]
  117. 4:24seconds
  118. 4:25and a second test account was kept out
  119. 4:27of my board.
  120. 4:28But it missed one thing. It never checks
  121. 4:30that your email address is real. A
  122. 4:32made-up address became a working account
  123. 4:35[music] at once. So it's a solid first
  124. 4:38version, but ask for email checks before
  125. 4:41real people use it.
  126. 4:43Round four is a game built in Abacus
  127. 4:45with the same max mode.
  128. 4:47I asked for a full brick breaker game
  129. 4:50you can play in a browser from one
  130. 4:51prompt.
  131. 4:52In my one run, it took about three
  132. 4:55minutes with no follow-up messages from
  133. 4:57me.
  134. 4:58Then a script ran five checks on it.
  135. 5:01Does it load? Do the controls work? Does
  136. 5:03the score go up? Can you lose? And does
  137. 5:06it restart?
  138. 5:07It passed all five checks.
  139. 5:09Here it is running.
  140. 5:11You can see it reached 210 points in 42
  141. 5:14seconds. [music] Then the ball drops
  142. 5:16three times. It's game over and one key
  143. 5:20starts a fresh game. So if you want a
  144. 5:22small game, you can play today. One
  145. 5:24prompt is enough. Round five is about
  146. 5:27effort and what it costs you on a plan.
  147. 5:30Effort is how much thinking Claude puts
  148. 5:32into each answer. More effort means more
  149. 5:34careful work, but it takes longer and
  150. 5:37uses more of your plan.
  151. 5:39Medium is the default includes apps and
  152. 5:41includes code.
  153. 5:43So I gave the same game prompt to Claude
  154. 5:45code Anthropic's coding app on my own
  155. 5:48Claude plan.
  156. 5:49I ran it once at each level medium,
  157. 5:51high, and max on the same machine with
  158. 5:54the same prompt. Your plan has a usage
  159. 5:57meter that refills every five hours and
  160. 6:01I read mine before and after each run.
  161. 6:04Medium finished in about 70 seconds and
  162. 6:06used three points of that meter. High
  163. 6:09took over six minutes, six points.
  164. 6:12Max run for 40 minutes and I stopped
  165. 6:14[music] it because it never said it was
  166. 6:16done. One of its answers thought for 22
  167. 6:19minutes, hit its length limit and wrote
  168. 6:21nothing. [music]
  169. 6:22Max used 26 points
  170. 6:24and all three games passed all five
  171. 6:26checks from round four.
  172. 6:27So Max used about nine times medium's
  173. 6:30share for the same result.
  174. 6:32At list price, that's 32 cents against
  175. 6:35$5.90, but my plan charged nothing
  176. 6:38extra.
  177. 6:39One run each, so take these as a guide.
  178. 6:42Then I typed the three results into a
  179. 6:43Claude sheet.
  180. 6:45Claude made the table and the chart. It
  181. 6:47worked out the share per check about
  182. 6:500.6, 1.2, and 5.2%.
  183. 6:54So for a job like this, medium is enough
  184. 6:57and you'll save your plan for other
  185. 6:59work.
  186. 7:00So here's the score. Five real jobs from
  187. 7:03the Excel file to the game and Claude
  188. 7:05got all five done. Each one came with a
  189. 7:08catch. You've seen them all. [music] Is
  190. 7:11Excel dead? No. Despite what the launch
  191. 7:13suggests, Claude is a starting point,
  192. 7:16not a replacement for Excel.
  193. 7:18Here's where Claude already wins and
  194. 7:21where Excel still wins.
  195. 7:23Claude wins when you want a fast first
  196. 7:25version. From one prompt each, [music]
  197. 7:28you get a working sheet with live
  198. 7:29formulas, a plan board, an app, and a
  199. 7:32game.
  200. 7:33Excel still wins [music] when you need
  201. 7:35the full set of features and that's
  202. 7:37Anthropic's own view.
  203. 7:39A Claude sheet has no pivot tables or
  204. 7:42macros yet
  205. 7:43and my chart dropped down and colors got
  206. 7:45lost on the way in. [music] In one
  207. 7:47survey, 96% of finance planners still
  208. 7:50use spreadsheets to plan.
  209. 7:52So I think Claude is better than Excel
  210. 7:55for a quick first draft and worse for
  211. 7:57the finished [music] fall.
  212. 7:59Here's the short version for you. Claude
  213. 8:01now has its own spreadsheet [music] and
  214. 8:03whiteboard, but Anthropic still sends
  215. 8:06you to Excel for the full job. In
  216. 8:08Abacus, Fable 5.2 built a working app
  217. 8:11from one prompt, but it never checked
  218. 8:14email addresses. [music] And the game
  219. 8:15you saw it build there passed all five
  220. 8:18checks from one prompt. On effort,
  221. 8:21medium is all you need. Max used about
  222. 8:23nine times the share for the same
  223. 8:25result. Do let me know in the comments
  224. 8:27below what you think about this.
  225. 8:29Considering you already like this video,
  226. 8:31you might also like the video shown
  227. 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.