Display your data from Microsoft Forms in an Awesome Table app

This article explains how to display your data from Microsoft Forms responses in an Awesome Table app, and how to share your form.

info This article is for Microsoft users only. If you are a Google user, refer to the following article: Allow users to update your app’s data with Google Forms

1. Create your Microsoft Form

warning If you create a Form from the Microsoft homepage, your Responses Excel file will not be automatically updated, you will have to do it manually each time someone will submit the form:

Screenshot_2019-11-05_at_16.16.25.png

If you own a Microsoft 0365 account, we recommend to create a Form directly from Sharepoint or OneDrive.

From SharePoint
From OneDrive

1. In your SharePoint, click Documents > New > Forms for Excel:

2. Enter a name for your Form (i.e: Job Board) > click Create:

A new window opens.

3. Add questions to your Form:

Screenshot_2019-11-12_at_16.24.23.png

ACCESS THE FORM

If you go back to your SharePoint Documents, you will notice a newly created Excel file which automatically collects all your Form responses:

Screenshot_2019-11-12_at_16.28.21.png

Screenshot_2019-11-12_at_16.33.54.png

4. To retrieve the responses on an Excel file, go to your form. Click Responses > Open in Excel:

Screenshot_2019-11-12_at_16.35.49.png

info By default, your Form will not be stored in your SharePoint Documents. To retrieve it, go to your Forms app.
You can also click the Menu icon on the top left corner > All apps > Forms > Group forms.

Screenshot_2019-11-12_at_16.40.54.png

1. In your OneDrive, click Files > New > Forms for Excel:

Screenshot_2019-11-13_at_11.05.58.png

2. Enter a name for your Form (i.e: Job Board) > click Create:

Screenshot_2019-11-13_at_11.09.04.png

A new window opens.

3. Add questions to your Form:

Screenshot_2019-11-12_at_16.24.23.png

ACCESS THE FORM

info Microsoft Forms don’t automatically create an Excel file to retrieve your Form responses when used with OneDrive, you will have to do it manually.

Screenshot_2019-11-13_at_13.52.51.png

4. To retrieve the responses on an Excel file, go to your form. Click Responses > Open in Excel:

Screenshot_2019-11-13_at_14.01.29.png

info By default, your Form will not be stored in your SharePoint Documents. To retrieve it, go to your Forms app.
You can also click the Menu icon on the top left corner > All apps > Forms > My forms.

Screenshot_2019-11-12_at_16.40.54.png

Send and collect responses

info Follow these steps below to learn how to share your form to your respondents and collect all responses in your Excel file.

1. On your Form, click Share:

Screenshot_2019-11-13_at_10.46.40.png

A right sidebar will appear, displaying all your form sharing settings:

Screenshot_2019-11-13_at_10.52.03.png

2. Select your target: Anyone with the link can respond or Only people in my organization can respond.

3. Choose how to share your form:

Screenshot_2019-11-13_at_16.27.01.png

4. Once done, your respondents can submit their answers:

Screenshot_2019-11-13_at_10.59.43.png

You can then retrieve their answers in the responses Excel file that you’ve created in your SharePoint Documents – learn more: Create your Microsoft Form.

Send and collect responses

info Follow these steps below to learn how to share your form to your respondents and collect all responses in your Excel file.

1. On your Form, click Share:

Screenshot_2019-11-13_at_10.46.40.png

A right sidebar will appear, displaying all your form sharing settings:

Screenshot_2019-11-13_at_10.52.03.png

2. Select your target: Anyone with the link can respond is the default and only option available for sharing your form.

3. Choose how to share your form:

Screenshot_2019-11-13_at_16.27.01.png

4. Once done, your respondents can submit their answers:

Screenshot_2019-11-13_at_10.59.43.png

You can retrieve their answers in the responses Excel file that you’ve downloaded from your Form, but do not forget to re-download the file to retrieve the new responses.

3. Set up your Excel file

To know how to set your datasource with headers and keywords, we recommend reading the following: [Part 1] Create and set up your datasource

info If you want to know more about keywords, you can check this article: All available keywords to present your data

Create dynamic webapps from spreadsheets in minutes without coding skills

1. Create your Microsoft Form

2. Share your Form with respondents

3. Set up your Excel file

Articles in this section