OneDrive File Issues

Fix OneDrive Search Not Finding Text Inside ODS Files

Kushani Nimanthika Sep 28, 2026 868 views

Question details

User needs Windows Search to successfully find specific text inside ODS (OpenDocument Spreadsheet) files that are stored and synced within a OneDrive folder.

How to Fix OneDrive Search Not Finding Text Inside ODS Files

Product: Microsoft OneDrive and Windows Search
Device & OS: Windows
Scenario: Searching for text content inside ODS spreadsheet files located in a OneDrive directory.
Observed behavior: Windows Search successfully finds text in XLSX files within OneDrive, but fails for ODS files even though Indexing Options is configured to index ODS contents. The text is only found if the ODS files are moved outside of the OneDrive folder.

Before you start

Ensure you are logged into OneDrive and your device has an active internet connection to apply syncing changes. Verify that Windows Search is working normally for other local directories.

Solution 1Recommended

Mark ODS Files to Always Keep on This Device

Windows Search cannot index the local contents of ODS files if they are only stored online via OneDrive's Files On-Demand feature.

OneDrive's Files On-Demand feature saves local disk space by keeping files in the cloud until you open them. However, Windows Search relies on having the file downloaded locally to index text inside third-party formats like ODS.

Open OneDrive Folder

Press Windows Key + E to open File Explorer, and navigate to your OneDrive folder from the left-hand navigation pane.

Select the ODS Files or Folder

Locate the specific ODS files or the folder containing them that you want to be fully searchable.

Keep on Device

Right-click the selected files or folder and click 'Always keep on this device' from the context menu.

Wait for Sync

Wait for the sync status icon next to the files to change to a solid green circle with a white checkmark, indicating the file contents are fully downloaded and available for indexing.

Mark ODS Files to Always Keep on This Device

Solution 2

Rebuild the Windows Search Index

Forcing Windows to rebuild its search index can resolve inconsistencies where locally downloaded OneDrive files are still being skipped.

Solution 3

Move Files to a Local Folder

If OneDrive integration continues to block ODS content indexing, moving files to an un-synced local directory acts as a reliable workaround.

Free Microsoft Office alternative

Seamlessly Manage and Convert Spreadsheets with WPS Office

Because OneDrive and Windows Search natively prioritize Microsoft formats, converting your ODS files to XLSX is the most foolproof way to guarantee searchability. WPS Office is a free, lightweight suite that offers native support for both ODS and XLSX, making formatting and converting completely seamless.

1. Install WPS Office: Download and install the free WPS Office suite on your Windows PC.
2. Open Your ODS File: Launch WPS Spreadsheet and open the ODS file you are having trouble searching.
3. Convert to XLSX: Click on 'Menu' > 'Save As', choose 'Microsoft Excel Document (*.xlsx)' from the format dropdown, and save it back to your OneDrive folder.

Fully compatible with Microsoft Excel XLSX and OpenDocument ODS formats.Free and lightweight, avoiding the heavy resource usage of traditional office suites.Familiar user interface requires zero learning curve for seamless migration.Easily convert your ODS files into XLSX format to permanently resolve OneDrive indexing issues.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Windows Search find text in XLSX files but not ODS files on OneDrive?

OneDrive's cloud infrastructure often prioritizes its native Microsoft formats (like XLSX) for server-side indexing. For third-party open formats like ODS, Windows relies entirely on local file contents. If an ODS file is marked as online-only via Files On-Demand, the local search index cannot read its text.

Does Windows inherently lack the ability to search inside ODS files?

No, Windows Search can natively read and index the contents of ODS files as long as the file properties are configured correctly in Indexing Options and the actual file is physically present on your local hard drive.

How can I verify that my Indexing Options are set to read ODS contents?

Open 'Indexing Options' from the Windows Start menu, click 'Advanced', and select the 'File Types' tab. Scroll down to the 'ods' extension, click on it, and ensure the radio button for 'Index Properties and File Contents' is selected.

Will converting my ODS spreadsheets to XLSX format fix the OneDrive search problem?

Yes. OneDrive and Windows Search have deep, native integration for indexing Microsoft Office formats. Converting your ODS files to XLSX using spreadsheet software ensures their text contents are reliably indexed and searchable, even when stored solely in the cloud.

Document & File Issues