Learn to use AI at work, with Claude. Yes, at your 9-to-5 desk job. Free in the 9-5 Survivors Lab

Ask Flex / Excel and AI

Ask Flex

How do you use AI to create an Excel spreadsheet?

"How do I use AI to create an Excel spreadsheet? I need a tracker and I'm staring at a blank grid."You asked Google. Flex answered.
Flex the robot at his sunny office desk scratching his head at a big spreadsheet on his screen where one cell flashes a red error, while little Clawd peeks out from behind the monitor holding up a sticky note with an equals sign on it
Flex's short answer

Tell the AI what you're tracking and what you want to see at the end, and it lays out the columns, the formulas, and a few example rows. Claude can hand you a real Excel file to download, or you can copy the layout into a blank sheet yourself.

✱ Flex's tips

Start with what you want to see.

1

Start with the end

"I want to see what's overdue."

2

List what you track

One column per thing.

3

Ask for example rows

Made-up ones, so you can see it work.

4

Ask what each formula does

You'll be the one fixing it in June.

Try this in your own Claude or ChatGPT

Make me a spreadsheet to track [what you're tracking]. At a glance I want to see [what matters most, like what's overdue or the monthly total]. Suggest the columns, add the formulas, and fill in three made-up example rows. If you can, give it to me as an Excel file to download. Then explain each formula in one line.

Before you paste work stuff into any AI, check what your company allows.
Free tool

The Formula Finder

Pick what you're trying to do, in plain words. Get the formula, what it means, and how to check it.

Find my formula
Flex the robot at his sunny office desk scratching his head at a big spreadsheet on his screen where one cell flashes a red error, while little Clawd peeks out from behind the monitor holding up a sticky note with an equals sign on it
Inside the Lab

Learn this in the Lab, free

A free group where you learn to use Claude for the repeat parts of your job: email, reports, forms. Start with a 15-minute chat that maps what Claude can do in your job.

  • Free
  • No coding
  • Works in Claude
Start free on Skool
✱ What people ask
Can AI create an Excel spreadsheet with formulas?

Yes. Ask for the formulas, and for one line on what each does.

Can ChatGPT create Excel files?

OpenAI's help page says it depends on your plan and settings. If it can't, it gives you the layout to copy.

Is there an AI Google Sheets template generator?

Any chat AI can lay one out. Ask for the columns and formulas, then paste them into a blank sheet. Flex has a page on it.

✱ More from this pile: Excel and AI
How do you use AI in Excel?How do you use AI in Excel for free?Can AI do Excel formulas?Is there an AI Excel formula checker?How do you use AI in Excel for data analysis?What is ChatGPT for Excel?Does Claude AI work with Excel?How do you use AI in Excel with Copilot?Is there AI for Google Sheets?How do you use AI to automate Excel?Is it worth it to learn Excel?What are the best ChatGPT prompts for Excel? The Formula Finder
From Nikki's blogFlex tells you how. Nikki tells you what it felt like. Read it on Clawd and Me. Read it →

Want to hand this to Claude?

Start in the Lab with the free 9-to-5 Job Triage: a 15-minute chat that maps what Claude can do in your job. Everything inside is free.

Start free on Skool