{"id":325140,"date":"2021-08-15T18:00:15","date_gmt":"2021-08-15T15:00:15","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-import-different-file-types-into-google-sheets\/"},"modified":"2021-08-15T18:00:15","modified_gmt":"2021-08-15T15:00:15","slug":"how-to-import-different-file-types-into-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-import-different-file-types-into-google-sheets\/","title":{"rendered":"#How to Import Different File Types into Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a417650303a8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a417650303a8\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-different-file-types-into-google-sheets\/#Supported_File_Types\" >Supported File Types<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-import-different-file-types-into-google-sheets\/#Import_a_File_into_Google_Sheets\" >Import a File into Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Import Different File Types into Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Data comes in many forms. Fortunately for you, Google Sheets can import external data in a variety of formats. This saves you the hassle of typing the data manually or trying to copy and paste it.<\/p>\n<p>Google Sheets supports more than 10 file types for imports. Importing a Microsoft Excel file is simple because the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lication closely matches Google Sheets. But you might have a plain text, comma-separated, or tab-separated file that requires some extra formatting.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Supported_File_Types\"><\/span>Supported File Types<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Here\u2019s a list of the file types that you can currently import into Google Sheets. We\u2019ve listed them in alphabetical order to make it easier if you\u2019re interested in a particular one.<\/p>\n<ul>\n<li>CSV<\/li>\n<li>ODS<\/li>\n<li>TAB<\/li>\n<li>TSV<\/li>\n<li>TXT<\/li>\n<li>XLS<\/li>\n<li>XLSM<\/li>\n<li>XLSX<\/li>\n<li>XLT<\/li>\n<li>XLTM<\/li>\n<li>XLTX<\/li>\n<\/ul>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Import_a_File_into_Google_Sheets\"><\/span>Import a File into Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Head to the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets website<\/a>, sign in, and open your workbook. Click File &gt; Import from the top menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741446\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/FileImport-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click File, Import in Google Sheets\" width=\"400\" height=\"374\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Use the tabs in the pop-up window to locate your file and then click \u201cSelect.\u201d You can pick from My Drive in Google Drive, Shared With Me, Recent, or Upload. For our example, we used the Upload feature to import a file from our computer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741447\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileLocations-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose your file location\" width=\"650\" height=\"399\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Depending on your file type, you\u2019ll have different options display in the next window. Here, we\u2019re importing a CSV file to show all available options. Not every file type offers every option that you see here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741451\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileSettings-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets file import settings\" width=\"650\" height=\"390\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the Import Location. You can create a new sheet, insert a new sheet, replace a sheet, replace your current sheet, append your current sheet, or replace the data in selected cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741450\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileSettingsLocation-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick an Import Location\" width=\"650\" height=\"495\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re importing a separated file type such as CSV, TSV, or TXT, choose the Separator Type. You can pick Tab, Comma, or Custom, or have Google Sheets automatically detect the separator based on the file.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741449\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileSettingsSeparator-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick a Separator Type\" width=\"650\" height=\"418\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you select Custom, enter the separator that you want to use in the box that displays.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741458\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileSettingsSeparatorCustom-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter your Custom Separator\" width=\"650\" height=\"392\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The final option is to have text converted to numbers, dates, and formulas. To use this option, simply check the box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741452\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileSettingsConvertText-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Check the box to convert text\" width=\"650\" height=\"390\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish, click \u201cImport Data.\u201d<\/p>\n<p>And that\u2019s all there is to it! Your data should pop into the location that you selected, and any separated files should appear correctly.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741453\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/CSVtoSheet-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"CSV file imported to Google Sheets\" width=\"650\" height=\"419\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To demonstrate the differences in import options based on file type, here are the settings that you can select for those, including ODS, XLS, and XLSX.<\/p>\n<p><strong>RELATED:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.reviewgeek.com\/42195\/the-best-free-microsoft-excel-alternatives\/\"><strong><em>The Best Free Microsoft Excel Alternatives<\/em><\/strong><\/a><\/p>\n<p>You only select the Import Location. But as you can see, you can only create a new sheet, insert a new sheet, or replace a sheet. The remaining location options are grayed out.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741454\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ImportFileSettingsLocationODS-GoogleSheetsImport.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose an Import Location\" width=\"650\" height=\"496\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Hopefully, the file type that you want to import is supported in Google Sheets. And remember, you can import data\u00a0from another Google Sheets spreadsheet as well.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/741444\/how-to-import-different-file-types-into-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Import Different File Types into Google Sheets&#8221; Data comes in many forms. Fortunately for you, Google Sheets can import external data in a variety of formats. This saves you the hassle of typing the data manually or trying to copy and paste it. Google Sheets supports more than 10 file types for imports&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":325141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-325140","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/325140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=325140"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/325140\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/325141"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=325140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=325140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=325140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}