How to export CMS data to Excel Spreadsheet -- without third-party service?

Ask the community
, ,
1

Question:
Given my organizations need, we would like to export CMS data to Microsoft Excel spreadsheets, similar to the in-built feature of export to Google Sheets. Is there a send data to a Excel sheet without a third-party service like Zapier?
Product:
Wix CMS

What are you trying to achieve:

  • Export CMS data to Excel – no external solutions, i.e. Zappier
2

You can import csv files into Excel.

3

I need it to be automated

4

I see you mean like this for sheets.

This is something I have not used. Asking ChatGPT seems to confirm my thoughts that you may be able to do this yourself through Wix Webhooks and Microsoft Power Automate

Below is ChatGPT’s take on it. it maybe helpful or not, but if works then the automation is done between Wix and Microsoft alone.

I do use wix web hooks for stuff, But please take below as concept rather than exactly how it works as I have, omitted it’s coding as I did not verify it and there are plenty of instructions on how to create web hooks in wix.

Yes, in Option 2, the import to Excel can be automatic when using Microsoft Power Automate. The process can be set up to run on a schedule or be triggered by an event, ensuring your Excel file is always up-to-date without manual intervention.

How to Set It Up for Automatic Import:

Step 1: Create a Webhook in Wix

You expose your Wix CMS data through an HTTP function.

  1. Set up a Wix backend webook

Step 2: Set Up Microsoft Power Automate

Power Automate will fetch the CMS data from the Wix webhook and insert it into an Excel file.

  1. Log into Microsoft Power Automate and create a new flow.
  2. Choose the Trigger:
  • Use the “Recurrence” trigger if you want the flow to run on a schedule (e.g., hourly, daily).
  • Alternatively, you can use other triggers like “When an HTTP request is received” if you want more control over when it runs.
  1. Add an HTTP Action:
  • Select “HTTP” from the available actions.
  • Configure the action:
    • Method: GET
    • URI: Paste the URL of your Wix webhook (e.g., https://your-site-name/_functions/cmsData).
  1. Parse the Response:
  • Add a “Parse JSON” action to interpret the data returned by the webhook.
  • Use the JSON response schema from your webhook. For example:

json

For example

{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "field1": { "type": "string" },
      "field2": { "type": "string" }
    }
  }
}
  1. Insert Data into Excel:
  • Use the “Add a row into a table” action.
  • Select your Excel file stored in OneDrive or SharePoint.
  • Map the fields from the webhook data to the columns in your Excel table.

Step 3: Test and Automate

  • Test the flow to ensure it fetches data from Wix and updates the Excel file correctly.
  • Once confirmed, the flow will run automatically based on the trigger you’ve configured.
5

I will be sure to try this, thank you.

7

You can defn send data to a google sheet using their APIs. Something similar we’ve done here. https://www.wixrocket.com/wix-to-google-sheets

If you want it to be done on excel, best way is to have a scenario where we can download the data into excel. Which can also be done through code :slight_smile: