XLGantt for Google Sheets™
XLGantt (pronounced “Excel Gantt”) for Google Sheets™ is a Google Sheets™ editor add-on that helps you create and manage project schedules directly in Google Sheets™.
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.
Unlike the Excel version of XLGantt, this version works as a Google Sheets™ add-on and does not require Excel macros.
What You Can Do
1. Create a Project Schedule Template
XLGantt can create a ready-to-use project schedule template in Google Sheets™.
Menu: Extensions > XLGantt for Google Sheets™ > Create New Project Template
The template includes:
- Schedule sheet
- Progress sheet
- Calendar sheet
- AnalysisReport sheet
- Progress_Data sheet
2. Manage Tasks and WBS
You can manage project tasks using a WBS structure with up to 10 task levels.
The Schedule sheet includes fields such as:
- WBS
- Task name
- Start date
- Finish date
- Total workload
- Planned workload
- Planned duration
- Actual start date
- Actual finish date
- Actual workload
- Resources
- Deliverables
- Planned progress
- Actual progress
3. Update Schedule and Gantt Chart
After entering task information, click “Update Schedule” to calculate the schedule and display the Gantt chart.
Menu: Extensions > XLGantt for Google Sheets™ > Update Schedule
XLGantt calculates:
- Total duration
- Planned duration
- Planned workload
- Actual workload
- Planned progress
- Actual progress
- Project progress summary
- Gantt chart timeline
4. Track Project Progress
The Progress sheet shows the overall status of the project, including:
- Total project workload
- Planned workload to date
- Earned value
- Actual incurred workload
- Planned progress rate
- Actual progress rate
- Difference between planned and actual progress
5. Create Analysis Reports
XLGantt provides analysis reports for project tracking.
Available reports include:
- Progress by Resources
- Workloads by Weeks
- Workloads by Months
- Workloads by Resources
- Progress by Weeks
- Progress by Months
- Progress Data
These reports help you review project progress, workload distribution, and resource workload status.
6. Manage Nonworking Days with Calendar
The Calendar sheet lets you manage nonworking days used in schedule calculations.
You can manually enter nonworking days or retrieve public holiday data from the server.
Supported holiday data:
- Korean Public Holidays
- U.S. Federal Holidays
When holidays are retrieved from the server, existing dates in the Calendar sheet remain unchanged.
7. Schedule Change Management
XLGantt can manage both planned schedules and actual schedules.
When schedule change management is enabled, you can enter actual start dates, actual finish dates, and actual workloads to compare planned and actual progress.
8. Multilingual Support
XLGantt for Google Sheets™ currently supports:
- English
- Korean
The default language is English. Users can change the language from the Options sidebar.
9. Customizable Options
The Options sidebar lets you configure:
- Project name
- Project period
- Calculation base date
- Schedule change management
- Calendar and holiday settings
- Language
- Gantt chart display options
- Actual progress color settings
Data and Privacy
XLGantt for Google Sheets™ works inside the current Google Sheets™ document.
The add-on accesses and modifies only the spreadsheet where it is used. It stores add-on settings using Google Apps Script PropertiesService.
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.
For more information, please see:
Privacy Policy:
Terms of Service:
Support
If you have questions, feedback, or need support, please contact us.
Email:
xlworks.net@gmail.com
Website:
https://xlworks.net/en/
Developer:
XLWorks
Related Product
If you use Microsoft Excel, you can also try the Excel version of XLGantt:
Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release
Google Sheets™ is a trademark of Google LLC.
