How to create a Kanban board in Google Sheets?

3 min read

Summary

Kanban board in Google Sheets offers a versatile solution for managing tasks and projects. This article explores how to set up and optimize a digital Kanban board in Google Sheets, providing you with a powerful tool to streamline your workflow and boost productivity.

Google Sheets is a powerful spreadsheet app. But it can be much more than that. You can create a Kanban board in Google Sheets. First, create a new spreadsheet and name columns. For instance, Backlog, To Do, Doing and Done. After styling it to your preference, start filling it out with your own tasks.

After changing the task status, move it to the next column by clicking on the edge of the cell and dragging it.

More Google Workspace tips from Kanbanchi How to convert Excel file to Google Sheets?

It is a great way to add transparency to your workflow. So don't forget to share with your co-workers. This Google Sheets board is a very limited tool. If you want more advanced features such as task assignments, notifications, task list, attachments, and much more, try using Kanbanchi. It has an easy-to-learn user interface, and integration with Google Workspace will not disappoint you

Name	Provider	Purpose	Expiration
wordpress_, wp_	Kanbanchi	Internal cookie provided by CMS the website is built in.	Session
kanbanchi_website_cookie	Kanbanchi	Internal cookie for checking cookies health.	Persistent
pll_language	Kanbanchi	This cookie is used to remember the language selected by the user when he comes back to visit again the website by Polylang.	Persistent
_pk_*	Matomo	Analyse the use of the website and compile reports about the website activity.	Persistent
embed-privacy, moove_gdpr_popup	Kanbanchi	Track users’ cookie consent.	Persistent
__cf, cf_, _cf*, CF_Authorization	CloudFlare	CloudFlare service sets cookies to identify trusted web traffic. It does not correspond to any user id in the web application and does not store any personally identifiable information.	Session
access_token_production, amplitude_, amp_, amp_.organization.domain, CookieControl, deviceId, driftt_aid, eventId, identifyId, lastEventTime, optOut, org_login_production, sequenceNumber, sessionId, userId, _biz_, _fbp, _ga, _gid, _mkto_trk, _rdt_uuid, _uetvid, _zitok, __utmzz, __utmzzses	Amplitude	These cookies are used to analyze the user behavior within Kanbanchi website.	Persistent
_GRECAPTCHA	Google reCAPTCHA	We use Google Recaptcha to provide spam protection. We then compile reports which help Us improve Our Sites. This cookie sets as necessary cookie when executed for the purpose of providing its risk analysis.	Session
ar_debug, ga, _dc_gtm_UA-XXXXX-XX, _dc_gtm_, _gaexp, _gat, _gat, _gat_gtag_UA_, _ga_XXXXXXXXXX, _ga_, _gcl_au, _gid, __TAG_ASSISTANT, __utma, __utmc, __utmz	Google Analytics and Google Tag Manager	We use Google Analytics and Google Tag Manager to collect information about the usage of Our Sites. We then compile reports which help Us improve Our Sites. The core cookies of Google Analytics and Google Tag Manager collect information in an anonymous form, including the number of visitors to the site, where visitors have come to the site from, the pages they visited and the features they used.	Persistent
AADSSOTILES brcap Ccs CcsNtv CcsWeb ch, CkTst, CLID, cl, ea, ec, el, ESTSUSERLIST, ev, evt, fpc, gc, gv, ifm, lg, lt, mid, msclkid, MSPTC, MUID, p, pi, r, rn, rrc, sc, sh, sid, sw, threxp, ti, tl, ver, _cl, _uetmsclkid, _uetsid, _uetvid	Microsoft Universal Event Tracking	We use Microsoft Event Tracking to collect information about the usage of Our Sites. We then compile reports which help Us improve Our Sites. The core cookies of Microsoft Event Tracking collect information in an anonymous form, including the number of visitors to the site, where visitors have come to the site from, the pages they visited and the features they used.	sid is a Session cookie, other – Persistent

Name	Provider	Purpose	Expiration
1_LIVE, APISID, HSID, LOGIN_INFO, PREF, SAPISID, SID, SSID, VISITOR_INF, YSC	YouTube	We use YouTube (a service of Google) to display video content on Our Sites. As part of this, YouTube sets various cookies to allow the correct Youtube video playback and store your preferences when viewing YouTube videos.	Persistent
1P_JAR, ACCOUNT_CHOOSER, ADS_VISITOR_ID, AEC, AID, APISID, DV, HSID, LSID, LSOLH, NID, OCAK, OGPC, OTZ, PSIDCC, SAPISID, SID, SMSV, SOCS, SSID, __Secure-	Google Accounts / Google Services	Google sets various cookies to authenticate users, prevent fraudulent use of login credentials, protect user data from unauthorized parties, as well as remember your preferences and other information, such as your preferred language.	Persistent
csrf.app, hubspotutk, IR_PI, messagesUtk, _cfuvid, _conv_v, _hjSessionUser_, _hs, _ttp, _tt_enable_cookie, __cf_bm, __hs*	Hubspot	These cookies are set by Hubspot. We use this tool for analyzing the use of kanbanchi.com and receiving requests from visitors. We then compile reports which help Us improve Our Sites.	_hssrc is a Session Сookie, others – Persistent
ajs_anonymous_id, .customer.io, _cio, _ga, _ga_	Customer.io	Some forms on our website collect data for the purpose of sending emails. Cookies will only be added in case of submitting these forms.	Persistent

Name	Provider	Purpose	Expiration
IDE, test_cookie	DoubleClick	Google’s Doubleclick uses cookies for targeting, optimisation, reporting and attribution of online advertisements.	Persistent
m-b, m-css_v, m-early_v, m-s, m-t*, m-uid	Quora	Uses cookies for targeting, optimisation and attribution of online advertisements.	Persistent
ct0, eu_cn, external_referer, guest_id*, lang, metrics_token, muc_ads, personalization_id, syndication_guest_id, tfw_exp, _twitter_sess	Twitter	We embed certain Twitter feeds on site. Cookies are set by Twitter to be identified on the web site through a Twitter account, as well as information on the content viewed by the user for Twitter’s display advertising.	lang and _twitter_sess are Session Cookies, others – Persistent
cb, datr, fr, usida, wd, _fbp	Facebook	We use Facebook information on the content viewed by the user for Facebook’s display advertising.	lang and _twitter_sess are Session Cookies, others – Persistent
_hj*	HotJar.com	Some pages of our website are monitored by our marketing team to provide a better experience and more relevant information.	Session
AnalyticsSyncHistory, ar_debug, bcookie, Bizo, bscookie, JSESSIONID, lang, li, li_, lms_, ln_, oribi, sdsc, UID, UserMatchHistory, _guid	Linkedin	These cookies are used as part of LinkedIn Insights and ad tags to track visitors from our LinkedIn marketing.	Persistent

How to create a Kanban board in Google Sheets?

Summary

Want to try the power of Kanbanchi and Google Workspace?

Watch how to create Kanban in Google Sheets