> ## Documentation Index
> Fetch the complete documentation index at: https://docs.communityhub.cloud/llms.txt
> Use this file to discover all available pages before exploring further.

# OneDrive

> Connect a Microsoft OneDrive account to automatically pull time-series data from a shared CSV or Excel file.

The OneDrive data source lets you connect your Microsoft OneDrive account to automatically pull time-series data from a shared CSV or Excel file you host there.

## How it works

<Steps>
  <Step title="Connect your account">
    You authorize the platform via your Microsoft account (OAuth). No password is stored; only a secure refresh token is kept to maintain the connection.
  </Step>

  <Step title="Point to your file">
    Provide a shared link to a CSV or Excel file in OneDrive. The platform reads the file on a scheduled basis to ingest new rows.
  </Step>

  <Step title="Map your columns">
    You specify which column contains timestamps (the date column). All other numeric columns are automatically treated as data variables (for example, energy readings or sensor values).
  </Step>

  <Step title="Automatic variable creation">
    If new columns appear in your file over time, corresponding variables are created automatically.
  </Step>

  <Step title="Ongoing sync">
    The integration polls your file on a recurring schedule, appending only new rows to the database. You do not need to manually upload data.
  </Step>
</Steps>

## Key requirements

* The file must be shared (via a OneDrive share link) with at least read access.
* The file must contain a date/timestamp column and one or more numeric data columns.
* Your Microsoft account must remain connected. If you revoke access or the token expires, you'll need to reconnect.

## Supported file formats

`.csv`, `.xlsx` (Excel)