# OneDrive

- URL: https://betteranalyst.com/docs/connectors/onedrive
- Updated: 2026-11-12
- Author: Better Analyst

Import Excel, CSV, and TSV files from Microsoft OneDrive into Better Analyst for AI chats, dashboards, charts, and reports.

Connect OneDrive to choose files from your Microsoft account and import them into Better Analyst for AI-powered analysis.

## Prerequisites

- A personal Microsoft account or work/school Microsoft account
- Access to the OneDrive file you want to analyze
- A supported spreadsheet or tabular file

Some Microsoft work or school organizations require administrator approval before users can connect third-party apps. If Microsoft blocks the sign-in, ask your tenant admin to approve Formula Bot, the current registered OAuth app name.

## Setup Steps

### 1. Open OneDrive Import

1. Go to **Dashboard**
2. Click **Add Data**
3. Select **OneDrive**

Better Analyst opens the Microsoft OneDrive picker.

### 2. Sign In and Select a File

1. Sign in with Microsoft if prompted
2. Approve the requested OneDrive access
3. Choose one or more Excel, CSV, or TSV files
4. Click **Open** or **Select**

Better Analyst imports the selected files and redirects you back to the dashboard when the files are ready.

### 3. Analyze the File

Use the imported files in AI chat, dashboards, charts, reports, and spreadsheet workflows. Better Analyst reads the imported copies and leaves the source OneDrive files unchanged.

## Supported Files

OneDrive imports work best with structured data:

- Excel workbooks
- CSV files
- TSV files

## Example Questions

- "Summarize this workbook by region"
- "Find missing values in this OneDrive file"
- "Build a dashboard from these tabs"
- "Create charts for monthly revenue"
- "Which rows changed compared with last period?"

## Troubleshooting

### Microsoft Sign-In Failed

- Confirm you are using a Microsoft account with access to the file
- If this is a work or school account, your organization may require admin approval
- Try signing out of extra Microsoft accounts and connecting again

### Picker Did Not Open

- Allow popups for Better Analyst
- Refresh the dashboard and try again
- Check whether your browser is blocking Microsoft sign-in windows

### File Did Not Import

- Confirm the file is an Excel, CSV, or TSV file
- Make sure the file still exists in OneDrive
- Try selecting the file again from the OneDrive picker

## Security Notes

Better Analyst uses Microsoft OAuth and imports only the file you choose. The connector does not edit, delete, or overwrite files in your OneDrive.

## Next Steps

- [Upload files manually](https://betteranalyst.com/docs/my-data/uploading-files)
- [Ask questions in chat](https://betteranalyst.com/docs/ai-chat/asking-questions)
- [Create dashboards](https://betteranalyst.com/docs/ai-chat/charts-visualizations)