{"id":12240,"date":"2022-10-27T11:50:34","date_gmt":"2022-10-27T02:50:34","guid":{"rendered":"https:\/\/prodskill.com\/?p=12240"},"modified":"2022-10-27T13:51:04","modified_gmt":"2022-10-27T04:51:04","slug":"google-spreadsheet-leading-space","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/","title":{"rendered":"How to fix Google Spreadsheets removing leading spaces"},"content":{"rendered":"<p>There is a problem with pasting text with leading spaces in Google Spreadsheets, leading to spaces being removed.<\/p>\n\n\n\n<p>SQL statements that require indentation to read are often pasted into Google Spreadsheets, but all indented leading spaces are removed, which worsens readability.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" 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: #999;color:#999\" 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><\/span><\/a><\/span><\/div>\n<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:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/#1_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%A0%9C%EA%B1%B0%EB%90%98%EB%8A%94_%EB%AC%B8%EC%A0%9C\" >1. The problem of removing leading spaces in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/#2_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%9C%A0%EC%A7%80%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\" >2. How to Preserve Leading Spaces in Google Spreadsheets<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%A0%9C%EA%B1%B0%EB%90%98%EB%8A%94_%EB%AC%B8%EC%A0%9C\"><\/span>1. The problem of removing leading spaces in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Copy the following SQL,<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">SELECT x, y\n  FROM (SELECT 1 AS x, true AS y UNION ALL\n        SELECT 9, true UNION ALL\n        SELECT NULL, false)\n ORDER BY x NULLS LAST;\n\n+------+-------+\n| x    | y     |\n+------+-------+\n| 1    | true  |\n| 9    | true  |\n| NULL | false |\n+------+-------+<\/pre>\n\n\n\n<p>(source:&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax?hl=ko#order_by_clause\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax?hl=ko#order_by_clause<\/a>)<\/p>\n\n\n\n<p>When pasting into a Google Spreadsheet, all leading spaces are removed as follows:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155.png\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"137\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155.png\" alt=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uae30\ud55c SQL: \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub428\" class=\"wp-image-12241\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155.png 377w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-300x109.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-36x13.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-48x17.png 48w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/a><figcaption>SQL pasted into Google Spreadsheet: leading spaces removed<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%9C%A0%EC%A7%80%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\"><\/span>2. How to Preserve Leading Spaces in Google Spreadsheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you add &#039; (single quotation mark (=single quotation), single quotation) as the first character of each line in the editor and paste it into Google Spreadsheet, the leading space is not removed.<\/p>\n\n\n\n<p>For example, in Notepad++, when you have the following text:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"100\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156.png\" alt=\"Notepad++ SQL Text \uc608\uc2dc\" class=\"wp-image-12242\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156.png 362w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-300x83.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-48x13.png 48w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><figcaption>Notepad++ SQL Text Example<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Place the cursor on the first row, first column,&nbsp;<strong>Alt<\/strong>&nbsp;+&nbsp;<strong>C<\/strong>&nbsp;Press the key or \u201cEdit &gt; Column Mode\u2026 Run the \u201d menu and enter the character &#039;(single quotation mark (=single quotation mark), single quotation)&nbsp;<strong>Enter<\/strong>&nbsp;When the key is pressed, it is added as the first character of each line as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"100\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157.png\" alt=\"Notepad++ SQL Text: \uccab\ubc88\uc9f8 \uc5f4\uc5d0 \uc791\uc740\ub530\uc634\ud45c \ucd94\uac00 \uc608\uc2dc\" class=\"wp-image-12243\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157.png 362w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-300x83.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-48x13.png 48w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><figcaption>Notepad++ SQL Text: Example of adding single quotes to the first column<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Now, if you copy the text above and paste it into a Google Spreadsheet, leading spaces are preserved as shown below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"137\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\" alt=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uae30\ud55c SQL: \uc120\ud589 \uacf5\ubc31 \uc720\uc9c0\ub428\" class=\"wp-image-12244\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png 377w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-300x109.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-36x13.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-48x17.png 48w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/a><figcaption>SQL pasted into Google Spreadsheet: leading spaces preserved<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Single quotation marks are invisible at a glance, but appear in the upper input bar when you click a cell.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159.png\"><img loading=\"lazy\" decoding=\"async\" width=\"389\" height=\"161\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159.png\" alt=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uae30\ud55c SQL: \uc785\ub825\ucc3d\uc5d0\ub294 \uc791\uc740\ub530\uc634\ud45c\uac00 \ub098\ud0c0\ub0a8\" class=\"wp-image-12248\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159.png 389w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-300x124.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-48x20.png 48w\" sizes=\"auto, (max-width: 389px) 100vw, 389px\" \/><\/a><figcaption>SQL pasted into Google Spreadsheet: single quotes appear in input field<\/figcaption><\/figure>\n<\/div>\n\n\n<p>However, in this state, even if you copy the text of Google Spreadsheet and paste it elsewhere, single quotation marks are excluded and the original text is pasted including leading spaces. There seems to be no problem with single quotes other than to preserve leading whitespace.<\/p>\n\n\n\n<p>I was concerned about this problem for a while, so I googled it, but couldn&#039;t find it. I suddenly thought about adding a single quotation mark to format text in Excel, so I tried it, and the problem was solved cleanly.<\/p>\n\n\n\n<p>For reference, in DBeaver, execute the following process.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Alt<\/strong>&nbsp;+&nbsp;<strong>Shift<\/strong>&nbsp;+&nbsp;<strong>A<\/strong>&nbsp;Switch to column edit mode with key<\/li><li><strong>Shift<\/strong>&nbsp;+&nbsp;<strong>arrow<\/strong>&nbsp;Select the first column using the key and enter single quotation marks<\/li><li>again&nbsp;<strong>Alt<\/strong>&nbsp;+&nbsp;<strong>Shift<\/strong>&nbsp;+&nbsp;<strong>A<\/strong>Press to switch to normal editing mode<\/li><li>Copy the text and paste it into a Google Spreadsheet<\/li><\/ol>\n\n\n\n<p>This method can be applied to any text editor that supports column mode editing. Depending on the editor, shortcut keys or menu functions may be slightly different, but it is enough to add a single quotation mark to the first column.<\/p>\n\n\n\n<p>We looked at how to maintain indentation when inputting source code such as SQL or Python into Google Spreadsheet. If there is another way, please let me know in the comments.<\/p>\n\n\n\n<p><strong>* Summary in English: How to keep leading space in Google Spreadsheets.<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google Spreadsheet has a problem where leading spaces are removed when pasting text containing leading spaces. SQL statements that require indentation to be readable are often pasted into Google Spreadsheets, but this is a phenomenon in which all indented leading spaces are removed, resulting in poor readability. 1. Google Spreadsheets leading spaces are removed...<\/p>","protected":false},"author":1,"featured_media":12244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[264,291,292,293,294],"class_list":["post-12240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-tools","tag-dbeaver","tag-google-spreadsheet","tag-leading-space","tag-293","tag-294"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-27T02:50:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-27T04:51:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\" \/>\n\t<meta property=\"og:image:width\" content=\"377\" \/>\n\t<meta property=\"og:image:height\" content=\"137\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95\",\"datePublished\":\"2022-10-27T02:50:34+00:00\",\"dateModified\":\"2022-10-27T04:51:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/\"},\"wordCount\":80,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-158.png\",\"keywords\":[\"DBeaver\",\"Google Spreadsheet\",\"Leading Space\",\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\",\"\uc120\ud589 \uacf5\ubc31\"],\"articleSection\":[\"Google \ub3c4\uad6c\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/\",\"name\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-158.png\",\"datePublished\":\"2022-10-27T02:50:34+00:00\",\"dateModified\":\"2022-10-27T04:51:04+00:00\",\"description\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-158.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-158.png\",\"width\":377,\"height\":137},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/google-spreadsheet-leading-space\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix Google Spreadsheet Leading Space Removal Issue - Productivity Skill","description":"We&#039;ll look at an issue where leading spaces are removed when pasting text containing them into Google Spreadsheets, and explore solutions.","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:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/","og_locale":"en_US","og_type":"article","og_title":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/google-spreadsheet-leading-space\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-27T02:50:34+00:00","article_modified_time":"2022-10-27T04:51:04+00:00","og_image":[{"width":377,"height":137,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95","datePublished":"2022-10-27T02:50:34+00:00","dateModified":"2022-10-27T04:51:04+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/"},"wordCount":80,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","keywords":["DBeaver","Google Spreadsheet","Leading Space","\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","\uc120\ud589 \uacf5\ubc31"],"articleSection":["Google \ub3c4\uad6c"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/","url":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/","name":"How to Fix Google Spreadsheet Leading Space Removal Issue - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","datePublished":"2022-10-27T02:50:34+00:00","dateModified":"2022-10-27T04:51:04+00:00","description":"We&#039;ll look at an issue where leading spaces are removed when pasting text containing them into Google Spreadsheets, and explore solutions.","breadcrumb":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/google-spreadsheet-leading-space\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","width":377,"height":137},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/12240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=12240"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/12240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/12244"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=12240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=12240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=12240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}