{"id":18,"date":"2021-04-08T15:58:18","date_gmt":"2021-04-08T15:58:18","guid":{"rendered":"https:\/\/excelforgbs.com\/?page_id=18"},"modified":"2022-06-10T17:08:01","modified_gmt":"2022-06-10T17:08:01","slug":"getting-data-into-excel","status":"publish","type":"page","link":"https:\/\/excelforgbs.com\/?page_id=18","title":{"rendered":"Getting Data into Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Data can be moved into Excel and then all of the capabilities of Excel can be used to modify and format the data.  Since Excel is stored in a similar format as webpages, often highlighting and copying data from a web source will allow you to easily paste that information into a spreadsheet.  There are some ways to also bring data into a spreadsheet when the usual copy-paste does not result in appropriate columns and rows.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With data like this, there is often a need to manipulate the text data to make the format appropriate.  Those functions are found here, <a href=\"https:\/\/excelforgbs.com\/?page_id=186\">on the Text Functions page.<\/a><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/excelforgbs.com\/?p=156\">Text to Columns to format columns correctly<\/a><\/li><li><a href=\"https:\/\/excelforgbs.com\/?p=219\">Filter command<\/a><\/li><li><a href=\"https:\/\/excelforgbs.com\/?p=222\">Data Analysis Tools calculation of descriptive statistics<\/a><\/li><li><a href=\"https:\/\/excelforgbs.com\/?p=225\">Using Excel statistics functions for descriptive statistics<\/a><\/li><li><a href=\"https:\/\/excelforgbs.com\/?p=276\">Regression Tool<\/a><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/excelforgbs.com\/?page_id=245\">Next Page: Graphs<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data can be moved into Excel and then all of the capabilities of Excel can be used to modify and format the data. Since Excel is stored in a similar format as webpages, often highlighting and copying data from a web source will allow you to easily paste that information into a spreadsheet. There are &hellip; <a href=\"https:\/\/excelforgbs.com\/?page_id=18\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Getting Data into Excel<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4,"menu_order":40,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"footnotes":""},"class_list":["post-18","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18"}],"version-history":[{"count":5,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/18\/revisions"}],"predecessor-version":[{"id":320,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/18\/revisions\/320"}],"up":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/4"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}