Latest / Ctrl AI Profit / Ep. 277 | Claude Can Hand Back a Finished Spreadsheet From One Ask
Transcript
- 0:20SPEAKER_01: You ask Claude for a tracker.
- 0:21SPEAKER_01: It gives you a nice table in the chat.
- 0:24SPEAKER_01: And then you spend 20 minutes pasting it into a blank workbook and rebuilding every formula by hand.
- 0:31SPEAKER_00: There's a better ask.
- 0:33SPEAKER_00: Claude can hand back a finished Excel file with working formulas that you download and open in Excel or Google Sheets.
- 0:41SPEAKER_01: By the end of this one, you'll know the setting to check, the three parts of the ask, two prompts to copy, and what to do when you get a table instead of a file.
- 0:51SPEAKER_00: The one new term is file creation.
- 0:54SPEAKER_00: Plain English, please.
- 0:56SPEAKER_00: File creation means Claude writes and runs code in its own private workspace and builds an actual file.
- 1:03SPEAKER_00: Excel, Word, PowerPoint, or PDF.
- 1:06SPEAKER_00: It shows up in the conversation with a download button.
- 1:10SPEAKER_00: Not a table you copy, a file you keep.
- 1:13SPEAKER_00: Who gets it?
- 1:14SPEAKER_00: Is this paid only?
- 1:16SPEAKER_00: Claude Help says code execution and file creation is available on every plan.
- 1:21SPEAKER_00: Free, Pro, Max, Ultra Team, and Enterprise.
- 1:25SPEAKER_00: On the web, Claude Desktop, and the mobile app.
- 1:29SPEAKER_00: On Free, Pro, Max, and Ultra, it's on by default.
- 1:34SPEAKER_00: And if it's not on?
- 1:36SPEAKER_00: Step one.
- 1:37SPEAKER_00: Open settings, then capabilities.
- 1:40SPEAKER_00: Find the toggle called Code, Execution, and File Creation.
- 1:44SPEAKER_00: In the updated settings layout, that same toggle is called Create and Edit Files.
- 1:49SPEAKER_00: Turn it on.
- 1:50SPEAKER_00: On Team or Enterprise, an organization owner controls it.
- 1:54SPEAKER_00: So ask them if it's missing.
- 1:56SPEAKER_00: What about on the phone?
- 1:58SPEAKER_00: Tap your initials or your name in the left sidebar to open settings, choose capabilities, and switch code execution and file creation on.
- 2:06SPEAKER_00: Step two is where you type.
- 2:08SPEAKER_00: The docs describe two different screens right now.
- 2:12SPEAKER_00: Look at your message box.
- 2:14SPEAKER_00: If you still see chat and cowork options, a regular chat can build a spreadsheet.
- 2:19SPEAKER_00: Co-work, on paid plans, is the pick for a bigger multi-step job, like a folder full of receipts.
- 2:26SPEAKER_00: If those options are gone, you have the new Claude experience.
- 2:30SPEAKER_00: There's no mode to pick.
- 2:32SPEAKER_00: You just ask in any conversation.
- 2:35SPEAKER_01: Step three is the ask itself.
- 2:38SPEAKER_01: What goes in it?
- 2:39SPEAKER_00: Claude help says brief it like a colleague in three parts.
- 2:43SPEAKER_00: The outcome, what you want to end up with, like a spreadsheet with a tab for each region.
- 2:48SPEAKER_00: The format, say Excel spreadsheet, right in the prompt, and the inputs, the numbers, files, or apps Claude should work from.
- 2:58SPEAKER_01: Why does saying Excel matter so much?
- 3:02SPEAKER_00: Claude Academy warns that if you don't name a file format, Claude may make an artifact instead.
- 3:08SPEAKER_00: Which is something you edit inside Claude.
- 3:11SPEAKER_00: If you want the workbook, name the workbook.
- 3:14SPEAKER_00: Give me the first prompt word for word.
- 3:17SPEAKER_00: Straight from Claude Help.
- 3:18SPEAKER_00: Quote, create a monthly budget tracker with income, expense categories, and automatic calculations for savings.
- 3:25SPEAKER_00: End quote.
- 3:26SPEAKER_00: Help says you get an Excel file with proper formulas, formatting, and even charts.
- 3:31SPEAKER_01: That's a little generic for a small business.
- 3:34SPEAKER_01: How do I tighten it?
- 3:35SPEAKER_00: Add your structure.
- 3:37SPEAKER_00: Something like this.
- 3:38SPEAKER_00: Create an Excel spreadsheet to track monthly expenses.
- 3:42SPEAKER_00: Columns for date, vendor, category, amount, and who paid.
- 3:48SPEAKER_00: Categories are fuel, supplies, payroll, rent, and other.
- 3:53SPEAKER_00: Add a totals tab that sums each category by month using formulas, not type numbers.
- 3:59SPEAKER_00: Then what shows up on screen?
- 4:02SPEAKER_00: Claude works for a bit and you'll see it planning and running steps.
- 4:05SPEAKER_00: Then the file appears in the conversation.
- 4:08SPEAKER_00: Click download or save it straight to Google Drive.
- 4:11SPEAKER_00: On mobile, tapping download opens it in the system preview or a separate app.
- 4:15SPEAKER_01: Step four is the receipt check.
- 4:18SPEAKER_01: How do I know I got the real thing?
- 4:21SPEAKER_00: Open it in Excel or Sheets and click a total cell.
- 4:25SPEAKER_00: You should see a formula, like a sum, in the formula bar, not a plain number.
- 4:31SPEAKER_00: Change one amount and watch the total move.
- 4:34SPEAKER_00: If it moves, file creation worked.
- 4:37SPEAKER_00: Second worked example, receipts.
- 4:40SPEAKER_00: Co-Works Get Started page lists it.
- 4:43SPEAKER_00: Drop receipts in a folder and ask Claude to create a formatted expense report.
- 4:47SPEAKER_00: In a regular chat, upload the receipt PDFs or photos instead.
- 4:51SPEAKER_00: Then ask, turn these receipts into an Excel expense spreadsheet, one row per receipt with date, vendor, category, and total, plus a summary tab by category.
- 5:04SPEAKER_01: People are doing exactly this on X.
- 5:07SPEAKER_00: They are.
- 5:08SPEAKER_00: NoCo XYZ described a first cowork session that turned receipts into an expense sheet, and M underscore Shrishti described logging bills into a spreadsheet to sort and analyze spending.
- 5:19SPEAKER_00: Both match the official examples.
- 5:22SPEAKER_00: What's the gotcha with receipts?
- 5:25SPEAKER_00: Reading numbers off a photo can go wrong.
- 5:28SPEAKER_00: People are reporting a smart fix.
- 5:30SPEAKER_00: One post from AI Elite Thinkers described a CPA asking for an Excel schedule with a column that links back to each original receipt.
- 5:38SPEAKER_00: Steal that.
- 5:40SPEAKER_00: Include a column with the source file name for every row, then spot check a few rows against the paper.
- 5:46SPEAKER_01: What if it's a PDF statement that already has a table in it?
- 5:51SPEAKER_00: Help has a prompt for that too.
- 5:53SPEAKER_00: Quote, extract all the data from this PDF into an Excel spreadsheet and create a summary chart.
- 6:00SPEAKER_00: End quote.
- 6:01SPEAKER_00: Now the limits.
- 6:02SPEAKER_00: What trips people up?
- 6:03SPEAKER_00: Size first.
- 6:04SPEAKER_00: The max is 30 megabytes per file for uploads and downloads.
- 6:08SPEAKER_00: Split a giant export before you upload it.
- 6:11SPEAKER_00: And usage?
- 6:13SPEAKER_00: Help says creating files uses more of your plan's limit than a normal chat.
- 6:17SPEAKER_00: Check settings.
- 6:19SPEAKER_00: Then usage.
- 6:20SPEAKER_00: Put related work into one ask instead of five small ones.
- 6:24SPEAKER_01: Anything that just won't work.
- 6:27SPEAKER_00: Two from help.
- 6:28SPEAKER_00: In the new experience, incognito chats open in the older experience, so Claude can't create files there.
- 6:35SPEAKER_00: And after Claude uses linked accounts and personal finance in a chat, it may not be able to make an Excel file in that same chat.
- 6:43SPEAKER_00: Start a fresh conversation for the spreadsheet.
- 6:46SPEAKER_00: And if the first file isn't quite right.
- 6:51SPEAKER_00: Stay in the same conversation.
- 6:53SPEAKER_00: And say what to change.
- 6:55SPEAKER_00: Add a tab, rename a column, fix a category.
- 6:58SPEAKER_00: Files stay available to download throughout the conversation, so grab the new version when it's done.
- 7:04SPEAKER_00: Any safety note?
- 7:06SPEAKER_00: Claude help says monitor Claude while it works, and stop it if you see it using or accessing data unexpectedly.
- 7:13SPEAKER_00: Report problems with the thumbs down.
- 7:16SPEAKER_00: And on Free, Pro, Max, and Ultra, conversations that include these files can't be shared publicly.
- 7:23SPEAKER_00: Okay, one thing to try this week.
- 7:26SPEAKER_00: Pick the tracker you rebuild by hand every month.
- 7:29SPEAKER_00: Open Claude, check that file creation is on, and send one ask with the outcome, the words Excel spreadsheet, and your numbers.
- 7:37SPEAKER_00: Download it, click a total, and confirm you see a formula.
- 7:41SPEAKER_01: And if you get a table in chat instead of a file, add the words Excel spreadsheet and ask again.
- 7:48SPEAKER_01: Thanks for listening to Control AI Profit.
- 7:50SPEAKER_01: If this saved you a rebuild, send it to someone who still copies tables out of chat.
- 7:56SPEAKER_01: Thanks everybody.
- 7:57SPEAKER_01: We'll see you next time.