![\"XLGantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2026\/04\/xlgantt4gs_01.png?ssl=1\")
<\/a><\/p>\nXLGantt (pronounced \u201cExcel Gantt\u201d) for Google Sheets\u2122 is a Google Sheets\u2122 editor add-on that helps you create and manage project schedules directly in Google Sheets\u2122.<\/p>\n
With XLGantt, you can enter tasks, start and finish dates, resources, deliverables, and progress values, then update the schedule to automatically calculate durations, planned progress, actual progress, workloads, and Gantt chart views.<\/p>\n
Unlike the Excel version of XLGantt, this version works as a Google Sheets\u2122 add-on and does not require Excel macros.<\/p>\n
<\/p>\n
What You Can Do<\/h2>\n1. Create a Project Schedule Template<\/h3>\n
XLGantt can create a ready-to-use project schedule template in Google Sheets\u2122.<\/p>\n
Menu: Extensions > XLGantt for Google Sheets\u2122 > Create New Project Template<\/p>\n
<\/p>\n
The template includes:<\/p>\n
- Schedule sheet
\n- Progress sheet
\n- Calendar sheet
\n- AnalysisReport sheet
\n- Progress_Data sheet<\/p>\n
2. Manage Tasks and WBS<\/h3>\n
You can manage project tasks using a WBS structure with up to 10 task levels.<\/p>\n
The Schedule sheet includes fields such as:<\/p>\n - WBS After entering task information, click \u201cUpdate Schedule\u201d to calculate the schedule and display the Gantt chart.<\/p>\n Menu: Extensions > XLGantt for Google Sheets\u2122 > Update Schedule<\/p>\n XLGantt calculates:<\/p>\n - Total duration The Progress sheet shows the overall status of the project, including:<\/p>\n - Total project workload XLGantt provides analysis reports for project tracking.<\/p>\n Available reports include:<\/p>\n - Progress by Resources These reports help you review project progress, workload distribution, and resource workload status.<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n The Calendar sheet lets you manage nonworking days used in schedule calculations.<\/p>\n You can manually enter nonworking days or retrieve public holiday data from the server.<\/p>\n Supported holiday data:<\/p>\n - Korean Public Holidays When holidays are retrieved from the server, existing dates in the Calendar sheet remain unchanged.<\/p>\n XLGantt can manage both planned schedules and actual schedules.<\/p>\n When schedule change management is enabled, you can enter actual start dates, actual finish dates, and actual workloads to compare planned and actual progress.<\/p>\n XLGantt for Google Sheets\u2122 currently supports:<\/p>\n - English The default language is English. Users can change the language from the Options sidebar.<\/p>\n The Options sidebar lets you configure:<\/p>\n - Project name XLGantt for Google Sheets\u2122 works inside the current Google Sheets\u2122 document.<\/p>\n The add-on accesses and modifies only the spreadsheet where it is used. It stores add-on settings using Google Apps Script PropertiesService.<\/p>\n The add-on may connect to xlworks.net only to download public holiday data. It does not send your spreadsheet content, task data, project data, personal data, or Google account data to the external server.<\/p>\n For more information, please see:<\/p>\n Privacy Policy:<\/p>\n Privacy Policy for XLGantt for Google Sheets\u2122<\/a><\/p><\/blockquote>\n<\/a><\/p>\n
\n- Task name
\n- Start date
\n- Finish date
\n- Total workload
\n- Planned workload
\n- Planned duration
\n- Actual start date
\n- Actual finish date
\n- Actual workload
\n- Resources
\n- Deliverables
\n- Planned progress
\n- Actual progress<\/p>\n3. Update Schedule and Gantt Chart<\/h3>\n
\n- Planned duration
\n- Planned workload
\n- Actual workload
\n- Planned progress
\n- Actual progress
\n- Project progress summary
\n- Gantt chart timeline<\/p>\n4. Track Project Progress<\/h3>\n
<\/a><\/p>\n
\n- Planned workload to date
\n- Earned value
\n- Actual incurred workload
\n- Planned progress rate
\n- Actual progress rate
\n- Difference between planned and actual progress<\/p>\n5. Create Analysis Reports<\/h3>\n
\n- Workloads by Weeks
\n- Workloads by Months
\n- Workloads by Resources
\n- Progress by Weeks
\n- Progress by Months
\n- Progress Data<\/p>\nProgress by Resources<\/h4>\n
<\/a><\/p>\nWorkloads by Weeks<\/h4>\n
<\/a><\/p>\nProject Progresses by Weeks<\/h4>\n
<\/a><\/p>\n6. Manage Nonworking Days with Calendar<\/h3>\n
<\/a><\/p>\n
\n- U.S. Federal Holidays<\/p>\n7. Schedule Change Management<\/h3>\n
8. Multilingual Support<\/h3>\n
\n- Korean<\/p>\n9. Customizable Options<\/h3>\n
<\/p>\n
\n- Project period
\n- Calculation base date
\n- Schedule change management
\n- Calendar and holiday settings
\n- Language
\n- Gantt chart display options
\n- Actual progress color settings<\/p>\nData and Privacy<\/h2>\n