Exporting Microsoft Forms data into Word can be a convenient way to analyze and present your form responses. While Microsoft Forms doesn't have a built-in feature for this, you can use a workaround involving Excel and Word. Here's a step-by-step guide to help you achieve this:
Before we dive in, ensure you have Microsoft Forms, Excel, and Word installed on your computer. Also, make sure you have access to the form responses you want to export.
Preparing Your Form Responses
Microsoft Forms stores responses in the cloud, and you can download them as an Excel file. Here's how:
1. Open the Microsoft Form that contains the responses you want to export. 2. Click on 'Responses' at the top of the form. 3. Click on the three dots (⋮) at the top right corner of the responses grid. 4. Select 'Export responses'. 5. Choose 'Excel' as the file format. 6. Select the range of responses you want to export, or choose 'All' for all responses. 7. Click 'Export'. The file will be downloaded to your computer.
Formatting Your Excel File
Once you've downloaded the Excel file, you might need to format it to fit your needs. For instance, you can add or remove columns, sort data, or apply filters. Here's how to sort data:
1. Select the data you want to sort. 2. Click on 'Sort & Filter' in the 'Home' tab. 3. Choose the sorting method (e.g., 'Sort A to Z' or 'Sort Z to A').
Exporting to Word
Now that your Excel file is ready, you can export it to Word. Here's how:
1. Open Microsoft Word. 2. Click on 'Insert' in the menu. 3. Select 'Object' and then 'From File'. 4. Choose the Excel file you want to insert. 5. Click 'Insert'. The data will be inserted into your Word document.
Formatting Your Word Document
Once you've inserted the data, you can format your Word document to make it more presentable. Here are a few tips:
1. **Add a Table of Contents**: This can help readers navigate your document. To add one, go to 'References' > 'Table of Contents' > 'Insert Table of Contents'.
Formatting the Table
You can also format the table containing your form responses. Here's how to add a border:
1. Select the table. 2. Go to the 'Design' tab under 'Table Tools'. 3. Click on 'Borders' and choose the style you want.
Adding Headers and Footers
Headers and footers can help you add additional information to your document, like page numbers or your name. Here's how to add them:
1. Go to 'Insert' > 'Header' or 'Footer'. 2. Choose the header or footer you want to edit. 3. Add the information you want, like page numbers or your name.
And there you have it! You've successfully exported Microsoft Forms data into Word. This can be a great way to analyze and present your form responses in a more detailed and engaging manner. Happy exporting!