Excel

Configuration

Microsoft Excel source connector integrates with the Microsoft Graph API.

Synchronizes data from Microsoft Excel including workbooks, worksheets, and tables.

It provides comprehensive access to Excel resources with proper token refresh and rate limiting.

Explore the Excel connector implementation

This connector uses OAuth 2.0 authentication. You can connect through the Airweave UI or API using the OAuth flow.

Supported authentication methods:

This connector does not have any additional configuration options.

The following data models are available for this connector:

Schema for a Microsoft Excel workbook (file).

Represents the Excel file itself with metadata.

Field	Type	Description
file_name	str	The full file name including extension.
web_url	Optional[str]	URL to open the workbook in Excel Online.
size	Optional[int]	Size of the file in bytes.
created_by	Optional[Dict[str, Any]]	Identity of the user who created the workbook.
last_modified_by	Optional[Dict[str, Any]]	Identity of the user who last modified the workbook.
parent_reference	Optional[Dict[str, Any]]	Information about the parent folder/drive location.
drive_id	Optional[str]	ID of the drive containing this workbook.
description	Optional[str]	Description of the workbook if available.

Schema for a Microsoft Excel worksheet (sheet/tab).

Represents individual sheets within an Excel workbook.

Field	Type	Description
workbook_id	str	ID of the parent workbook.
workbook_name	str	Name of the parent workbook.
position	Optional[int]	The zero-based position of the worksheet within the workbook.
visibility	Optional[str]	The visibility of the worksheet (Visible, Hidden, VeryHidden).
range_address	Optional[str]	The address of the used range (e.g., ‘A1:Z100’).
cell_content	Optional[str]	Formatted text representation of the cell content in the used range.
row_count	Optional[int]	Number of rows with data in the worksheet.
column_count	Optional[int]	Number of columns with data in the worksheet.
last_modified_datetime	Optional[Any]	Timestamp at which the worksheet was last modified.

Schema for a Microsoft Excel table.

Represents structured data tables within worksheets.

Field	Type	Description
workbook_id	str	ID of the parent workbook.
workbook_name	str	Name of the parent workbook.
worksheet_id	str	ID of the parent worksheet.
worksheet_name	str	Name of the parent worksheet.
display_name	Optional[str]	Display name of the table.
show_headers	Optional[bool]	Indicates whether the header row is visible.
show_totals	Optional[bool]	Indicates whether the total row is visible.
style	Optional[str]	Style name of the table.
highlight_first_column	Optional[bool]	Indicates whether the first column contains special formatting.
highlight_last_column	Optional[bool]	Indicates whether the last column contains special formatting.
row_count	Optional[int]	Number of rows in the table.
column_count	Optional[int]	Number of columns in the table.
column_names	Optional[List[str]]	Names of the columns in the table.
table_data	Optional[str]	The actual table data as formatted text (rows and columns).
last_modified_datetime	Optional[Any]	Timestamp at which the table was last modified.