Cara Mudah Membuat QR Code Dengan Google Sheets


Pernah melihat QR Code seperti gambar diatas? Tentu pernah dong, misalnya yang suka dengan BBM atau Kode ini juga sering kita jumpai pada aplikasi tertentu atau pada sparepart kendaraan, bahkan sekarang lebih luas lagi sering digunakan untuk logo-logo perusahaan, untuk membuat link tertentu dan sebagaikan. Menurut https://id.wikipedia.org "Kode QR atau biasa dikenal dengan istilah QR Code adalah bentuk evolusi kode batang dari satu dimensi menjadi dua dimensi. Penggunaan kode QR sudah sangat lazim di Jepang Hal ini dikarenakan kemampuannya menyimpan data yang lebih besar daripada kode batang sehingga mampu mengkodekan informasi dalam bahasa Jepang sebab dapat menampung huruf kanji. Kode QR telah mendapatkan standardisasi internasional dan standardisasi dari Jepang berupa ISO/IEC18004 dan JIS-X-0510 dan telah digunakan secara luas melalui ponsel di Jepang"
Untuk memudahkan sahabat tekno-g juga menyediakan link untuk langsung melihat file Google Sheets yang sudah ada formula untuk membuat qr code dan juga video cara membuatnya di bagian bawah artikel ini.
Kode QR ditemukan di Jepang dalam sebuah penelitian yang di pimpin oleh Masahiro Hara, dimana sebelumnya kita mengenal barcode batang yang satu dimensi lalu dikembangkan menjadi Barcode dua dimensi yaitu QR Code.
Nah sekarang mari kita coba langsung ke teknis membuatnya di google sheets. Sahabat pasti dong sudah tahu apa itu Google Sheets. Google sheets adalah aplikasi pengolahan data yang dimiliki oleh google yang sangat mirip dengan Microsoft Excel, namun Google sheets harus di akses melalui internet dan penggunanya harus sudah mempunyai Google Account atau email google. Untuk mengaksesnya sahabat tinggal mengaktifkan Aplikasi Drive Google.
Tahap Membuat QR Code dengan Google Sheets :

  1. Aktifkan Google Sheets dari Google Drive
  2. Buatlah Tabel sesuai kebutuhan, tekno-g membuat seperti ini, Kolom No, Data dan Barcode QR / Code QR, contoh di Kolom Data masukkan Link, Teks atau angka, atau kombinasi semuanya.
  3. Pada Kolom C (Barcode QR/Code QR), isikan formula yang membaca data yang dibuat di kolom B (Data), lihat gambar..

  4. Untuk Lebih Jelas Perbesar Gambar
Mudah bukan??? Jadi sesuaikan saja dengan kebutuhan sahabat, misalnya membuat link yang langsung menuju ke website kita, membuat penjelasan singkat produk kita, membuat kata-kata rahasia. Semua bisa dibaca oleh perangkat yang memiliki kemampuan menscan QR Code, beruntungnya kita pada masa ini, hampir semua smartphone sudah bisa membaca kode QR dengan aplikasi kamera pembaca kode tersebut.

Trik Mengatasi Error Jika ada spasi di Data yang akan dibuat QR Code

Pada Formula sahabat tinggal tambahkan formula =REGEXREPLACE() pada rumus atau formula diatas, caranya bisa lihat gambar berikut :
Klik Gambar atau Buka di Desktop untuk Melihat Lebih Besar
Download File Membuat QR Code Dengan Google Sheets
Untuk memudahkan sahabat kami sudah menyediakan link untuk mendownload file atau berbagi file Barcode QR nya, silahkan ikuti tautan berikut :

Untuk lebih rinci ayo kita lihat video berikut ini :
Terima kasih sudah berkunjung ke blog tekno-g ini, Jika sahabat menemukan hal yang salah dalam artikel ini silahkan komentar yang membangun untuk perbaikan, kami akan berusaha mencari solusi segera mungkin. Apabila merasa bermanfaat yang besar silahkan like and share. Terima kasih

34 Responses to "Cara Mudah Membuat QR Code Dengan Google Sheets"

  1. I used to be able to find good advice from your blog articles.

    ReplyDelete
  2. mas, rencananya kan kami mau bikin QR code untuk presensi peserta seminar, nah dari Google Sheet untuk bisa dibagikan ke masing2 peserta caranya gimana ya?

    ReplyDelete
    Replies
    1. ikuti trik berikut :
      Buatlah seperti tabel, lalu pastikan ada satu coloumn unik, nanti baris pada kolom itu dibaca di print seperti mail merge... namun ini bisa kita buat google sheets, coba adopsi cara ini :
      http://tekno-g.blogspot.com/2016/10/cara-membuat-surat-masal-tanpa-mail-merge-dengan-microsoft-excel.html

      Delete
  3. Just wanna comment that you have a very nice internet site, I love the style it actually stands out.

    ReplyDelete
  4. Outstanding quest there. What happened after? Thanks!

    ReplyDelete
  5. Howdy! I know this is kinda off topic nevertheless I'd figured I'd ask.
    Would you be interested in exchanging links or maybe
    guest authoring a blog article or vice-versa?
    My blog covers a lot of the same topics as yours and I believe we
    could greatly benefit from each other. If you are interested feel free
    to send me an email. I look forward to hearing from you!
    Wonderful blog by the way!

    ReplyDelete
  6. Hey there this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors
    or if you have to manually code with HTML. I'm starting a blog soon but have no coding know-how so I
    wanted to get advice from someone with experience.

    Any help would be greatly appreciated!

    double stopping ()

    ReplyDelete
  7. Hello to all, how is all, I think every one is getting more
    from this site, and your views are fastidious for new viewers.


    kitchen range ()

    ReplyDelete
  8. This internet site is my inspiration, really excellent style and design and Perfect content.

    ReplyDelete
  9. Pretty section of content. I just stumbled upon your website and in accession capital to assert
    that I get actually enjoyed account your blog posts. Anyway I'll be subscribing to
    your feeds and even I achievement you access consistently rapidly.

    ReplyDelete
  10. Great delivery. Sound arguments. Keep up the good work.

    ReplyDelete
  11. Excellent info over again. Thumbs up.

    ReplyDelete
  12. Hmm it appears like your website ate my first comment
    (it was super long) so I guess I'll just
    sum it up what I had written and say, I'm thoroughly enjoying your blog.
    I as well am an aspiring blog writer but I'm still new to
    the whole thing. Do you have any tips and hints for newbie blog writers?
    I'd definitely appreciate it.

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://urlki.com/3doa4

    ReplyDelete
  13. Great delivery. Sound arguments. Keep up the good effort.


    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://urlki.com/3dp97

    ReplyDelete
  14. Hi there i am kavin, its my first occasion to commenting anywhere, when i read
    this paragraph i thought i could also make comment due to this
    sensible piece of writing.

    By the way, I heard about this awsome affiliate program for Instagram influencers.

    Better apply soon before all the spots are filled up.
    Here is the link: http://rlu.ru/2wesc

    ReplyDelete
  15. I am not sure where you're getting your information, but great topic.

    I needs to spend some time learning more or understanding more.
    Thanks for excellent information I was looking for this info for my mission.

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://ix.sk/1sRlH

    ReplyDelete
  16. Hello there! I know this is somewhat off topic but I was wondering which blog platform are you using for this site?
    I'm getting sick and tired of Wordpress because I've had problems with hackers and I'm looking at
    alternatives for another platform. I would be great if you could point me in the direction of
    a good platform.

    ReplyDelete
  17. Thanks designed for sharing such a good idea, paragraph is fastidious, thats why i have read it
    completely

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are
    filled up. Here is the link: http://qtx.de/383kl

    ReplyDelete
  18. I used to be suggested this website by way of my cousin. I'm no
    longer certain whether or not this submit is written by him as nobody else understand such distinct about
    my difficulty. You are wonderful! Thank you!

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://we.cx/3tncc

    ReplyDelete
  19. An interesting discussion is definitely worth comment.
    I do believe that you should write more on this issue, it might not be a taboo matter
    but generally people don't speak about these subjects.
    To the next! Best wishes!!

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up. Here is the link:
    http://gul.ly/vhuyf

    ReplyDelete
  20. Thank you for the auspicious writeup. It actually was a leisure account it.

    Glance advanced to more added agreeable from you!
    By the way, how can we be in contact?

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://we.cx/3tnei

    ReplyDelete
  21. Link exchange is nothing else however it is only placing the other person's webpage link on your
    page at appropriate place and other person will also do same
    for you.

    ReplyDelete
  22. It is really a great and useful piece of information. I am happy that you shared
    this useful info with us. Please keep us up to date like this.
    Thank you for sharing.

    By the way, I heard about this awsome affiliate program
    for Instagram influencers. Better apply soon before all the spots are
    filled up. Here is the link: http://chilp.it/c99a7d8

    ReplyDelete
  23. Good site you've got here.. It's difficult to find good quality writing like yours nowadays.
    I really appreciate people like you! Take care!!

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up. Here is
    the link: http://we.cx/3tggc

    ReplyDelete
  24. hi!,I really like your writing very so much! share we keep up a correspondence extra approximately your article on AOL?

    I require an expert on this area to unravel my problem.

    May be that's you! Looking forward to peer you.

    By the way, I heard about this awsome affiliate program
    for Instagram influencers. Better apply soon before all the spots are filled up.

    Here is the link: http://urlki.com/3doec

    ReplyDelete
  25. I need to to thank you for this wonderful read!!

    I absolutely loved every little bit of it. I've got you book marked to look at new things you post…

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.

    Here is the link: http://gul.ly/vi78g

    ReplyDelete
  26. It's remarkable designed for me to have a site, which
    is useful for my know-how. thanks admin

    ReplyDelete
  27. Excellent way of explaining, and nice post to take data about my
    presentation subject matter, which i am going to deliver in school.



    By the way, I heard about this awsome affiliate program for Instagram
    influencers. Better apply soon before all the spots are filled
    up. Here is the link: http://gul.ly/vi76m

    ReplyDelete
  28. It's amazing in favor of me to have a site, which is valuable for my knowledge.

    thanks admin

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up. Here is
    the link: http://rlu.ru/2wexC

    ReplyDelete
  29. Very descriptive blog, I loved that bit. Will there be a part 2?

    ReplyDelete
  30. I could not refrain from commenting. Exceptionally well written!

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://urlki.com/3do8m

    ReplyDelete
  31. Simply wish to say your article is as amazing. The clearness in your submit
    is just spectacular and that i could think you are an expert in this
    subject. Fine along with your permission let me to
    snatch your RSS feed to stay up to date with approaching
    post. Thanks a million and please carry on the gratifying work.


    By the way, I heard about this awsome affiliate program for Instagram influencers.

    Better apply soon before all the spots are filled up.

    Here is the link: http://qtx.de/384ma

    ReplyDelete
  32. The other day, while I was at work, my sister stole my iPad
    and tested to see if it can survive a forty foot drop, just so she can be
    a youtube sensation. My apple ipad is now
    destroyed and she has 83 views. I know this is totally off topic but I had
    to share it with someone!

    By the way, I heard about this awsome affiliate program for Instagram influencers.
    Better apply soon before all the spots are filled up.
    Here is the link: http://qtx.de/383jd

    ReplyDelete
  33. Way cool! Some extremely valid points! I appreciate you writing this write-up plus the rest
    of the website is really good.

    ReplyDelete

Silahkan Komentar Yang Membangun. Komen SARA, Judi, Pornografi dan Melanggar Undang-Undang akan ditandai sebagai SPAM