Magpi's Publish feature allows users with a Google or Microsoft online account to easily push the collected data from a form to a Google Sheet or an online Excel sheet, without programming. The process is very simple and takes only a minute or so. You can have the data moved once, or set it to automatically sync and stay up-to-date.

First: Connect Your Google and/or Microsoft Account

You can connect your account to Magpi by going to your Magpi profile page: click your username in the upper right corner, then select Profile from the menu, then click the Integrations tab.

On the Integrations tab, select the service you wish to connect and click the Connect button.  For example, to connect to Microsoft Online and send your Magpi data to online Excel, go to the Microsoft section and click "Connect to Microsoft". This will bring up Microsoft's authorization window, so that you can enter your Microsoft credentials and connect the accounts.

Second: Make Sure You Have a Destination Document for the Data

You'll need to have an empty spreadsheet at Google Sheets or Microsoft Office online to publish the data to.  

Third: Publish Your Form Data

1 - Open the form you want to publish and go to the Data tab, then click the Publish button. That will open up the Publish dialog, as shown below.

If you do not see anything in the list, either

1 - you have not yet connected Magpi to your Google/Microsoft account, or

2 - you do not have any workbooks (i.e. Google Sheets or Excel worksheets) in those accounts (note that in Microsoft that document will need to be in the top level of your OneDrive online file area).

2 - Select a workbook in the Workbooks list, then select a Sheet (i.e. a tab) in the Sheets list.

3 - select "One Time" if you just want to push the form's current data once, or "daily" if you want the external spreadsheet to be refreshed daily with the latest data from the form.

4 - click Publish. That's it!  The window will now reflect the publication:

Disconnecting Your Microsoft Account

If you no longer wish to connect your Microsoft account to Magpi, you can remove the integration:

For individual Microsoft accounts:

For organizational Microsoft accounts:

Disconnecting Your Google Account

If you no longer wish to connect your Google account to Magpi, you can remove the integration: