Configuring Microsoft Excel

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:

Connected your Microsoft account (see Connecting Your Microsoft Account)
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