Platform Banner

Forms - Create a Microsoft Forms form directly in OneDrive Tutorial

Unlock the power of real-time data collection with our video on creating a Microsoft Forms form directly in OneDrive! Learn to set up your form seamlessly, link it to an Excel file for immediate updates, and see how new responses magically appear. Perfect for those looking to streamline their data management—don't miss it!

01:12
735 views
Parteger

Copilot in the workplace: succeeding in usage and governance
- 02:32
- Viewed 218 times
Data and privacy: a clear framework for the enterprise
- 02:29
- Viewed 230 times
Choosing Copilot or connecting an external AI in Microsoft 365?
- 02:37
- Viewed 220 times
Why does AI in the workplace raise a different question?
- 02:05
- Viewed 241 times

Available in Microsoft365

00:00:06

Microsoft Forms form directly from OneDrive or SharePoint

00:00:10

so you can collect the answers in a real-time updated Excel file.

00:00:14

Here's how to do it

00:00:16

from your OneDrive or SharePoint account.

00:00:19

Click on create or upload

00:00:21

and then select form survey.

00:00:24

Give your form a name,

00:00:26

then add your questions as usual.

00:00:29

After the form is created,

00:00:30

a new page opens in Microsoft Forms.

00:00:33

A linked Excel file is automatically generated and saved to your OneDrive.

00:00:39

This file contains all the answers and updates in real time as participants respond

00:00:46

from the view responses tab of the form,

00:00:48

you can click on open in Excel.

00:00:51

The file will then open directly in Excel for the web

00:00:54

connected to your OneDrive.

00:00:56

Any new answers will appear there automatically

00:01:00

without the need to re-download the document.

00:01:03

In the next video,

00:01:04

we'll see how to use a forms form to trigger automatic actions with power automate.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

E-learning Intermédiaire

Vu 383 fois

Video Training Microsoft Forms - Intermediate

Learn how to create, structure, and optimize your forms and questionnaires with Microsoft Forms. Use sections, branching, quick import, and file sending to save time and improve the respondent experience.

ALL COURSES