Overview
Anyone who’s used OneDrive or Microsoft Office knows how powerful it is for managing and collaborating on files in a team. With Array’s OneDrive integration, you can automatically send form responses, files, and attachments to an Excel spreadsheet stored in your OneDrive account — streamlining your workflow and eliminating manual data entry.
In This Article
What is OneDrive?
How to connect your OneDrive account to Array
How to create a new Excel sheet from Array
How to send form data to OneDrive
How to save files (PDFs, media) to OneDrive
How to use OneDrive Excel sheets to populate form fields
What is OneDrive?
OneDrive is Microsoft’s cloud-based file storage platform. It allows you to securely store, access, and collaborate on documents — including Excel spreadsheets — from any device.
To sign up for a free OneDrive account, click here.
Connecting Your OneDrive Account to Array
Go to the Array Market
Navigate to the Installed Apps panel at the top of your Array dashboard.
Search for OneDrive in the Market.
Click “Install”
You’ll be redirected to the OneDrive login page.
Log in & Authorize Access
Grant permission by clicking “Allow” on the authorization popup.
Verify the Connection
You’ll now see your OneDrive account listed as connected.
To add additional accounts, click “Add OneDrive Account.”
To disconnect, simply click the X next to your connected account email.
Note: Disconnecting will break any forms using OneDrive integration.
Creating OneDrive Excel Sheets from Array
Want to automatically log form submissions into an Excel spreadsheet stored in OneDrive?
Here’s how:
Open the form you want to connect
Click on the “Connect” tab at the top of the Form Builder
Go to the Storage tab and select OneDrive
Choose the file type → select .XLS
Click Save
A new Excel file will be created in your OneDrive under a folder titled "Array". Each form submission will populate a new row in the spreadsheet.
Saving Files to OneDrive (PDFs, Images, etc.)
You can also include file attachments in your OneDrive spreadsheet:
In the Form Attachment Menu, locate the desired file types (PDFs, images, etc.)
Toggle them on by clicking the button next to each file type
These attachments will be saved as links in your Excel file
Using OneDrive for Data Search in Forms
Want to pre-fill form fields using data stored in OneDrive?
Here’s how to enable Data Search:
In the Form Builder, go to the Text Input tab
Drag the “Data Search” field into your form
The Search Data Link menu will open
Go to the Integrations tab and select OneDrive
Choose the Excel file you'd like to pull data from
Select the spreadsheet columns you want to search and display in the form
Perfect for things like lookup forms, auto-filling contact info, or checking existing records.
Final Checklist
Task | Done? |
Connect OneDrive account to Array | 🔲 |
Create Excel file and link to form | 🔲 |
Enable file attachment saving | 🔲 |
Add Data Search fields (optional) | 🔲 |
Test your form submission | 🔲 |