Overview
Office Timeline’s Google Sheets integration lets you quickly turn your spreadsheet data into a professional timeline or Google Sheets Gantt chart. Visualize your project using our online timeline maker in just a few clicks.
Consult this comprehensive guide, use the navigation links above to jump to specific sections, or watch the video summary below:
A) Connect Google Sheets
Click Import and select Google Sheets.
Click Connect and follow the prompts to authorize your Google account.
To disconnect at any time, click the Gear icon.
🔒 Your data is secure: Office Timeline will only access the sheet you select.
B) Prepare Your Google Sheets Data
Click the link below to get started:
Make a copy of the Google Sheets templateWhen prompted, click Make a copy.
The sheet is saved to your Google Drive. You can rename, edit, and share it as needed.
Troubleshooting Tips
You must be signed in to a Google account to make a copy.
If you see an error, double-check your login or try the link in a private or incognito browser window.
C) Import from Google Sheets
Click Import and select Google Sheets.
Click Use to start the import.
Select your sheet and click Submit.
If your sheet is formatted correctly, Office Timeline will automatically map your columns and create your timeline.
Timelines work best with fewer than 50 rows. If you try to import more, you’ll see a warning. You can continue or go back and edit your sheet.
D) Manually Mapping Columns
Sometimes, you may need to map columns manually. You’ll be prompted to identify:
Sheet
Header for Task/milestone titles
Header for start dates
Header for end dates
Header for swimlanes (optional)
After mapping, click Import Sheet to continue.
E) Google Sheets Data
Your imported tasks and milestones are linked to the data in your Google sheet. You can see this indicated by the Sheets symbol next to each object in the Data tab. Any objects added after importing will not have this symbol and will not be updated when syncing data.
