Excel Online SQLite Extension

Extension

Version 0.1.0
SQLite 3.45.1 or newer
Operating system Linux & Mac (ARM)

This SQLite extension lists tables from an Excel file located on your Microsoft OneDrive as database tables. It automatically detects data types and converts table and column names to be database-friendly.

Key points

Calls Microsoft Graph directly from your local machine
Works with any SQLite program or programming language
Lists tables from your Excel file as database tables
Fast in-memory cache for the duration of the connection
Automatically detects dates, booleans and numbers
One-time download, no subscription needed

Example

select name, position from excel_table_1 where start_date > date('today'); ┌────────────┬─────────────────────┐ │ name │ position │ ├────────────┼─────────────────────┤ │ John Smith │ Key Account Manager │ └────────────┴─────────────────────┘

Configuration

Every new SQLite connection should call function excel_config with authentication details. This information is not saved, and kept in-memory for the duration of the connection.

select excel_config('token: ..., file: ...');

token Access token to Microsoft Graph
file Path to Excel file from drive root
prefix Prefix for table names, defaults to excel_

FAQ

For any questions, support, or feedback regarding this extension, please contact support

Why use SQLite extensions?

SQLite extensions can make your development faster and more efficient. They are helpful for both developers and users who are comfortable with SQL. Extensions provide privacy, control, and locality to your data and credentials. Read more

Why should I try this beta extension?

This extension is currently available for free to anyone who wants to try the Excel Online extension. If you send your feedback to support, you will receive the personal version for free when it is released.

How do you read the Excel file?

Once authenticated, the extension uses Microsoft Graph to access all tables saved in the connected Excel file.

Table and column names are automatically converted to snake_case for compatibility with SQL queries.

Data types for each column are determined by studying the first 10 rows of values, falling back to the original cell text.

When a table is accessed, all its rows are loaded into memory and remain there for the duration of the connection.

How do I get a token for Microsoft Graph?

You will need to setup you own oAuth client for Microsoft Graph with the and acquire a token with the appropriate scopes.

Please refer to Microsoft documentation for detailed instructions.

What Microsoft Graph scopes are needed?

We only expect tokens to have the have minimal scopes mentioned in the official documentation.

Files.Read – for reading Excel file contents

How should I refresh expired tokens?

You can either refresh expired tokens based on your own records before using the extension, or react to the extension error messages with error code A79.

Runtime error: Source API access has expired Detail: Lifetime validation failed, the token is expired Help: Please check your credentials Code: A79

Are SharePoint drives supported?

No, SharePoint drives are not supported. The extension accesses files from the default drive linked to the authentication, which is usually either a personal or business OneDrive account.

How do I receive updates?

We will email you when an update to the same extension version has been released.