--- title: "OneDrive Integration for Rig: Query OneDrive Data in Plain English" description: "Connect OneDrive to Rig and query your OneDrive data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/onedrive" format: markdown --- Browse integrations ![OneDrive logo](https://img.logo.dev/microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) Files & productivity Supported # OneDrive integration for Rig ## The easiest way to connect OneDrive to Claude and other AI tools OneDrive is Microsoft's cloud file store, holding Excel workbooks, exports and shared documents across personal storage and SharePoint document libraries. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) ## What Rig syncs from OneDrive Once connected, Rig models these objects so questions resolve to the right tables and joins: - Files - Folders - Excel workbooks - File metadata - Shared items - SharePoint document libraries ## How OneDrive connects to Rig Rig Ingest watches the OneDrive folders and SharePoint document libraries you choose and loads Excel and CSV files into your warehouse on a schedule, parsing each into a typed table. Rig tracks file metadata and sharing so you can see what arrived and who can access it. ## Ingest Excel and CSV from OneDrive and SharePoint Finance and ops teams keep Excel workbooks in OneDrive and SharePoint that drive real decisions but never reach the warehouse. Rig parses those workbooks and CSV files into warehouse tables on sync, so the figures inside them become queryable. Ask Rig - Load the latest workbook in the finance library and show me the totals - Read the actuals sheet from this month's Excel file - What rows changed since last week's version of the file? ## Centralise finance and ops files Operational files scattered across OneDrive and SharePoint libraries are hard to reconcile against systems of record. Rig pulls them into consistent warehouse tables, so you can compare workbook figures to actuals from your other tools in one question. Ask Rig - Compare the spend workbook to warehouse actuals by department - Combine the regional Excel files into one table - Which finance files have not been updated this month? ## Track file inventory across SharePoint libraries Rig reads file metadata and sharing across your OneDrive and SharePoint document libraries, so you can see what files exist, when they changed and who can access them. Teams use it to keep shared data organised and auditable. Ask Rig - List files in the finance library shared outside the team - Which workbooks have not been modified in six months? - Show the most recently updated files in the ops library ## Ask your OneDrive data in Claude, ChatGPT or Cursor Rig serves your OneDrive data to AI assistants over MCP. Once OneDrive is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL. - [Claude](https://rig.so/integrations/claude) - [Claude Code](https://rig.so/integrations/claude-code) - [Cursor](https://rig.so/integrations/cursor) - [ChatGPT](https://rig.so/integrations/chatgpt) - [Codex](https://rig.so/integrations/codex) - [Gemini](https://rig.so/integrations/gemini) ## Frequently asked questions What OneDrive data does Rig sync? Rig syncs file and folder metadata, shared items and SharePoint document libraries, and parses Excel workbooks and CSV files in the folders you choose into typed warehouse tables. Can Rig read Excel workbooks from OneDrive and SharePoint? Yes. Rig watches the folders and document libraries you select and parses Excel and CSV files into warehouse tables on each sync, so finance and ops files become queryable. Can I query OneDrive data in Claude or ChatGPT? Yes. Once your files and metadata are synced to your warehouse, Rig serves them to Claude, ChatGPT, Cursor and other AI tools over MCP. How often does OneDrive data refresh? Rig Ingest syncs on a schedule you set, picking up new and updated files and tracking metadata changes automatically. ## Related integrations [![Airspeed logo](https://img.logo.dev/airspeed.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)AirspeedSales calls with transcripts, summaries and MEDDIC and BANT deal signals.](https://rig.so/integrations/airspeed)[![Airtable logo](https://img.logo.dev/airtable.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)AirtableBring the operational tables your team maintains into the warehouse.](https://rig.so/integrations/airtable)[![Box logo](https://img.logo.dev/box.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)BoxIngest a Box folder tree: spreadsheets become tables, PDFs become text.](https://rig.so/integrations/box)[![Calendly logo](https://img.logo.dev/calendly.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)CalendlyMeeting booking, no-show and conversion analytics from Calendly.](https://rig.so/integrations/calendly)[![Dropbox logo](https://img.logo.dev/dropbox.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)DropboxIngest data files and partner drops from Dropbox into your warehouse.](https://rig.so/integrations/dropbox)[![Fathom logo](https://img.logo.dev/fathom.video?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)FathomMeeting recordings, transcripts, AI summaries and action items.](https://rig.so/integrations/fathom) ## Connect OneDrive data to AI tools like Claude Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) --- - [This page as HTML](https://rig.so/integrations/onedrive) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)