{"id":33309,"date":"2012-06-11T15:37:55","date_gmt":"2012-06-11T15:37:55","guid":{"rendered":"https:\/\/www.pcmatic.com\/blog\/?p=33309"},"modified":"2012-06-11T15:37:55","modified_gmt":"2012-06-11T15:37:55","slug":"excel-tips-net-importing-multiple-files-to-a-single-workbook","status":"publish","type":"post","link":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/","title":{"rendered":"Excel.Tips.Net: Importing Multiple Files to a Single Workbook"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/20110928exceltips.jpg\" alt=\"\" title=\"exceltips\" width=\"150\" height=\"150\" class=\"attachment wp-att-7652 alignleft\" \/><\/p>\n<p>By Allen Wyatt for Excel.Tips.Net<\/p>\n<h3>Importing Multiple Files to a Single Workbook<\/h3>\n<p>Let&#8217;s say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.<\/p>\n<p>One way to do this is to manually add the desired worksheets, and then individually import each of the text files. This, as you can imagine, would quickly get tedious. A much better solution is to use a macro to do the importing, such as the following one.<\/p>\n<p><em>Sub CombineTextFiles()<br \/>\n    Dim FilesToOpen<br \/>\n    Dim x As Integer<br \/>\n    Dim wkbAll As Workbook<br \/>\n    Dim wkbTemp As Workbook<br \/>\n    Dim sDelimiter As String<\/p>\n<p>    On Error GoTo ErrHandler<br \/>\n    Application.ScreenUpdating = False<\/p>\n<p>    sDelimiter = &#8220;|&#8221;<\/p>\n<p>    FilesToOpen = Application.GetOpenFilename _<br \/>\n      (FileFilter:=&#8221;Text Files (*.txt), *.txt&#8221;, _<br \/>\n      MultiSelect:=True, Title:=&#8221;Text Files to Open&#8221;)<\/p>\n<p>    If TypeName(FilesToOpen) = &#8220;Boolean&#8221; Then<br \/>\n        MsgBox &#8220;No Files were selected&#8221;<br \/>\n        GoTo ExitHandler<br \/>\n    End If<\/p>\n<p>    x = 1<br \/>\n    Set wkbTemp = Workbooks.Open(FileName:=FilesToOpen(x))<br \/>\n    wkbTemp.Sheets(1).Copy<br \/>\n    Set wkbAll = ActiveWorkbook<br \/>\n    wkbTemp.Close (False)<br \/>\n    wkbAll.Worksheets(x).Columns(&#8220;A:A&#8221;).TextToColumns _<br \/>\n      Destination:=Range(&#8220;A1&#8243;), DataType:=xlDelimited, _<br \/>\n      TextQualifier:=xlDoubleQuote, _<br \/>\n      ConsecutiveDelimiter:=False, _<br \/>\n      Tab:=False, Semicolon:=False, _<br \/>\n      Comma:=False, Space:=False, _<br \/>\n      Other:=True, OtherChar:=&#8221;|&#8221;<br \/>\n    x = x + 1<\/p>\n<p>    While x <= UBound(FilesToOpen)\n        Set wkbTemp = Workbooks.Open(FileName:=FilesToOpen(x))\n        With wkbAll\n            wkbTemp.Sheets(1).Move After:=.Sheets(.Sheets.Count)\n            .Worksheets(x).Columns(\"A:A\").TextToColumns _\n              Destination:=Range(\"A1\"), DataType:=xlDelimited, _\n              TextQualifier:=xlDoubleQuote, _\n              ConsecutiveDelimiter:=False, _\n              Tab:=False, Semicolon:=False, _\n              Comma:=False, Space:=False, _\n              Other:=True, OtherChar:=sDelimiter\n        End With\n        x = x + 1\n    Wend\n\nExitHandler:\n    Application.ScreenUpdating = True\n    Set wkbAll = Nothing\n    Set wkbTemp = Nothing\n    Exit Sub\n\nErrHandler:\n    MsgBox Err.Description\n    Resume ExitHandler\nEnd Sub <\/em><\/p>\n<p><\/BR CLEAR=ALL><\/p>\n<h3><a href=\"http:\/\/excelribbon.tips.net\/T010400_Importing_Multiple_Files_to_a_Single_Workbook.html\" target=\"_blank\">Article Continued Here<\/a><\/h3>\n","protected":false},"excerpt":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/techtalk.pcpitstop.com\/wp-content\/uploads\/20110928exceltips.jpg\" alt=\"\" title=\"exceltips\" width=\"150\" height=\"150\" class=\"attachment wp-att-7652 alignleft\" \/><\/p>\n<p>Let&#8217;s say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.<\/p>\n","protected":false},"author":29,"featured_media":66012,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[733],"tags":[735,827],"class_list":["post-33309","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tips","tag-microsoft-excel","tag-microsoft-excel-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel.Tips.Net: Importing Multiple Files to a Single Workbook<\/title>\n<meta name=\"description\" content=\"Let&#039;s say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel.Tips.Net: Importing Multiple Files to a Single Workbook\" \/>\n<meta property=\"og:description\" content=\"Let&#039;s say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/\" \/>\n<meta property=\"og:site_name\" content=\"PC Matic Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pcmatic\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-11T15:37:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/pcmatic-fallback.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excel Tips\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pcmatic\" \/>\n<meta name=\"twitter:site\" content=\"@pcmatic\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excel Tips\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/\"},\"author\":{\"name\":\"Excel Tips\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0f9f5c962d979029f4d178721dbaafd\"},\"headline\":\"Excel.Tips.Net: Importing Multiple Files to a Single Workbook\",\"datePublished\":\"2012-06-11T15:37:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/\"},\"wordCount\":231,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/wp-content\\\/uploads\\\/pcmatic-fallback.png\",\"keywords\":[\"Microsoft Excel\",\"Microsoft Excel Tips\"],\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/\",\"url\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/\",\"name\":\"Excel.Tips.Net: Importing Multiple Files to a Single Workbook\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/wp-content\\\/uploads\\\/pcmatic-fallback.png\",\"datePublished\":\"2012-06-11T15:37:55+00:00\",\"description\":\"Let's say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/wp-content\\\/uploads\\\/pcmatic-fallback.png\",\"contentUrl\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/wp-content\\\/uploads\\\/pcmatic-fallback.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/excel-tips-net-importing-multiple-files-to-a-single-workbook\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel.Tips.Net: Importing Multiple Files to a Single Workbook\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/\",\"name\":\"PC Matic Blog\",\"description\":\"Tech Tips and Tricks\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#organization\",\"name\":\"PC Matic - Top Antivirus Company in the USA.\",\"url\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/techtalk.pcmatic.com\\\/wp-content\\\/uploads\\\/PC-MaticLogo-e1472689639222.png\",\"contentUrl\":\"https:\\\/\\\/techtalk.pcmatic.com\\\/wp-content\\\/uploads\\\/PC-MaticLogo-e1472689639222.png\",\"width\":1535,\"height\":483,\"caption\":\"PC Matic - Top Antivirus Company in the USA.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pcmatic\",\"https:\\\/\\\/x.com\\\/pcmatic\",\"https:\\\/\\\/www.instagram.com\\\/pcmaticusa\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/pcmatic\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/PCMaticVideo\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0f9f5c962d979029f4d178721dbaafd\",\"name\":\"Excel Tips\",\"description\":\"The tips and ideas from ExcelRibbon.Tips.Net are designed specifically for users of Excel starting with Excel 2007. You'll find just about everything you need to become productive with the program right away. (If you need help with other versions of Excel, visit the ExcelTips site.)\",\"sameAs\":[\"http:\\\/\\\/excelribbon.tips.net\\\/\"],\"url\":\"https:\\\/\\\/www.pcmatic.com\\\/blog\\\/author\\\/exceltips\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel.Tips.Net: Importing Multiple Files to a Single Workbook","description":"Let's say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/","og_locale":"en_US","og_type":"article","og_title":"Excel.Tips.Net: Importing Multiple Files to a Single Workbook","og_description":"Let's say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.","og_url":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/","og_site_name":"PC Matic Blog","article_publisher":"https:\/\/www.facebook.com\/pcmatic","article_published_time":"2012-06-11T15:37:55+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/pcmatic-fallback.png","type":"image\/png"}],"author":"Excel Tips","twitter_card":"summary_large_image","twitter_creator":"@pcmatic","twitter_site":"@pcmatic","twitter_misc":{"Written by":"Excel Tips","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#article","isPartOf":{"@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/"},"author":{"name":"Excel Tips","@id":"https:\/\/www.pcmatic.com\/blog\/#\/schema\/person\/d0f9f5c962d979029f4d178721dbaafd"},"headline":"Excel.Tips.Net: Importing Multiple Files to a Single Workbook","datePublished":"2012-06-11T15:37:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/"},"wordCount":231,"commentCount":0,"publisher":{"@id":"https:\/\/www.pcmatic.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/pcmatic-fallback.png","keywords":["Microsoft Excel","Microsoft Excel Tips"],"articleSection":["Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/","url":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/","name":"Excel.Tips.Net: Importing Multiple Files to a Single Workbook","isPartOf":{"@id":"https:\/\/www.pcmatic.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#primaryimage"},"image":{"@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/pcmatic-fallback.png","datePublished":"2012-06-11T15:37:55+00:00","description":"Let's say that you have a folder on your hard drive that contains thirty text files, and you want to import all of them to an Excel workbook. You want each text file to end up on its own worksheet in the workbook, so that you will have a total of thirty worksheets.","breadcrumb":{"@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#primaryimage","url":"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/pcmatic-fallback.png","contentUrl":"https:\/\/www.pcmatic.com\/blog\/wp-content\/uploads\/pcmatic-fallback.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.pcmatic.com\/blog\/excel-tips-net-importing-multiple-files-to-a-single-workbook\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pcmatic.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel.Tips.Net: Importing Multiple Files to a Single Workbook"}]},{"@type":"WebSite","@id":"https:\/\/www.pcmatic.com\/blog\/#website","url":"https:\/\/www.pcmatic.com\/blog\/","name":"PC Matic Blog","description":"Tech Tips and Tricks","publisher":{"@id":"https:\/\/www.pcmatic.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pcmatic.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pcmatic.com\/blog\/#organization","name":"PC Matic - Top Antivirus Company in the USA.","url":"https:\/\/www.pcmatic.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pcmatic.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/techtalk.pcmatic.com\/wp-content\/uploads\/PC-MaticLogo-e1472689639222.png","contentUrl":"https:\/\/techtalk.pcmatic.com\/wp-content\/uploads\/PC-MaticLogo-e1472689639222.png","width":1535,"height":483,"caption":"PC Matic - Top Antivirus Company in the USA."},"image":{"@id":"https:\/\/www.pcmatic.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pcmatic","https:\/\/x.com\/pcmatic","https:\/\/www.instagram.com\/pcmaticusa\/","https:\/\/www.linkedin.com\/company\/pcmatic","https:\/\/www.youtube.com\/c\/PCMaticVideo"]},{"@type":"Person","@id":"https:\/\/www.pcmatic.com\/blog\/#\/schema\/person\/d0f9f5c962d979029f4d178721dbaafd","name":"Excel Tips","description":"The tips and ideas from ExcelRibbon.Tips.Net are designed specifically for users of Excel starting with Excel 2007. You'll find just about everything you need to become productive with the program right away. (If you need help with other versions of Excel, visit the ExcelTips site.)","sameAs":["http:\/\/excelribbon.tips.net\/"],"url":"https:\/\/www.pcmatic.com\/blog\/author\/exceltips\/"}]}},"_links":{"self":[{"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/posts\/33309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/comments?post=33309"}],"version-history":[{"count":0,"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/posts\/33309\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/media\/66012"}],"wp:attachment":[{"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/media?parent=33309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/categories?post=33309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pcmatic.com\/blog\/wp-json\/wp\/v2\/tags?post=33309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}