{"id":23357,"date":"2023-10-26T18:27:27","date_gmt":"2023-10-26T16:27:27","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/how-to-extract-the-inc-5000-list-2023-into-excel\/"},"modified":"2023-10-26T18:27:27","modified_gmt":"2023-10-26T16:27:27","slug":"how-to-extract-the-inc-5000-list-2023-into-excel","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/how-to-extract-the-inc-5000-list-2023-into-excel\/","title":{"rendered":"How To Extract The Inc 5000 List (2023) Into Excel?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi there, I have seen a few questions on past year&#8217;s lists and Excel sheets but I couldn&#8217;t get the R code to work for the 2023 set. I&#8217;m not sure if its because I do not have the correct link format or what..<br \/> Here is the website I am taking the data from: <a href=\"https:\/\/www.inc.com\/inc5000\/2023\">https:\/\/www.inc.com\/inc5000\/2023<\/a> <\/p>\n<p>This is the Reddit post I tried to follow on R: <a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/wr3vyz\/trying_to_extract_inc_5000_2022_list_to_excel\/\">https:\/\/www.reddit.com\/r\/datasets\/comments\/wr3vyz\/trying_to_extract_inc_5000_2022_list_to_excel\/<\/a><br \/> More specifically I followed this code: <a href=\"https:\/\/gist.github.com\/MattSandy\/14242b5af9dce69102647e2000848bcc\">https:\/\/gist.github.com\/MattSandy\/14242b5af9dce69102647e2000848bcc<\/a><\/p>\n<p>\u200b<\/p>\n<p>When I tried to follow the above code I just substituted 2022 for 2023 and crossed my fingers which did not work. I can post my R error codes or the exact code I wrote if that is helpful.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Character-Forever382\"> \/u\/Character-Forever382 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/17gzoeo\/how_to_extract_the_inc_5000_list_2023_into_excel\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/17gzoeo\/how_to_extract_the_inc_5000_list_2023_into_excel\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-23357 jlk' href='javascript:void(0)' data-task='like' data-post_id='23357' data-nonce='614a020375' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-23357 lc'>0<\/span><\/a><\/div><\/div> <div class='status-23357 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi there, I have seen a few questions on past year&#8217;s lists and Excel sheets but I&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-23357","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/23357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=23357"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/23357\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=23357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=23357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=23357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}