{"id":7359,"date":"2024-07-17T14:01:11","date_gmt":"2024-07-17T05:01:11","guid":{"rendered":"https:\/\/m365jp.net\/?p=7359"},"modified":"2024-07-17T14:03:24","modified_gmt":"2024-07-17T05:03:24","slug":"mc816207-microsoft-forms-now-supports-live-data-sync-to-microsoft-excel-with-more-functionality","status":"publish","type":"post","link":"https:\/\/m365jp.net\/index.php\/2024-07-17-mc816207-microsoft-forms-now-supports-live-data-sync-to-microsoft-excel-with-more-functionality","title":{"rendered":"MC816207 | Microsoft Forms now supports live data sync to Microsoft Excel with more functionality"},"content":{"rendered":"<div class=\"postie-post\">\n<div>\n<hr>\n<table id=\"section\">\n<tbody>\n<tr>\n<th width=\"95%\">MC816207 | Microsoft Forms now supports live data sync to Microsoft Excel with more functionality<\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr>\n<table id=\"data\">\n<tbody>\n<tr>\n<th>Classification<\/th>\n<td>stayInformed<\/td>\n<\/tr>\n<tr>\n<th>Last Updated<\/th>\n<td>07\/17\/2024 04:03:51<\/td>\n<\/tr>\n<tr>\n<th>Start Time<\/th>\n<td>07\/17\/2024 04:03:19<\/td>\n<\/tr>\n<tr>\n<th>End Time<\/th>\n<td>09\/27\/2024 07:00:00<\/td>\n<\/tr>\n<tr>\n<th>Message Content<\/th>\n<td>\n<p>Microsoft Forms offers surveys and quizzes to collect information from your audience. We have added a new feature that lets you quickly and easily sync the responses to a Microsoft Excel file so you will always have the latest responses, updated automatically.   This message applies to Excel for the web. Learn more: <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/microsoft-forms-blog\/forms-data-sync-to-excel-is-now-fully-available-with-more\/ba-p\/4177152\" target=\"_blank\" style=\"\" rel=\"noopener\">  Forms data sync to Excel is now fully available with more functionality &#8211; Microsoft Community Hub<\/a>  <\/p>\n<p>This message is associated with Microsoft 365 Roadmap ID <a href=\"https:\/\/www.microsoft.com\/microsoft-365\/roadmap?filters=&amp;searchterms=374909\" target=\"_blank\" rel=\"noopener\">  374909<\/a>.  <\/p>\n<p>[When this will happen:]  <\/p>\n<p>General Availability (Worldwide): We began rolling out in late June 2024 and expect to complete by late July 2024.  <\/p>\n<p>[How this will affect your organization:]  <\/p>\n<p><i>New features for this rollout<\/i>  <\/p>\n<ul>\n<li>Create an Excel workbook in your Microsoft OneDrive on the form\/quiz responses page.  <\/li>\n<li>Form responses will automatically sync to a table in the Excel workbook where you can start manipulating the data.  <\/li>\n<li>New responses will automatically sync while the workbook is open in Excel for the web.  <\/li>\n<li>Excel coauthors will also get automatically synced responses in Excel for the web.  <\/li>\n<\/ul>\n<p>This feature was released with the Preview label in March 2024. We are removing the preview label in July 2024.&nbsp;  <\/p>\n<p>After we remove preview label, the new data sync solution will also support two types of forms:  <\/p>\n<ul>\n<li>Group forms created in your Microsoft 365 group. Learn more: <a href=\"https:\/\/support.microsoft.com\/office\/create-a-group-form-or-quiz-7228eebb-a6ab-45ec-8123-52026a2f52ff\" target=\"_blank\" rel=\"noopener\">  Create a group form or quiz &#8211; Microsoft Support<\/a>  <\/li>\n<li>Forms created in workbooks in Excel for the web  <\/li>\n<\/ul>\n<p>Note: The data sync will be triggered while the workbook is open in Excel for the web. Over time, we will gradually enable data sync for Excel for Desktop.  <\/p>\n<p>This feature will be automatically enabled for all users who are able to use Microsoft Forms and Microsoft Excel in your organization. They can find the entry point for this feature from the Forms website and Excel for the web.  <\/p>\n<p>[What you need to do to prepare:]  <\/p>\n<p>This rollout will happen automatically by the specified date with no admin action required before the rollout. You may want to notify your users about this change and update any relevant documentation.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th>Machine Translation<\/th>\n<td>\n<p>Microsoft Forms \u3067\u306f\u3001\u5bfe\u8c61\u30e6\u30fc\u30b6\u30fc\u304b\u3089\u60c5\u5831\u3092\u53ce\u96c6\u3059\u308b\u305f\u3081\u306e\u8abf\u67fb\u3068\u30af\u30a4\u30ba\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u5fdc\u7b54\u3092Microsoft Excel\u30d5\u30a1\u30a4\u30eb\u306b\u3059\u3070\u3084\u304f\u7c21\u5358\u306b\u540c\u671f\u3067\u304d\u308b\u65b0\u6a5f\u80fd\u304c\u8ffd\u52a0\u3055\u308c\u3001\u5e38\u306b\u6700\u65b0\u306e\u5fdc\u7b54\u304c\u81ea\u52d5\u7684\u306b\u66f4\u65b0\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u306f\u3001Excel for the web\u306b\u9069\u7528\u3055\u308c\u307e\u3059\u3002\u8a73\u7d30\u60c5\u5831:  <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/microsoft-forms-blog\/forms-data-sync-to-excel-is-now-fully-available-with-more\/ba-p\/4177152\" target=\"_blank\" style=\"\" rel=\"noopener\">  Excel \u3078\u306e\u30d5\u30a9\u30fc\u30e0 \u30c7\u30fc\u30bf\u540c\u671f\u304c\u3001\u3088\u308a\u591a\u304f\u306e\u6a5f\u80fd\u3067\u5b8c\u5168\u306b\u5229\u7528\u53ef\u80fd\u306b\u306a\u308a\u307e\u3057\u305f &#8211; Microsoft \u30b3\u30df\u30e5\u30cb\u30c6\u30a3 \u30cf\u30d6<\/a>  <\/p>\n<p>\u3053\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u306f\u3001Microsoft 365 \u30ed\u30fc\u30c9\u30de\u30c3\u30d7 <a href=\"https:\/\/www.microsoft.com\/microsoft-365\/roadmap?filters=&amp;searchterms=374909\" target=\"_blank\" rel=\"noopener\">  ID 374909\u306b\u95a2\u9023\u4ed8\u3051\u3089\u308c\u3066\u3044\u307e\u3059<\/a>\u3002<\/p>\n<p>[\u3053\u308c\u304c\u3044\u3064\u8d77\u3053\u308b\u304b:]<\/p>\n<p>\u4e00\u822c\u63d0\u4f9b (\u5168\u4e16\u754c): 2024 \u5e74 6 \u6708\u4e0b\u65ec\u306b\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u3092\u958b\u59cb\u3057\u30012024 \u5e74 7 \u6708\u4e0b\u65ec\u307e\u3067\u306b\u5b8c\u4e86\u3059\u308b\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n<p>[\u3053\u308c\u304c\u3042\u306a\u305f\u306e\u7d44\u7e54\u306b\u3069\u306e\u3088\u3046\u306b\u5f71\u97ff\u3057\u307e\u3059\u304b:]<\/p>\n<p><i>\u3053\u306e\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u306e\u65b0\u6a5f\u80fd<\/i>  <\/p>\n<ul>\n<li>Microsoft OneDrive \u306e\u30d5\u30a9\u30fc\u30e0\/\u30af\u30a4\u30ba\u306e\u56de\u7b54\u30da\u30fc\u30b8\u3067 Excel \u30ef\u30fc\u30af\u30d6\u30c3\u30af\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/li>\n<li>\u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\u306f\u3001\u30c7\u30fc\u30bf\u306e\u64cd\u4f5c\u3092\u958b\u59cb\u3067\u304d\u308bExcel\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u81ea\u52d5\u7684\u306b\u540c\u671f\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>\u65b0\u3057\u3044\u5fdc\u7b54\u306f\u3001\u30d6\u30c3\u30af\u304c Excel for the web \u3067\u958b\u3044\u3066\u3044\u308b\u9593\u3001\u81ea\u52d5\u7684\u306b\u540c\u671f\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>Excel \u306e\u5171\u8457\u8005\u306f\u3001Excel for the web \u3067\u3082\u81ea\u52d5\u7684\u306b\u540c\u671f\u3055\u308c\u305f\u5fdc\u7b54\u3092\u53d7\u3051\u53d6\u308a\u307e\u3059\u3002<\/li>\n<\/ul>\n<p>\u3053\u306e\u6a5f\u80fd\u306f\u30012024 \u5e74 3 \u6708\u306b\u30d7\u30ec\u30d3\u30e5\u30fc \u30ec\u30fc\u30d9\u30eb\u3067\u30ea\u30ea\u30fc\u30b9\u3055\u308c\u307e\u3057\u305f\u3002\u30d7\u30ec\u30d3\u30e5\u30fc \u30e9\u30d9\u30eb\u306f 2024 \u5e74 7 \u6708\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002&nbsp;<\/p>\n<p>\u30d7\u30ec\u30d3\u30e5\u30fc \u30e9\u30d9\u30eb\u3092\u524a\u9664\u3057\u305f\u5f8c\u3001\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u540c\u671f\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u3001\u6b21\u306e 2 \u7a2e\u985e\u306e\u30d5\u30a9\u30fc\u30e0\u3082\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u307e\u3059\u3002<\/p>\n<ul>\n<li>Microsoft 365 \u30b0\u30eb\u30fc\u30d7\u3067\u4f5c\u6210\u3055\u308c\u305f\u30b0\u30eb\u30fc\u30d7 \u30d5\u30a9\u30fc\u30e0\u3002\u8a73\u7d30\u60c5\u5831: <a href=\"https:\/\/support.microsoft.com\/office\/create-a-group-form-or-quiz-7228eebb-a6ab-45ec-8123-52026a2f52ff\" target=\"_blank\" rel=\"noopener\">  \u30b0\u30eb\u30fc\u30d7 \u30d5\u30a9\u30fc\u30e0\u307e\u305f\u306f\u30af\u30a4\u30ba\u3092\u4f5c\u6210\u3059\u308b &#8211; Microsoft \u30b5\u30dd\u30fc\u30c8<\/a>  <\/li>\n<li>Excel for the web \u306e\u30d6\u30c3\u30af\u3067\u4f5c\u6210\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30e0<\/li>\n<\/ul>\n<p>\u6ce8: \u30c7\u30fc\u30bf\u540c\u671f\u306f\u3001\u30d6\u30c3\u30af\u304c Excel for the web \u3067\u958b\u3044\u3066\u3044\u308b\u3068\u304d\u306b\u30c8\u30ea\u30ac\u30fc\u3055\u308c\u307e\u3059\u3002\u4eca\u5f8c\u3001Excel for Desktop \u306e\u30c7\u30fc\u30bf\u540c\u671f\u3092\u5f90\u3005\u306b\u6709\u52b9\u306b\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u6a5f\u80fd\u306f\u3001\u7d44\u7e54\u5185\u3067 Microsoft Forms \u3068 Microsoft Excel \u3092\u4f7f\u7528\u3067\u304d\u308b\u3059\u3079\u3066\u306e\u30e6\u30fc\u30b6\u30fc\u306b\u5bfe\u3057\u3066\u81ea\u52d5\u7684\u306b\u6709\u52b9\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u6a5f\u80fd\u306e\u30a8\u30f3\u30c8\u30ea \u30dd\u30a4\u30f3\u30c8\u306f\u3001\u30d5\u30a9\u30fc\u30e0 Web \u30b5\u30a4\u30c8\u3068 Excel for the web \u304b\u3089\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3010\u6e96\u5099\u306b\u5fc5\u8981\u306a\u3053\u3068\u3011<\/p>\n<p>\u3053\u306e\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u306f\u3001\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u524d\u306b\u7ba1\u7406\u8005\u306e\u64cd\u4f5c\u3092\u5fc5\u8981\u3068\u305b\u305a\u306b\u3001\u6307\u5b9a\u3055\u308c\u305f\u65e5\u4ed8\u307e\u3067\u306b\u81ea\u52d5\u7684\u306b\u884c\u308f\u308c\u307e\u3059\u3002\u3053\u306e\u5909\u66f4\u306b\u3064\u3044\u3066\u30e6\u30fc\u30b6\u30fc\u306b\u901a\u77e5\u3057\u3001\u95a2\u9023\u3059\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u66f4\u65b0\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MC816207 | Microsoft Forms now supports live data sync to Microsoft Excel with more functionality Classificati [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7359","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/7359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/comments?post=7359"}],"version-history":[{"count":0,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/7359\/revisions"}],"wp:attachment":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/media?parent=7359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/categories?post=7359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/tags?post=7359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}