{"id":2949,"date":"2020-04-10T17:33:25","date_gmt":"2020-04-10T09:33:25","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=2949"},"modified":"2020-04-10T17:33:25","modified_gmt":"2020-04-10T09:33:25","slug":"put-the-form-into-excel-from-webpage","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=2949","title":{"rendered":"Put the form into excel from webpage"},"content":{"rendered":"\n<p>Everyone encounter the situation that when you surfing online, but there are many kinds of web pages. We need to put them in Excel one by one to sort them out. It&#8217;s very difficult. The technology guys. can analyze the website and do reptiles. Is there no good way for new hand?<\/p>\n\n\n\n<p>Have you ever encountered the awkward moment in the following animation? Now teaching you to solve above problem in one minute.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"556\" height=\"467\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/1.jpg\" alt=\"\" class=\"wp-image-2948\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/1.jpg 556w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/1-300x252.jpg 300w\" sizes=\"auto, (max-width: 556px) 100vw, 556px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>step 1<\/strong><\/h4>\n\n\n\n<p>Ctrl+C the web links<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"125\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/2.jpg\" alt=\"\" class=\"wp-image-2941\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/2.jpg 577w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/2-300x65.jpg 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 2<\/strong><\/h4>\n\n\n\n<p>In excel 2013 DATA tab, find \u201cfrom website\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"406\" height=\"125\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/3.jpg\" alt=\"\" class=\"wp-image-2942\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/3.jpg 406w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/3-300x92.jpg 300w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Step 3<\/h4>\n\n\n\n<p>Paste the URL into the pop-up dialog box, click &#8220;Go&#8221;, then find the table you want to import in the opened webpage, click the small yellow button (follow the operation below) to import it!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"330\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/4.jpg\" alt=\"\" class=\"wp-image-2943\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/4.jpg 640w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/4-300x155.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Step 4<\/h4>\n\n\n\n<p>Done!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"537\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/5.jpg\" alt=\"\" class=\"wp-image-2944\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/5.jpg 693w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/5-300x232.jpg 300w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><\/figure>\n\n\n\n<p>Benefit\uff1a if the website data update, you can click the form, Click \u201cRefresh\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"564\" height=\"554\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/6.jpg\" alt=\"\" class=\"wp-image-2945\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/6.jpg 564w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2020\/04\/6-300x295.jpg 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Everyone encounter the situation that when you surfing  &#8230; <a title=\"Put the form into excel from webpage\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=2949\" aria-label=\"\u9605\u8bfb Put the form into excel from webpage\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2949","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":1960,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2949"}],"version-history":[{"count":1,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2949\/revisions"}],"predecessor-version":[{"id":2950,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2949\/revisions\/2950"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}