Exporting survey results from Microsoft Forms is a crucial step in analyzing and utilizing the data collected. Here's a step-by-step guide to help you export your survey results in a format that's easy to work with.
Before we dive into the process, ensure that you're using a Microsoft 365 subscription that includes Microsoft Forms. Now, let's get started.
Exporting Survey Results
Microsoft Forms allows you to export survey results in two formats: Excel and PDF. Each format has its advantages, so let's explore both.
First, we'll look at exporting to Excel, which is ideal for data analysis and manipulation. Then, we'll cover exporting to PDF for a more print-friendly format.
Exporting to Excel
Exporting your survey results to Excel allows you to analyze and manipulate your data using the powerful tools in Excel. Here's how to do it:
1. Open the survey in Microsoft Forms. Click on the 'Responses' tab at the top of the page.
2. Click on the 'Export' button located at the top right corner of the responses page.
3. Select 'Excel' from the dropdown menu. The file will be downloaded to your device.
4. Once downloaded, open the file in Excel. You'll see a sheet with all the responses, including any questions you've added to your survey.
Exporting to PDF
Exporting to PDF is useful when you want to print or share the results without the need for data manipulation. Here's how to export to PDF:
1. Follow steps 1 and 2 from the previous section to access the 'Export' button.
2. This time, select 'PDF' from the dropdown menu. The file will be downloaded to your device.
3. Open the PDF file to view the responses. You can print this file or share it with others.
Analyzing Survey Results
Once you've exported your survey results, you can analyze the data using various tools and methods. Here are a few tips:
1. **Use built-in Excel tools**: Excel has several built-in tools like PivotTables and conditional formatting that can help you analyze your data more effectively.
2. **Create visualizations**: Use charts and graphs to represent your data visually. This can help you identify trends and patterns more easily.
3. **Cross-tabulate data**: If you have multiple-choice questions, you can cross-tabulate the data to see how responses relate to each other.
Remember, the key to effective data analysis is to ask the right questions and choose the right tools to analyze the results. With Microsoft Forms and Excel, you have a powerful combination for creating and analyzing surveys.
Now that you know how to export and analyze your survey results, it's time to put this knowledge into practice. Happy surveying!