{"id":1475,"date":"2018-03-06T08:39:58","date_gmt":"2018-03-06T14:39:58","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=1475"},"modified":"2021-07-22T07:43:44","modified_gmt":"2021-07-22T12:43:44","slug":"multiple-spreadsheets-one-table","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/","title":{"rendered":"How to merge multiple Spreadsheets with a similar structure into One Table"},"content":{"rendered":"<p>If your Excel file contains multiple spreadsheets with a very similar structure, this article is for you.<\/p>\n<p>Whenever you started a new month data entry or added a new branch, you naturally added yet another spreadsheet to your Excel file, even though a new sheet data structure was still very similar to previous ones, if not even identical.<\/p>\n<p>This is a very typical situation for businesses utilizing an Excel to manage their data.<\/p>\n<p>Web-based database would allow organizing your data more structurally, making database management, data entering process and reports generation far more convenient and straight-forward.<\/p>\n<p>While moving to a relational Web-based database, it is important to take a right approach from the very beginning rather than importing a messy set of sheets to separate tables.<\/p>\n<p>Let\u2019s consider another example when you have multiple spreadsheets (or workbooks) that contain the same sort of data, related to tracking your sales leads. We\u2019ll show how to consolidate these multiple spreadsheets into a single table.<\/p>\n<p>At first, this way of data storage may not seem obvious. Especially when the database is going to be built by uploading an Excel file.<\/p>\n<p>A right approach would be importing such a data kept in multiple spreadsheets into a single table and then create multiple custom views with different filtering criteria. Furthermore, a data entering form may contain dynamically appearing sections.<\/p>\n<h2>Multiple spreadsheets<\/h2>\n<p>Let\u2019s consider the following example. Say, you manage a driving school and keep clients\u2019 data in the Excel file, consisting of three spreadsheets: Prospects, Applicants, Drivers.<\/p>\n<p>The first spreadsheet keeps Prospect-related data records:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospects-Spreadsheet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1476\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospects-Spreadsheet.png\" alt=\"Spreadsheet Prospects Data\" width=\"1841\" height=\"847\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospects-Spreadsheet.png 1841w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospects-Spreadsheet-300x138.png 300w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospects-Spreadsheet-768x353.png 768w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospects-Spreadsheet-1024x471.png 1024w\" sizes=\"auto, (max-width: 1841px) 100vw, 1841px\" \/><\/a><\/p>\n<p>The second spreadsheet keeps Applicants-related data records:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicants-Spreadsheet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1477\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicants-Spreadsheet.png\" alt=\"Spreadsheet Applicants Data\" width=\"1841\" height=\"847\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicants-Spreadsheet.png 1841w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicants-Spreadsheet-300x138.png 300w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicants-Spreadsheet-768x353.png 768w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicants-Spreadsheet-1024x471.png 1024w\" sizes=\"auto, (max-width: 1841px) 100vw, 1841px\" \/><\/a><\/p>\n<p>The third spreadsheet keeps Drivers-related data records:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Drivers-Spreadsheet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1478\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Drivers-Spreadsheet.png\" alt=\"Spreadsheets Drivers Data\" width=\"1841\" height=\"847\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Drivers-Spreadsheet.png 1841w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Drivers-Spreadsheet-300x138.png 300w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Drivers-Spreadsheet-768x353.png 768w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Drivers-Spreadsheet-1024x471.png 1024w\" sizes=\"auto, (max-width: 1841px) 100vw, 1841px\" \/><\/a><\/p>\n<p>As \u2018Prospects\u2019 may potentially become clients, managers try to contact them and invite to apply for the driving school.<br \/>\n\u2018Applicants\u2019 are the students taking driving lessons. When an applicant receives a driving license, he\/she becomes a \u2018Driver\u2019. Therefore, each client progresses throw three stages: Prospect-Applicant-Driver.<\/p>\n<h2>Similar structure in one table<\/h2>\n<p>When you <a href=\"https:\/\/www.teamdesk.net\/excel\/\">import this Excel file<\/a> to an online database, three separate tables will be created automatically.<\/p>\n<p>A better way, however, would be to <a href=\"https:\/\/www.teamdesk.net\/help\/3.7.aspx\">import<\/a> all these three spreadsheets into a single Clients table and then add a Status column, keeping record statuses: Prospect, Applicant or Driver.<\/p>\n<p>You may also add such a column to each of your Excel sheets and populate it with an appropriate value to identify the sheet this column belongs to, such as Prospect, Applicant or Driver.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Spreadsheet-data-in-One-Table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1479\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Spreadsheet-data-in-One-Table.png\" alt=\"One Table Spreadsheets Data\" width=\"1860\" height=\"530\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Spreadsheet-data-in-One-Table.png 1860w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Spreadsheet-data-in-One-Table-300x85.png 300w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Spreadsheet-data-in-One-Table-768x219.png 768w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Spreadsheet-data-in-One-Table-1024x292.png 1024w\" sizes=\"auto, (max-width: 1860px) 100vw, 1860px\" \/><\/a><\/p>\n<p>After importing these sheets into a single table you\u2019ll be able to create separate <a href=\"https:\/\/www.teamdesk.net\/help\/5.aspx\">views<\/a> that display relevant columns for each client status.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Separate-Views-in-One-Table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1480\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Separate-Views-in-One-Table.png\" alt=\"Many Views in One Table\" width=\"1839\" height=\"851\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Separate-Views-in-One-Table.png 1839w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Separate-Views-in-One-Table-300x139.png 300w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Separate-Views-in-One-Table-768x355.png 768w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Separate-Views-in-One-Table-1024x474.png 1024w\" sizes=\"auto, (max-width: 1839px) 100vw, 1839px\" \/><\/a><\/p>\n<p>As a result, all the records that were stored in three separate excel spreadsheets, are now kept in a single table and can be <a href=\"https:\/\/www.teamdesk.net\/help\/5.2.1.aspx\">filtered<\/a> in \u2018Views\u2019 by \u2018Status\u2019 value.\u00a0 Moreover, each view contains columns that are relevant to a corresponding status only.<\/p>\n<p>You may also create <a href=\"https:\/\/www.teamdesk.net\/help\/7.1.1.aspx\">separate sections<\/a> on a data entry <a href=\"https:\/\/www.teamdesk.net\/help\/7.aspx\">form<\/a>. Each section will contain fields\/columns that are relevant to each particular status and will appear on the form depending on the status selection. This may be achieved by configuring \u2018<a href=\"https:\/\/www.teamdesk.net\/help\/7.2.aspx\">Form Behavior<\/a>\u2019.<\/p>\n<p>Prospect Form:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospect-Form.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1488\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospect-Form.png\" alt=\"Prospect Data Entry Form\" width=\"727\" height=\"750\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospect-Form.png 727w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Prospect-Form-291x300.png 291w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/a><\/p>\n<p>Applicant form:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicant-Form.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1482\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicant-Form.png\" alt=\"Applicant Data Entry Form\" width=\"725\" height=\"804\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicant-Form.png 725w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Applicant-Form-271x300.png 271w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/a><\/p>\n<p>Driver form:<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Driver-Form.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1483\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Driver-Form.png\" alt=\"Driver Data Entry Form\" width=\"723\" height=\"895\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Driver-Form.png 723w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Driver-Form-242x300.png 242w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/a><\/p>\n<p>The approach described in this post simplifies database structure and relations with other tables, while making database management, data entering process and reports generation far more convenient and straight-forward.<\/p>\n<p>You may order a free trial of the above-mentioned Driving School template here <a href=\"https:\/\/www.teamdesk.net\/driving_school\">&gt;&gt;<\/a><\/p>\n<p>The same approach should be utilized when importing any Excel file containing multiple spreadsheets with an identical structure but keeping data for different locations, different months, etc.<\/p>\n<p>These spreadsheets should be imported into a single table with an extra column, populated with a \u2018location\u2019, a \u2018month\u2019 or any similar identifier.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If your Excel file contains multiple spreadsheets with a very similar structure and you want to import this file into created online database, this article is for you.<\/p>\n","protected":false},"author":3,"featured_media":2427,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[146,127,144,145],"class_list":["post-1475","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-tricks","tag-excel","tag-online-database","tag-spreadsheet","tag-spreadsheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to merge multiple Spreadsheets with a similar structure into One Table - TeamDesk Blog<\/title>\n<meta name=\"description\" content=\"If your Excel file contains multiple spreadsheets with a very similar structure, in your online database you can consolidate these multiple spreadsheets into a single table.\" \/>\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.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to merge multiple Spreadsheets with a similar structure into One Table - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"If your Excel file contains multiple spreadsheets with a very similar structure, in your online database you can consolidate these multiple spreadsheets into a single table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-06T14:39:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-22T12:43:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Excel-to-TeamDesk.png\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"414\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mila\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mila\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/\"},\"author\":{\"name\":\"Mila\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"headline\":\"How to merge multiple Spreadsheets with a similar structure into One Table\",\"datePublished\":\"2018-03-06T14:39:58+00:00\",\"dateModified\":\"2021-07-22T12:43:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/\"},\"wordCount\":630,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/Excel-to-TeamDesk.png\",\"keywords\":[\"excel\",\"online database\",\"spreadsheet\",\"spreadsheets\"],\"articleSection\":[\"Tips &amp; Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/\",\"name\":\"How to merge multiple Spreadsheets with a similar structure into One Table - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/Excel-to-TeamDesk.png\",\"datePublished\":\"2018-03-06T14:39:58+00:00\",\"dateModified\":\"2021-07-22T12:43:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"description\":\"If your Excel file contains multiple spreadsheets with a very similar structure, in your online database you can consolidate these multiple spreadsheets into a single table.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/Excel-to-TeamDesk.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/Excel-to-TeamDesk.png\",\"width\":742,\"height\":414,\"caption\":\"Excel to TeamDesk\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/multiple-spreadsheets-one-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to merge multiple Spreadsheets with a similar structure into One Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\",\"name\":\"Mila\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"caption\":\"Mila\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/mila\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to merge multiple Spreadsheets with a similar structure into One Table - TeamDesk Blog","description":"If your Excel file contains multiple spreadsheets with a very similar structure, in your online database you can consolidate these multiple spreadsheets into a single table.","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.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/","og_locale":"en_US","og_type":"article","og_title":"How to merge multiple Spreadsheets with a similar structure into One Table - TeamDesk Blog","og_description":"If your Excel file contains multiple spreadsheets with a very similar structure, in your online database you can consolidate these multiple spreadsheets into a single table.","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/","og_site_name":"TeamDesk Blog","article_published_time":"2018-03-06T14:39:58+00:00","article_modified_time":"2021-07-22T12:43:44+00:00","og_image":[{"width":742,"height":414,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Excel-to-TeamDesk.png","type":"image\/png"}],"author":"Mila","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mila","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/"},"author":{"name":"Mila","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"headline":"How to merge multiple Spreadsheets with a similar structure into One Table","datePublished":"2018-03-06T14:39:58+00:00","dateModified":"2021-07-22T12:43:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/"},"wordCount":630,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Excel-to-TeamDesk.png","keywords":["excel","online database","spreadsheet","spreadsheets"],"articleSection":["Tips &amp; Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/","name":"How to merge multiple Spreadsheets with a similar structure into One Table - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Excel-to-TeamDesk.png","datePublished":"2018-03-06T14:39:58+00:00","dateModified":"2021-07-22T12:43:44+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"description":"If your Excel file contains multiple spreadsheets with a very similar structure, in your online database you can consolidate these multiple spreadsheets into a single table.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Excel-to-TeamDesk.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2018\/03\/Excel-to-TeamDesk.png","width":742,"height":414,"caption":"Excel to TeamDesk"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/multiple-spreadsheets-one-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"How to merge multiple Spreadsheets with a similar structure into One Table"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e","name":"Mila","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","caption":"Mila"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/mila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=1475"}],"version-history":[{"count":8,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1475\/revisions"}],"predecessor-version":[{"id":2433,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1475\/revisions\/2433"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/2427"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=1475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=1475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=1475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}