{"id":21957,"date":"2026-04-26T23:56:21","date_gmt":"2026-04-26T14:56:21","guid":{"rendered":"https:\/\/xlworks.net\/?p=21957"},"modified":"2026-04-26T23:56:21","modified_gmt":"2026-04-26T14:56:21","slug":"getting-started-with-xlgantt-for-google-sheets","status":"publish","type":"post","link":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/","title":{"rendered":"Getting Started with XLGantt for Google Sheets"},"content":{"rendered":"

Thank you for installing XLGantt for Google Sheets.<\/p>\n

Follow these steps to start using the add-on.<\/p>\n

1. Open Google Sheets<\/h3>\n

Open a new or existing Google Sheets spreadsheet.<\/p>\n

2. Find the XLGantt Menu<\/h3>\n

In Google Sheets, open:<\/p>\n

Extensions > XLGantt for Google Sheets<\/p>\n

If the menu does not appear, refresh the spreadsheet or close and reopen it.<\/p>\n

3. Create a New Project Template<\/h3>\n

Click:<\/p>\n

Create New Project Template<\/p>\n

XLGantt will create the basic sheets needed for project scheduling:<\/p>\n

- Schedule
\n- Progress
\n- Calendar
\n- AnalysisReport
\n- Progress_Data<\/p>\n

4. Choose Your Language<\/h3>\n

The default language is English.<\/p>\n

To change the language, open:<\/p>\n

Extensions > XLGantt for Google Sheets > Options > Language<\/p>\n

Supported languages:<\/p>\n

- English
\n- Korean<\/p>\n

5. Enter Your Project Tasks<\/h3>\n

Go to the Schedule sheet and enter:<\/p>\n

- Task names
\n- Start dates
\n- Finish dates
\n- Resources
\n- Deliverables
\n- Actual progress<\/p>\n

6. Update the Schedule<\/h3>\n

Click:<\/p>\n

Extensions > XLGantt for Google Sheets > Update Schedule<\/p>\n

The add-on will calculate the project schedule and update the Gantt chart.<\/p>\n

7. Create Reports<\/h3>\n

You can generate analysis reports from the XLGantt menu, including:<\/p>\n

- Progress by Resources
\n- Workloads by Weeks
\n- Workloads by Months
\n- Workloads by Resources
\n- Progress by Weeks
\n- Progress by Months
\n- Progress Data<\/p>\n

 <\/p>\n

Need Help?<\/h3>\n

Support:
\nhttps:\/\/xlworks.net\/en\/support-for-xlgantt-4-google-sheets\/<\/a><\/p>\n

Installation Guide:
\nhttps:\/\/xlworks.net\/en\/how-to-install-xlgantt-4-google-sheets\/<\/a><\/p>\n

Privacy Policy:
\nhttps:\/\/xlworks.net\/en\/privacy-policy-for-xlgantt-4-google-sheets\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Thank you for installing XLGantt for Google Sheets. Follow these steps to start using the add-on. 1. Open Google Sheets Open a new or existing Google Sheets spreadsheet. 2. Find the XLGantt Menu In Google Sheets, open: Extensions > XLGantt for Google Sheets If the […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[1050],"tags":[],"class_list":["post-21957","post","type-post","status-publish","format-standard","hentry","category-xlgantt-for-google-sheets"],"yoast_head":"\nGetting Started with XLGantt for Google Sheets - XLWorks<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\"},\"headline\":\"Getting Started with XLGantt for Google Sheets\",\"datePublished\":\"2026-04-26T14:56:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/\"},\"wordCount\":239,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"articleSection\":[\"XLGantt for Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/\",\"url\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/\",\"name\":\"Getting Started with XLGantt for Google Sheets - XLWorks\",\"isPartOf\":{\"@id\":\"https:\/\/xlworks.net\/en\/#website\"},\"datePublished\":\"2026-04-26T14:56:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"XLGantt for Google Sheets\",\"item\":\"https:\/\/xlworks.net\/en\/category\/xlgantt-for-google-sheets\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started with XLGantt for Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/xlworks.net\/en\/#website\",\"url\":\"https:\/\/xlworks.net\/en\/\",\"name\":\"\uc5d1\uc140\uc6cd\uc2a4\",\"description\":\"Excel Works!\",\"publisher\":{\"@id\":\"https:\/\/xlworks.net\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/xlworks.net\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/xlworks.net\/en\/#organization\",\"name\":\"XLWorks\",\"url\":\"https:\/\/xlworks.net\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png\",\"contentUrl\":\"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png\",\"width\":512,\"height\":512,\"caption\":\"XLWorks\"},\"image\":{\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/excelworks\/\",\"https:\/\/www.youtube.com\/c\/xlworks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/xlworks.net\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g\",\"caption\":\"Admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Getting Started with XLGantt for Google Sheets - XLWorks","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:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/","twitter_misc":{"Written by":"Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#article","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/"},"author":{"name":"Admin","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a"},"headline":"Getting Started with XLGantt for Google Sheets","datePublished":"2026-04-26T14:56:21+00:00","mainEntityOfPage":{"@id":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/"},"wordCount":239,"commentCount":0,"publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"articleSection":["XLGantt for Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/","url":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/","name":"Getting Started with XLGantt for Google Sheets - XLWorks","isPartOf":{"@id":"https:\/\/xlworks.net\/en\/#website"},"datePublished":"2026-04-26T14:56:21+00:00","breadcrumb":{"@id":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/xlworks.net\/en\/getting-started-with-xlgantt-for-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"XLGantt for Google Sheets","item":"https:\/\/xlworks.net\/en\/category\/xlgantt-for-google-sheets\/"},{"@type":"ListItem","position":2,"name":"Getting Started with XLGantt for Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/xlworks.net\/en\/#website","url":"https:\/\/xlworks.net\/en\/","name":"\uc5d1\uc140\uc6cd\uc2a4","description":"Excel Works!","publisher":{"@id":"https:\/\/xlworks.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/xlworks.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/xlworks.net\/en\/#organization","name":"XLWorks","url":"https:\/\/xlworks.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png","contentUrl":"https:\/\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlworks_logo_new_w512.png","width":512,"height":512,"caption":"XLWorks"},"image":{"@id":"https:\/\/xlworks.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.instagram.com\/excelworks\/","https:\/\/www.youtube.com\/c\/xlworks"]},{"@type":"Person","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/a1811d47aca1af1770b05a0a0938f33a","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/xlworks.net\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c51b70865d63eda5b2f50ebef685a6df4b9fac341c5132ce8541d9ba61101475?s=96&d=identicon&r=g","caption":"Admin"}}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7qvkj-5I9","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/comments?post=21957"}],"version-history":[{"count":1,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21957\/revisions"}],"predecessor-version":[{"id":21958,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/posts\/21957\/revisions\/21958"}],"wp:attachment":[{"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/media?parent=21957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/categories?post=21957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlworks.net\/en\/wp-json\/wp\/v2\/tags?post=21957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}