How to search inside Excel files and across many spreadsheets
Updated 20 October 2026
There are two different jobs here. To find a value inside one workbook, use Excel’s own Find: press Ctrl+F, click Options and set Within to Workbook. To find which of many spreadsheets contains a value, search the folder instead. On Windows, type ext:.xlsx content:"your value" into File Explorer’s search box. On a Mac, search the folder with Spotlight or mdfind. Excel’s Find only offers a sheet or one workbook as its scope, so it cannot search a folder of files for you.
1. Find a value inside one workbook
This is the part Excel already does well, and the options are worth knowing:
- Press Ctrl+F and select Options >> to open the full dialog.
- Within takes Sheet or Workbook. Choose Workbook to search every sheet instead of the one you are looking at.
- Look in takes Formulas, Values, Notes or Comments. If a figure is the result of a formula, try Values as well as Formulas.
- Match entire cell contents restricts the search to cells that contain only the characters you typed in the Find what box.
- Wildcard characters (?, * and ~) work in the search text, so you can match a pattern instead of one exact value. Select Find All or Find Next to run the search.
The limit is the scope. The dialog’s choices are one sheet or one workbook, so when you do not know which file holds the value, you need to search the files themselves.
2. Windows: find which spreadsheet contains a value
Open the top folder in File Explorer, click the search box and use the content: operator together with an extension filter. Search covers that folder and everything below it.
ext:.xlsx content:"1450"finds Excel workbooks containing 1450.(ext:.xlsx OR ext:.xls OR ext:.csv) content:"budget"covers older workbooks and CSV exports in the same search. OR, AND and NOT only work as operators when they are in capital letters.- A single word matches words that start with it, so
content:budgetalso finds “budgets”. A phrase in quotes matches those words together, in that order.
Why extensions and not a spreadsheet filter? Windows has a kind: filter, but its list of kinds (document, picture, music, video and so on) has no spreadsheet entry and Microsoft documents it as not extensible. We checked on Windows 11 Pro 25H2 (build 26200): kind:spreadsheet is read as an ordinary word to find, not as a filter. The keywords are in your display language: Microsoft documents that Windows Search recognizes keywords in the current display language only, so on a PC set to another language use that language’s words.
Windows has content filters for Excel files and reads plain text and .csv directly, so text in cells is searchable once the file sits in an indexed location. By default that means Documents, Pictures, Music and the desktop (Classic mode); under Settings → Privacy & security → Searching Windows you can switch to Enhanced to cover the whole PC. If the file is found by name but not by its contents, check Indexing Options → Advanced → File Types and make sure the extension is set to index properties and file contents. Our Windows guide has the full picture.
A practical note on numbers: they are the hardest thing to search for, because a cell can display a figure in a format different from how you remember it. If the figure alone returns too much or too little, add a word from the same row, such as a customer name or a column heading.
3. Mac: Spotlight, Finder and mdfind
Spotlight indexes the text inside many file types and matches it literally. In Terminal, mdfind -onlyin ~/Documents "budget" searches one folder and everything below it using the same index. Apple’s list of Finder search keywords covers PDFs and presentations but has no spreadsheet entry, so search by the words and let -onlyin do the narrowing. Before you rely on it, test it: search for a distinctive word you know is inside one of your spreadsheets and see whether that file comes up.
4. Where built-in search stops
Spreadsheets are mostly labels and numbers. A literal search needs the exact label, so “budget” will not find a sheet titled “Presupuesto anual”, and an English word will not match a column heading in another language.
File names rarely help. Files called Book1.xlsx, Untitled spreadsheet.xlsx or final_v2.xlsx tell you nothing, and the sheet inside may be the only place the topic is named.
A scanned or photographed printout is a picture. If a table only exists as an image of a page, no spreadsheet search reaches it. That needs OCR, covered in how to search scanned PDFs and text in screenshots.
5. When you need more: one box for every spreadsheet
BeaconFind reads .xlsx, .xls, .ods and .csv along with 70+ other file types, so a value in a sheet is searchable from the same box as your documents and PDFs. You press Ctrl+K on Windows and type what you remember. It matches by meaning and by exact words, and it understands 50+ languages, so an English search for “annual budget” can surface a Spanish sheet called “presupuesto anual”, and “the sheet where we split the bills” can find a workbook that is literally named Untitled spreadsheet.
Select a result and the spreadsheet renders in the panel beside the list, with its sheets, so you can confirm it is the right workbook before you open it. Your files, their contents and your searches stay on your computer. The app does contact our server for two things, a licence check and an update check, and both can be blocked by a firewall without affecting search.
Search every spreadsheet you own from one box. Free for 14 days, no card needed. Windows 10 and 11, and Macs with Apple Silicon.
Download BeaconFindWhich method should you use?
| Your situation | Use this |
|---|---|
| The value is in the workbook that is open | Excel’s Find, with Within set to Workbook |
| Which workbook has it, files in Documents (Windows) | File Explorer with ext:.xlsx content: |
| Files on another drive | Switch Windows to Enhanced first |
| A Mac | Spotlight or mdfind -onlyin, tested on a sheet you know |
| You remember the topic, not the label | Semantic search |
| The sheet is in another language | Cross-language search |
Frequently asked questions
How do I search for a value across multiple Excel files?
Search the folder, not the workbook. On Windows, open the folder in File Explorer and type ext:.xlsx content:"your value". On a Mac, use Spotlight or mdfind -onlyin on the folder and check it works with a word you know is in a sheet. Excel's own Find only covers a sheet or one workbook, so it cannot tell you which file holds the value.
Can Excel's Find search several workbooks at once?
The Find and Replace dialog offers two scopes in its Within box, a sheet or the entire workbook, and Microsoft's documentation describes nothing wider. To find which workbook holds a value, search the files with File Explorer, Finder or an indexing tool, then open the one you find.
How do I search every sheet inside one workbook?
Press Ctrl+F, click Options, and set Within to Workbook. Look in then picks what to match: Formulas, Values, Notes or Comments. Select Find All or Find Next to run the search.
Why does File Explorer find my spreadsheet by name but not by what is inside it?
Usually the file is outside an indexed location, so only its name is searched, or the file type is set to index properties only. Numbers are also the least reliable thing to search for, because the same figure can be displayed in more than one way, so try a word from the same row as well.
Can I search .csv files too?
Yes. A CSV file is plain text, and Windows reads plain text and .csv directly, so content: finds words inside them without any extra setup beyond the folder being indexed.
Does BeaconFind read Apple Numbers files?
No. The spreadsheet types it reads are .xlsx, .xls, .ods and .csv.