Excel

Discussion related to "Everything" 1.5 Alpha.
Post Reply
demoniak61
Posts: 16
Joined: Thu Nov 03, 2022 4:21 pm

Excel

Post by demoniak61 »

Hello,
I don't know if this question has already been addressed.

Is it (or would it be) possible to search in an Excel file?
NotNull
Posts: 5458
Joined: Wed May 24, 2017 9:22 pm

Re: Excel

Post by NotNull »

Yes, that is possible. Provided that the right software to read these files is installed.
Basically: If Excel is installed, Everything can read the content of these files.
void
Developer
Posts: 16665
Joined: Fri Oct 16, 2009 11:31 pm

Re: Excel

Post by void »

To search file content, please try the content: search function.

For example, to search for the content "abc 123" in xlsx files, modified this year, search for:
ext:xlsx dm:thisyear content:"abc 123"

Note: File content is not indexed. Searching file content will be very slow.
For the best performance, combine the content: search with other search filters.

Please try the Advanced Search under the search menu and set the "A word or phrase in the file" field.
For the best performance, set as many fields in the Advanced Search as possible.
demoniak61
Posts: 16
Joined: Thu Nov 03, 2022 4:21 pm

Re: Excel

Post by demoniak61 »

Thank you for your answers. Using your search method, the software does indeed return xslx files with this content, but isn't it possible to display the lines contained in this file?
For example, I'm looking for the contents "abc123", and I'd like the excel boxes with this content (the whole text) to appear in the search result.
void
Developer
Posts: 16665
Joined: Fri Oct 16, 2009 11:31 pm

Re: Excel

Post by void »

Everything will only list the file that contains the text.

You will need to open the file in Excel to find the matching line.

Showing the matching line in Everything in the preview pane is on my TODO list.
Post Reply