{"id":1216,"date":"2024-12-26T10:46:39","date_gmt":"2024-12-26T07:46:39","guid":{"rendered":"https:\/\/portal.kyaan.sa\/?post_type=docs&#038;p=1216"},"modified":"2024-12-26T15:48:28","modified_gmt":"2024-12-26T12:48:28","password":"","slug":"how-to-create-qr-codes-using-google-sheets","status":"publish","type":"docs","link":"https:\/\/portal.kyaan.sa\/ar\/docs\/how-to-create-qr-codes-using-google-sheets\/","title":{"rendered":"\u2013 \u0643\u064a\u0641\u064a\u0629 \u0625\u0646\u0634\u0627\u0621 \u0631\u0645\u0648\u0632 QR \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Google Sheets"},"content":{"rendered":"<p><img decoding=\"async\" width=\"209\" height=\"112\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdi_4yHqFwFwNjOcmI5x4xtolq_BHD0af3fF0WEkyLRnLEQUzAzk1lZMzBr3tiRNpfKDx-brT_KVE6M8k-BE_YDNkcITu7sdN52RJUA7Y0HUkbCmvX18bvKSmOmhAUdFUvFYaZq_d3Z3NjK6IGOBS-ztjdI?key=-j8AgTSLrKnfNFdGDjtNUA\"><img decoding=\"async\" width=\"119\" height=\"116\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcb2m6ZKcss2M8OX33WLdGokiUa0YCrv52HRw6zILeEGq8FZypygKOXbW0j2mTMzWRPBsozmokE_TQHSFItfMd3-_kPlwklCak6JVN4oi1mQ-YVAd4rqcTi2S1xEiPhAxFxNhfOK6L5sDa9LjIJRpLiG93g?key=-j8AgTSLrKnfNFdGDjtNUA\"><br><\/p>\n\n\n\n<p><img decoding=\"async\" width=\"47\" height=\"6\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdtpPufsAAHG8AwBqAknYA7SWeG9jAEL8ZsWhQAoHXsI2mi8gHMLi5RFhunSw_Cmf0rljzejYFszX3NXoQv5qW8b9t58t-iBhMf9kXemMbi_dId7r8mrabHYN8u13rD3iH3iD0GxCgFiPaLjKGYTGOg0fQ?key=-j8AgTSLrKnfNFdGDjtNUA\"><br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u00a0\"\u0625\u0646\u0634\u0627\u0621 \u0645\u0644\u0641 \u0634\u064a\u062a \u062c\u062f\u064a\u062f \u0645\u0646 \u062f\u0631\u0627\u064a\u0641 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643\"<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\" translation-block\">\"\u0627\u0641\u062a\u062d \u062f\u0631\u0627\u064a\u0641 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062d\u0633\u0627\u0628 \u062c\u0648\u062c\u0644 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643. \u062b\u0645 \u0627\u0646\u0642\u0631 \u0639\u0644\u0649 \u0632\u0631 <strong>\u062c\u062f\u064a\u062f<\/strong> \u0648\u0627\u062e\u062a\u0631 Google Sheets.\"<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXflFZ3O63bcOPN35TGedSwSSb5Ds5ssVP82mOByKxpK6a3VLEwmAFIIiI1HLZ6y3qY2HyfR3Ri66rtr830tGIGhCp_ZwVTHN-uj3fYG9yWLYdrabtwTpvpkD3OOobiowGyMUlAJHL5Q7L3uVEK9EkD7gO4?key=-j8AgTSLrKnfNFdGDjtNUA\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfgz3AnE7alsFK7BySbdjZ2Vlvc9SL7Ncs__HFw3SJ40gC06VinH7007A9p8ELaVVRJHW8nCkM05SoaPbDOPstut7zHqxbch_dHctGinI6yGCqh35fwbWiMjPTWuNlCEtbS2wE2_6JuwHcdifrQpASLQwR9?key=-j8AgTSLrKnfNFdGDjtNUA\" alt=\"\"\/><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\"\u0627\u0628\u062f\u0623 \u0628\u0644\u0635\u0642 \u0631\u0648\u0627\u0628\u0637\u0643\"<\/li>\n<\/ol>\n\n\n\n<p>\"\u0627\u0643\u062a\u0628 \u0623\u0648 \u0627\u0644\u0635\u0642 \u0627\u0644\u0631\u0648\u0627\u0628\u0637 \u0627\u0644\u062a\u064a \u062a\u0631\u064a\u062f \u0625\u0646\u0634\u0627\u0621 \u0631\u0645\u0648\u0632 QR \u0644\u0647\u0627.\"<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXclgbmwS2aaEhOBw7a6dG4f1Di5UCkhn2BVoyJyLNKuGL7VYCEb6xK0Mh5p71tM50gNKfP8yU6PT1L0H69-gAu1Ezwsuh3CeGxG0bXax-FgfaZN_zUtb7IwsOB7DLtW--Ibqy2dDQ3uOiGKJ9AWJoScoWA?key=-j8AgTSLrKnfNFdGDjtNUA\" alt=\"\"\/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\"\u0635\u062f\u0631 \u0631\u0645\u0648\u0632 QR \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0623\u062f\u0646\u0627\u0647\"<\/li>\n<\/ol>\n\n\n\n<p>\"\u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 \u0623\u0645\u0627\u0645 \u0627\u0644\u0631\u0627\u0628\u0637\u060c \u0627\u0644\u0635\u0642 \u0627\u0644\u0635\u064a\u063a\u0629 \u0623\u062f\u0646\u0627\u0647:\"<\/p>\n\n\n\n<p><strong>=image(&#8220;<\/strong><a href=\"https:\/\/image-charts.com\/chart?chs=150x150&amp;cht=qr&amp;choe=UTF-8&amp;chl=%22&amp;ENCODEURL(A2)\"><strong>https:\/\/image-charts.com\/chart?chs=150&#215;150&amp;cht=qr&amp;choe=UTF-8&amp;chl=&#8221;&amp;ENCODEURL(A2)<\/strong><\/a><strong>)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfeXhMfyBm6A5SnQ4ma3fOePgiDd5AueYcN0aEd_SFM9zujougbKARd7E_VV-9QlHm9QFK_PnYXSdUbq3pNUpccXw-dhsQ3eV7rEW9VuzcCYhDsyNdcqHQfCaIEG8uMbOW8kYYF2eZwK0yzo1VfYyxPoll-?key=-j8AgTSLrKnfNFdGDjtNUA\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\" translation-block\">\"\u062b\u0645 \u0627\u0636\u063a\u0637 \u0639\u0644\u0649 <strong>\u0625\u062f\u062e\u0627\u0644<\/strong>\"<\/p>\n\n\n\n<p>\"\u062b\u0645 \u064a\u0645\u0643\u0646\u0643 \u0633\u062d\u0628 \u0627\u0644\u0645\u0624\u0634\u0631 \u0645\u0646 \u0632\u0627\u0648\u064a\u0629 \u0627\u0644\u062e\u0644\u064a\u0629 \u0644\u062a\u0637\u0628\u064a\u0642\u0647 \u0639\u0644\u0649 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0623\u062e\u0631\u0649.\"<\/p>\n\n\n\n<p>\"\u064a\u0645\u0643\u0646\u0643 \u0623\u064a\u0636\u064b\u0627 \u062a\u063a\u064a\u064a\u0631 \u062d\u062c\u0645 \u0627\u0644\u0635\u0641\u0648\u0641 \u0639\u0646 \u0637\u0631\u064a\u0642 \u0633\u062d\u0628\u0647\u0627 \u0644\u0644\u0623\u0633\u0641\u0644 \u0644\u0632\u064a\u0627\u062f\u0629 \u062d\u062c\u0645 \u0631\u0645\u0632 \u0627\u0644\u0640 QR.\"<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc4vbiWm-QZj6xnl7vHRiyXXw_EIabfr_oGEkZBBFRvlKXAhB51psr8rvNah7cUlQzsadzYUVHB3rqGDSNjHUGGDA4uD788q-ec-kwjJq9jShvwG2cQxxy2F356cTWUcWFl-8Sw0ExKlOc4VCgwReS9JOpa?key=-j8AgTSLrKnfNFdGDjtNUA\" alt=\"\"\/><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>\"\u0627\u062d\u0641\u0638 \u0631\u0645\u0632 \u0627\u0644\u0640 QR \u0643\u0635\u0648\u0631\u0629 \u0639\u0644\u0649 \u062c\u0647\u0627\u0632\u0643.\"<\/li>\n<\/ol>\n\n\n\n<p class=\" translation-block\">\"\u064a\u0645\u0643\u0646\u0643 \u062d\u0641\u0638\u0647 \u0643\u0635\u0648\u0631\u0629 \u0639\u0644\u0649 \u062c\u0647\u0627\u0632\u0643 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>\u0623\u062f\u0627\u0629 \u0627\u0644\u0642\u0635<\/strong>.\"<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\"\u0627\u0636\u063a\u0637 \u0639\u0644\u0649 \u0627\u0644\u0623\u0632\u0631\u0627\u0631: Win+Shift+S \u062b\u0645 \u062d\u062f\u062f \u0631\u0645\u0632 \u0627\u0644\u0640 QR.\"<\/li>\n\n\n\n<li>\"\u0627\u0644\u0635\u0642 \u0627\u0644\u0635\u0648\u0631\u0629 \u0641\u064a WhatsApp \u0623\u0648 \u0645\u0633\u062a\u0646\u062f Word \u0623\u0648 \u0623\u064a \u0645\u0644\u0641 \u0622\u062e\u0631.\"<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdKfnO2H6ToVdYXON2ZtJWzTc1PGsqQT6u1u3VDckW1lgF4gMait2kXxQKQU8-MWjENio1j89g_FI_99suvLwSmXpiBXCQyCcOFDEGu1KtO5u8pmHaCB5jC1jO5SfrQxtNZ5CykF_vQJqsko8g2A7-c-a8?key=-j8AgTSLrKnfNFdGDjtNUA\" alt=\"\"\/><\/figure>","protected":false},"excerpt":{"rendered":"<p>Open your Drive using your Google account. Then click New button and select Google Sheet Write or paste the links you want to create QR codes for. In the cell in front of the link, paste the below formula: =image(&#8220;https:\/\/image-charts.com\/chart?chs=150&#215;150&amp;cht=qr&amp;choe=UTF-8&amp;chl=&#8221;&amp;ENCODEURL(A2)) Then click Enter You can then drag the cursor from the corner of the cell [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[91],"doc_tag":[],"class_list":["post-1216","docs","type-docs","status-publish","hentry","doc_category-others"],"acf":[],"year_month":"2026-04","word_count":157,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Abdulrahman Osama (SU)","author_nicename":"a-osamakyaan-sa","author_url":"https:\/\/portal.kyaan.sa\/ar\/author\/a-osamakyaan-sa\/"},"doc_category_info":[{"term_name":"Others","term_url":"https:\/\/portal.kyaan.sa\/ar\/docs-category\/others\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/docs\/1216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/comments?post=1216"}],"version-history":[{"count":2,"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/docs\/1216\/revisions"}],"predecessor-version":[{"id":1350,"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/docs\/1216\/revisions\/1350"}],"wp:attachment":[{"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/media?parent=1216"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/doc_category?post=1216"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/portal.kyaan.sa\/ar\/wp-json\/wp\/v2\/doc_tag?post=1216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}