How to Auto-Sync Excel Rows to Google Sheets using Zapier (No Coding)

You have a master Excel file on OneDrive for your team, but your boss loves Google Sheets. Every day, you waste 15 minutes copying new rows from Excel to Sheets.

Let's automate this. In this guide, we will use Zapier to bridge the gap between Microsoft and Google.

(If you are completely new to automation, I highly recommend reading my Beginner's Guide to Zapier Automation first to understand the basics of Triggers and Actions).

The Recipe

Step 1: Prepare Your Excel

Zapier cannot read a messy sheet. You must format your data as a Table.

• Highlight your data headers.
• Go to Insert > Table.
• Name the table (e.g., "SalesData").
• Save the file in OneDrive for Business (Zapier works best with the cloud version).

Step 2: The Trigger (Excel)

1. Log in to Zapier. Click Create Zap.
2. Trigger App: Microsoft Excel.
3. Event: "New Row in Table".
4. Connect your Microsoft Account and select the file + table.

Step 3: The Action (Google Sheets)

1. Action App: Google Sheets.
2. Event: "Create Spreadsheet Row".
3. Map the fields: Match "Name" from Excel to "Name" column in Sheets.
4. Test the Zap and Turn it On.

Now, every time you add a row in Excel, it magically appears in Google Sheets instantly!

Next Step: Once your data is in Google Sheets, why not use AI to analyze it? Check out my tutorial on How to Use ChatGPT to Analyze Data.

---

Author: Marg | Daily Innovate Tech

Location: United States

Share :