{"id":6976,"date":"2025-01-15T14:20:21","date_gmt":"2025-01-15T14:20:21","guid":{"rendered":"https:\/\/howtogeek.blog\/lt\/?p=6976"},"modified":"2025-01-15T14:20:21","modified_gmt":"2025-01-15T14:20:21","slug":"automated-syncing-of-microsoft-forms-data-to-excel","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lt\/automated-syncing-of-microsoft-forms-data-to-excel\/","title":{"rendered":"Automatizuotas \u201eMicrosoft Forms\u201c duomen\u0173 sinchronizavimas su \u201eExcel\u201c."},"content":{"rendered":"<h2>Sklandus \u201eMicrosoft\u201c form\u0173 sinchronizavimas su \u201eExcel\u201c.<\/h2>\n<p>Ar naudojate \u201eMicrosoft Forms\u201c duomenims rinkti ir norite analizuoti tuos duomenis realiuoju laiku? Tau pasisek\u0117! \u201eMicrosoft Forms\u201c si\u016blo tiesioginio sinchronizavimo su \u201eMicrosoft Excel\u201c galimybes, leid\u017eian\u010dias lengvai per\u017ei\u016br\u0117ti ir valdyti naujus atsakymus, kai jie gaunami.<\/p>\n<p>Nesvarbu, ar esate pedagogas, verslo profesionalas ar duomen\u0173 analitikas, \u0161is vadovas pad\u0117s efektyviai sinchronizuoti \u201eMicrosoft Forms\u201c su \u017einiatinklio \u201eExcel\u201c ir \u201eExcel\u201c darbalaukio programa, u\u017etikrinant skland\u017ei\u0105 duomen\u0173 analiz\u0119. Pasinerkime!<\/p>\n<h2 id=\"syncing-microsoft-forms-with-excel-for-the-web\">\u201eMicrosoft\u201c form\u0173 sinchronizavimas su \u201eExcel\u201c \u017einiatinkliui<\/h2>\n<p>Jei jums labiau patinka dirbti debes\u0173 aplinkoje, \u0161is metodas jums idealiai tinka. Atlikite \u0161iuos veiksmus, nor\u0117dami sinchronizuoti atsakymus i\u0161 \u201eMicrosoft Forms\u201c tiesiai \u012f \u201eExcel\u201c, skirt\u0105 \u017einiatinkliui.<\/p>\n<h3 id=\"step-1-create-and-share-your-microsoft-form\">1 veiksmas: sukurkite ir bendrinkite savo \u201eMicrosoft\u201c form\u0105<\/h3>\n<p>Prad\u0117kite kurdami form\u0105 naudodami <a href=\"https:\/\/forms.office.com\/\" rel=\"noopener noreferrer\" target=\"_blank\">Microsoft Forms<\/a> . Suteikite jam patraukl\u0173 pavadinim\u0105 ir apra\u0161\u0105 pasirinkdami \u012fvairius klausim\u0173 tipus, kad patenkintum\u0117te duomen\u0173 rinkimo poreikius.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Pirmasis pavyzdin\u0117s HTG apklausos \u201eMicrosoft Forms\u201c klausimas.\" class=\"wp-image\" decoding=\"async\" height=\"415\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-first-question-of-a-sample-htg-survey-in-microsoft-forms.webp\" title=\"Pirmasis pavyzdin\u0117s HTG apklausos \u201eMicrosoft Forms\u201c klausimas.\" width=\"895\"\/><\/figure>\n<p>\u012evesdami i\u0161sami\u0105 informacij\u0105 atminkite, kad forma automati\u0161kai i\u0161saugoma \u201eOneDrive\u201c. U\u017epild\u0119 form\u0105 \u012fsitikinkite, kad visi pagrindiniai klausimai pa\u017eym\u0117ti kaip \u201eReikalingi\u201c. \u0160is veiksmas yra labai svarbus norint v\u0117liau tiksliai analizuoti duomenis.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Prie klausimo \u201eMicrosoft Forms\u201c \u012fjungtas Reikalingas perjungimas.\" class=\"wp-image\" decoding=\"async\" height=\"130\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-required-toggle-next-to-a-question-in-microsoft-forms-is-turned-on.webp\" title=\"Prie klausimo \u201eMicrosoft Forms\u201c \u012fjungtas Reikalingas perjungimas.\" width=\"750\"\/><\/figure>\n<p>Tada spustel\u0117kite \u201eRinkti atsakymus\u201c ir pasirinkite pageidaujam\u0105 platinimo b\u016bd\u0105: tiesiogin\u0119 nuorod\u0105, kvietim\u0105 el. pa\u0161tu, QR kod\u0105, svetain\u0117s \u012fterpim\u0105 arba bendrinim\u0105 socialiniuose tinkluose.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u012evairios formos platinimo Microsoft Forms parinktys.\" class=\"wp-image\" decoding=\"async\" height=\"255\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-different-options-for-distributing-a-form-in-microsoft-forms.webp\" title=\"\u012evairios formos platinimo Microsoft Forms parinktys.\" width=\"750\"\/><\/figure>\n<p>Jei pasirenkate URL, patikrinkite \u201eSutrumpinti URL\u201c, kad jis b\u016bt\u0173 trumpas. Prie\u0161 si\u0173sdami tinkinkite el. pa\u0161to kvietim\u0105, kad jis b\u016bt\u0173 patrauklesnis.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Formos platinimo Microsoft Forms URL ir el. pa\u0161to parinktys yra pary\u0161kintos.\" class=\"wp-image\" decoding=\"async\" height=\"628\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-url-and-email-options-for-distributing-a-form-in-microsoft-forms-are-highlighted.webp\" title=\"Formos platinimo Microsoft Forms URL ir el. pa\u0161to parinktys yra pary\u0161kintos.\" width=\"750\"\/><\/figure>\n<h3 id=\"step-2-view-edit-and-use-the-responses-in-excel-for-the-web\">2 veiksmas: per\u017ei\u016br\u0117kite, redaguokite ir naudokite \u201eExcel\u201c \u017einiatinkliui atsakymus<\/h3>\n<p>Kai bus \u012fvesti \u012fra\u0161ai, \u201eMicrosoft Forms\u201c s\u0105sajoje \u0161alia mygtuko \u201ePer\u017ei\u016br\u0117ti atsakymus\u201c bus rodomas skai\u010dius. Spustel\u0117jus j\u012f, matomi i\u0161sam\u016bs rezultatai.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eMicrosoft Forms\u201c mygtukas Per\u017ei\u016br\u0117ti atsakymus, o skai\u010dius 15 nurodo gautus atsakymus.\" class=\"wp-image\" decoding=\"async\" height=\"226\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-view-responses-button-in-microsoft-forms-with-the-number-15-indicating-the-responses-received.webp\" title=\"\u201eMicrosoft Forms\u201c mygtukas Per\u017ei\u016br\u0117ti atsakymus, o skai\u010dius 15 nurodo gautus atsakymus.\" width=\"750\"\/><\/figure>\n<p>\u010cia galite per\u017ei\u016br\u0117ti atsakymus tiesiogiai nar\u0161ykl\u0117je arba, nor\u0117dami atlikti i\u0161samesn\u0119 analiz\u0119, atidaryti juos \u017einiatinklio \u201eExcel\u201c spustel\u0117dami atitinkamo failo pavadinim\u0105 skiltyje \u201e\u012e\u017evalgos ir veiksmai\u201c. \u0160i funkcija leid\u017eia nedelsiant manipuliuoti duomenimis.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Du b\u016bdai analizuoti atsakymus Microsoft formoje. Pirmasis yra nar\u0161ykl\u0117je, o antrasis - naudojant \u201eExcel\u201c \u017einiatinklio nuorod\u0105.\" class=\"wp-image\" decoding=\"async\" height=\"522\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/two-ways-to-analyze-responses-in-a-microsoft-form-the-first-is-in-the-browser-and-the-second-is-via-the-excel-for-the-web-link.webp\" title=\"Du b\u016bdai analizuoti atsakymus Microsoft formoje. Pirmasis yra nar\u0161ykl\u0117je, o antrasis - naudojant \u201eExcel\u201c \u017einiatinklio nuorod\u0105.\" width=\"750\"\/><\/figure>\n<p>Dabar j\u016bs\u0173 duomenys bus rodomi gerai sutvarkytoje lentel\u0117je. Galb\u016bt nor\u0117site tinkinti savo i\u0161d\u0117stym\u0105 \u2013 pa\u0161alinti nereikalingus stulpelius arba pakoreguoti antra\u0161tes, kad b\u016bt\u0173 ai\u0161kumo. Galite anuliuoti bet kokius formatavimo pakeitimus naudodami <code>Ctrl+Z<\/code>, bet atminkite, kad pakeitimai i\u0161saugomi ir u\u017edar\u0119 lang\u0105 negal\u0117site gr\u0105\u017einti.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c \u017einiatinklio langui, kuriame rodomi \u201eMicrosoft\u201c formos rezultatai.\" class=\"wp-image\" decoding=\"async\" height=\"205\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/synced-results.webp\" title=\"\u201eExcel\u201c \u017einiatinklio langui, kuriame rodomi \u201eMicrosoft\u201c formos rezultatai.\" width=\"1101\"\/><\/figure>\n<p>Nor\u0117dami priskirti vaizdin\u012f duomen\u0173 atvaizdavim\u0105, \u012fterpkite diagramas taip, kaip darytum\u0117te darbalaukio programoje. Pa\u017eym\u0117kite norimus duomenis, spustel\u0117kite \u201e\u012eterpti\u201c ir i\u0161skleid\u017eiamajame meniu pasirinkite diagramos tip\u0105. Did\u017eiausias prana\u0161umas yra tas, kad bet kokie nauji \u012fra\u0161ai automati\u0161kai atnaujins diagramas realiuoju laiku \u2013 nereikia atnaujinti rankiniu b\u016bdu!<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c \u017einiatinklio langui, kuriame rodomi pary\u0161kinti duomenys ir \u012fvairios diagram\u0173 parinktys, kurias galima pasirinkti.\" class=\"wp-image\" decoding=\"async\" height=\"508\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/add-charts.webp\" title=\"\u201eExcel\u201c \u017einiatinklio langui, kuriame rodomi pary\u0161kinti duomenys ir \u012fvairios diagram\u0173 parinktys, kurias galima pasirinkti.\" width=\"1415\"\/><\/figure>\n<h2 id=\"syncing-microsoft-forms-with-excel-39-s-desktop-app\">\u201eMicrosoft\u201c form\u0173 sinchronizavimas su \u201eExcel\u201c darbalaukio programa<\/h2>\n<p>Nuo 2024 m. pabaigos \u201eMicrosoft\u201c patobulino sinchronizavimo funkcijas, \u012ftraukdama \u201eExcel\u201c darbalaukio program\u0105. Dabar \u201eExcel\u201c juostel\u0117je yra speciali Forms integracija, skirta supaprastinti darbo eig\u0105.<\/p>\n<p>\u0160is metodas yra ypa\u010d naudingas, jei norite naudoti pa\u017eangius duomen\u0173 tvarkymo \u012frankius, kuriuos gali pasi\u016blyti tik darbalaukio versija. \u012esitikinkite, kad turite \u201eMicrosoft 365\u201c prenumerat\u0105, kad gautum\u0117te naujausias funkcijas.<\/p>\n<p>Nor\u0117dami sinchronizuoti formas \u201eExcel\u201c darbalaukio programoje, eikite \u012f \u201e\u012eterpti\u201c, tada pasirinkite i\u0161skleid\u017eiam\u0105j\u012f meniu \u201eFormos\u201c ir spustel\u0117kite \u201eNauja forma\u201c.<\/p>\n<p>Parinktis \u201eNauja forma\u201c bus pasiekiama tik tada, kai \u012fra\u0161ysite darbaknyg\u0119 ir \u012fjungsite automatin\u012f i\u0161saugojim\u0105; tai labai svarbu, nes tai leid\u017eia integruoti su OneDrive.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Parinktis Nauja forma Microsoft Excel skirtuko \u012eterpti i\u0161skleid\u017eiamajame meniu Formos.\" class=\"wp-image\" decoding=\"async\" height=\"280\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-new-form-option-in-the-forms-drop-down-of-the-insert-tab-in-microsoft-excel.webp\" title=\"Parinktis Nauja forma Microsoft Excel skirtuko \u012eterpti i\u0161skleid\u017eiamajame meniu Formos.\" width=\"750\"\/><\/figure>\n<p>Spustel\u0117jus \u201eNauja forma\u201c, atsidarys langas, kuriame gal\u0117site sukurti \u201eMicrosoft\u201c form\u0105 tiesiogiai \u201eExcel\u201c. J\u016bs\u0173 klausimai bus automati\u0161kai sinchronizuojami \u012f pirm\u0105sias skai\u010diuokl\u0117s eilutes, kai \u012fvesite tekst\u0105.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel-Forms\u201c integravimo langas, kuriame \u201eExcel\u201c lape yra ta pati informacija kaip ir lange Forms.\" class=\"wp-image\" decoding=\"async\" height=\"602\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-excel-forms-integration-window-with-the-excel-sheet-containing-the-same-details-as-the-forms-window.webp\" title=\"\u201eExcel-Forms\u201c integravimo langas, kuriame \u201eExcel\u201c lape yra ta pati informacija kaip ir lange Forms.\" width=\"985\"\/><\/figure>\n<p>Naudodami Formos piktogram\u0105 galite per\u017ei\u016br\u0117ti, redaguoti arba i\u0161si\u0173sti form\u0105 respondentams nei\u0161eidami i\u0161 programos Excel.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c i\u0161skleid\u017eiamajame meniu Formos parinktys \u201ePer\u017ei\u016br\u0117ti form\u0105\u201c, \u201eRedaguoti form\u0105\u201c ir \u201eSi\u0173sti form\u0105\u201c yra pary\u0161kintos.\" class=\"wp-image\" decoding=\"async\" height=\"289\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-preview-form-edit-form-and-send-form-options-in-excel-s-forms-drop-down-menu-are-highlighted.webp\" title=\"\u201eExcel\u201c i\u0161skleid\u017eiamajame meniu Formos parinktys \u201ePer\u017ei\u016br\u0117ti form\u0105\u201c, \u201eRedaguoti form\u0105\u201c ir \u201eSi\u0173sti form\u0105\u201c yra pary\u0161kintos.\" width=\"750\"\/><\/figure>\n<p>Pateikus atsakymus jie bus skland\u017eiai rodomi \u201eExcel\u201c skai\u010diuokl\u0117je. Pana\u0161iai kaip \u201eExcel\u201c \u017einiatinkliui, galite kurti diagramas ir koreguoti formatavim\u0105, kad gautum\u0117te i\u0161sam\u0173 vaizd\u0105.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Atsakymai \u012f \u201eMicrosoft Form\u201c form\u0105 \u201eExcel\u201c darbalaukio darbalapyje.\" class=\"wp-image\" decoding=\"async\" height=\"174\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/responses-to-a-microsoft-form-form-in-an-excel-desktop-worksheet.webp\" title=\"Atsakymai \u012f \u201eMicrosoft Form\u201c form\u0105 \u201eExcel\u201c darbalaukio darbalapyje.\" width=\"898\"\/><\/figure>\n<p>Nesvarbu, kuri\u0105 platform\u0105 pasirinksite kurdami form\u0105, b\u016bkite tikri, kad j\u016bs\u0173 duomenys ir toliau bus dinami\u0161kai sinchronizuojami tol, kol forma bus atvira atsakymams ir bus \u012fjungtas automatinis i\u0161saugojimas.<\/p>\n<p>Naudodami galingus \u201eMicrosoft Forms\u201c ir \u201eExcel\u201c \u012frankius ir funkcijas, duomen\u0173 rinkimo ir analiz\u0117s proces\u0105 galite paversti supaprastinta, efektyvia darbo eiga!<\/p>\n<h2>DUK<\/h2>\n<h3><strong>1. Ar galiu sinchronizuoti atsakymus i\u0161 \u201eMicrosoft Forms\u201c su \u201eExcel\u201c be \u201eMicrosoft 365\u201c prenumeratos?<\/strong><\/h3>\n<p>Ne, jums reik\u0117s \u201eMicrosoft 365\u201c prenumeratos, kad gal\u0117tum\u0117te pasiekti visas \u201eExcel\u201c darbalaukio programos funkcijas ir integracij\u0105 su \u201eMicrosoft Forms\u201c.<\/p>\n<h3><strong>2. Ar galima analizuoti atsakymus Excel neprisijungus?<\/strong><\/h3>\n<p>Atsakymus galima analizuoti neprisijungus naudojant \u201eExcel\u201c darbalaukio program\u0105, kai jie bus sinchronizuoti, bet nauji atsakymai nebus atnaujinti, kol v\u0117l neprisijungsite prie interneto.<\/p>\n<h3><strong>3. K\u0105 daryti, jei \u201eExcel\u201c nematau atsakym\u0173?<\/strong><\/h3>\n<p>\u012esitikinkite, kad \u201eMicrosoft\u201c forma vis dar priima atsakymus ir kad \u201eExcel\u201c \u012fjungtas automatinis i\u0161saugojimas. Taip pat patikrinkite savo interneto ry\u0161\u012f.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/www.howtogeek.com\/how-to-automatically-sync-microsoft-forms-with-excel-online\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\u0160altinis ir vaizdai<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sklandus \u201eMicrosoft\u201c form\u0173 sinchronizavimas su \u201eExcel\u201c. Ar naudojate \u201eMicrosoft Forms\u201c duomenims rinkti ir norite analizuoti tuos duomenis realiuoju laiku? Tau pasisek\u0117! \u201eMicrosoft Forms\u201c si\u016blo tiesioginio sinchronizavimo su \u201eMicrosoft Excel\u201c galimybes, leid\u017eian\u010dias lengvai per\u017ei\u016br\u0117ti ir valdyti naujus atsakymus, kai jie gaunami. Nesvarbu, ar esate pedagogas, verslo profesionalas ar duomen\u0173 analitikas, \u0161is vadovas pad\u0117s efektyviai sinchronizuoti \u201eMicrosoft [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[123,867,282,9],"class_list":["post-6976","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-365","tag-microsoft-excel","tag-windows"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/6976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/comments?post=6976"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/6976\/revisions"}],"predecessor-version":[{"id":6977,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/6976\/revisions\/6977"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/media?parent=6976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/categories?post=6976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/tags?post=6976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}