How it works
1
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.
2
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.
3
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).
4
Automatic variable creation
If new columns appear in your file over time, corresponding variables are created automatically.
5
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.
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)