Microsoft Excel is one of the most widely used spreadsheet applications in the world. Your app can be integrated with your Excel Workbooks, allowing you to build apps with a data source you're familiar with.
There are two ways to use Excel files:
Option 1 - Connect to your Excel file (.xlsx or .csv) in your Microsoft OneDrive or SharePoint account.
Option 2 - Upload your Excel file (.xlsx or .csv) to your app.
Excel files hosted in Microsoft OneDrive and SharePoint can be integrated with Glide. This is especially useful when multiple people need quick access to the original workbook.
It is recommended to create a copy of your file if you want to maintain its original format. Once connected, a Row ID column will be automatically added at the end of every sheet to help keep everything in sync. This column should not be deleted in the original file.
To create a new app, click on New app in your dashboard.
Give it a name.
Continue to select your Data Source.
Click on Excel and Continue.
If this is your first time using an Excel data source, click on the Connect button under Excel to add your account. Microsoft OneDrive will open in a new tab. You'll be prompted to log in and give Glide access to your files.
Click on your drive folder and then Choose Library.
If your files are in SharePoint instead of OneDrive, click on the Authorize SharePoint Access button and grant Glide extra permissions to connect to it.
Find and select the Excel file you want to use and then click on Create App.
Click Continue to create your new app.
When the app is created, a new Row ID column is added to each sheet in the file at this time. The sheets in your Excel Workbook are added as individual Tabs to the Layout Editor and individual Tables in the Data Editor.
To begin, create your app by clicking on New app in your dashboard.
Provide a name for your app.
Continue to select your data source.
Click on Import a file from your computer.
Select your file (.xlsx, .csv, or .ods) and click Upload or simply drag and drop to create your app.
The sheets in your Excel Workbook are added as individual Tabs to the Layout Editor and individual Tables in the Data Editor.
Unlike when connecting to OneDrive or SharePoint, Glide does not create a new Row ID column when uploading an Excel file.
After adding your Excel files to your project, you can connect to other data sources as needed. This allows you to sync data across multiple platforms, bringing everything together in one place.
Go to the Data Editor in your project.
Click on the plus (+) symbol in the Tables panel.
Either add a new empty table, import a new Excel file, or choose one of the available options (e.g., Google Sheets) to sync your data.
If your OneDrive account is managed by your organization, you may need to get an admin to grant additional permissions before you can connect it to your project.
An IT admin will need to approve Glide permissions for you to:
Sign in and read the user profile
Have full access to user files
Maintain access to data that has given it access to
Here's a guide for IT admins about how to approve Glide.
If your organization is concerned about granting you or other users access to the whole drive, your IT admin could create a Glide-only user account in Microsoft that you can connect to Glide. This way, the necessary files can be shared with only that user. This will firewall Glide to that user's whole drive.