Learn how to set up and manage Microsoft Excel files in OneDrive as destinations for your data exports with SyncRange.
Overview
Microsoft Excel (via OneDrive) serves as an export destination for your data, alongside Google Sheets and BigQuery. Data is written directly to Excel workbooks stored in your OneDrive, with each export tab mapping to a worksheet in the file.
Prerequisites
Before you can configure Microsoft Excel as a destination, make sure you have:
When you add an Excel file, SyncRange will ask for permission to read and write files in your OneDrive (this happens automatically during setup)
Adding an Excel Destination
There are two ways to add an Excel file as a destination:
Method 1: Create a New Excel File
Create a brand new Excel file directly in your OneDrive:
Go to the Microsoft Integration dashboard
In the Excel (OneDrive) section, click "Add Excel File"
If prompted, allow SyncRange to access your OneDrive files
Enter a name for your new Excel file (e.g., "My Export Data")
Click "Create" — the file will be created in your OneDrive root folder
The new Excel file will appear in your OneDrive and be connected as a destination automatically.
Method 2: Select an Existing Excel File
Connect an existing .xlsx file from your OneDrive:
Go to the Microsoft Integration dashboard
In the Excel (OneDrive) section, click "Add Excel File"
If prompted, allow SyncRange to access your OneDrive files
Browse the list of Excel files found in your OneDrive
Click "Select" next to the file you want to use
Note
Only .xlsx files in your OneDrive are shown. Files shared with you from other accounts may not appear.
How Data is Written
Microsoft Excel destinations work similarly to Google Sheets:
Worksheets
Each export tab creates or updates a separate worksheet within your Excel file. Worksheet names are automatically generated based on the export configuration (e.g., "bing_ads_campaign").
Data Modes
Replace: Each export run clears the worksheet and replaces all data with fresh results
Append: Each export run adds new rows below existing data without removing previous entries
Managing Excel Destinations
Viewing Connected Files
All connected Excel files are listed in the Excel (OneDrive) section of the Microsoft Integration dashboard. You can click on a file name to open it directly in Excel Online.
Removing a Destination
To remove an Excel file from your destinations:
Find the file in the Excel section of the dashboard
Click the remove (X) button next to the file name
Important
Removing a destination will not delete the file from your OneDrive, but any exporters using this file will stop working. Update those exporters to use a different destination.
Best Practices
File Organization: Use separate Excel files for different data types (e.g., one for advertising data, another for analytics)
File Size: Excel files support up to ~1 million rows per worksheet. For very large datasets, consider using multiple files or BigQuery
Naming: Use clear, descriptive file names to easily identify their purpose
Sharing: Share your OneDrive Excel files with team members who need access to the exported data
Troubleshooting
Export Errors
If exports to your Excel file are failing:
Check that your Microsoft account is still connected and not marked as "Needs Reconnect"
Verify that the Excel file still exists in your OneDrive
Make sure you completed the OneDrive access step when adding the file
Check the export logs for specific error messages
File Not Appearing
If your Excel file doesn't appear when selecting a destination:
Make sure the file has a .xlsx extension
Check that the file is in your personal OneDrive (not a SharePoint site)
Try adding the Excel file again from the Microsoft Integration dashboard
Install on Shopify