Five Number tools
Five Number tools › KQL Search Query Builder

KQL Search Query Builder

Build a Microsoft Search query the visual way. Add keywords and managed-property filters, and the KQL updates as you type. Copy it straight into the SharePoint search box, Submit-PnPSearchQuery, or a Graph /search/query request.

Nothing you type is sent anywhere. The query is assembled in your browser.
Property filters
Try an example (click to load it)

KQL query


      
PnP PowerShell

        
Microsoft Graph search: POST /search/query

        

KQL quick reference

  • Match operators: property:value matches content that contains the value, property=value is an exact match, and property<>value excludes it.
  • Comparisons (dates and numbers): >, >=, <, <=, for example LastModifiedTime>=2026-01-01 or Size>=1048576.
  • Phrases and wildcards: wrap multi-word values in quotes (Title:"annual report"); a trailing * is a prefix wildcard (Title:report*).
  • Combine: AND, OR and NOT join conditions; NOT before a filter excludes it.
  • Handy properties: FileType (docx, xlsx, pptx, pdf, aspx), FileExtension, Author, Filename, Path, ContentClass, IsDocument, LastModifiedTime, Created, Size, SiteTitle, SPWebUrl.
  • Note: only queryable managed properties can be searched, and exact matches need the property marked queryable in the search schema. Verify names in your tenant before relying on a query.

Disclaimer

These tools are provided free and as-is, with no warranty of any kind. Results are best-effort and can be incomplete or out of date, so always verify them against official Microsoft documentation before you act on them.

fivenumber tools is an independent project and is not affiliated with, sponsored by, or endorsed by Microsoft. Microsoft, Microsoft 365, SharePoint, Entra, OneDrive and Copilot are trademarks of the Microsoft group of companies.

Send feedback

Found this useful, or hit a snag? Tell me what worked and what would make it better. Your note comes straight to me.

Thanks, your feedback was sent.

I read every note. If you left your email, I may follow up.