Establish a CSV Feed to Google Sheets

You can use TeamGantt's CSV feed feature to export your TeamGantt project data to a Google Sheet. Changes you make in TeamGantt will be updated in your Google sheet automatically. It is a one way feed, so it is not possible to make changes in your Google Sheet and have them sync back to TeamGantt.


How do I sync my TeamGantt project with Google Sheets?

To setup the CSV feed, first open your TeamGantt project (or projects) in Gantt chart view. Then go to Menu > CSV Feed:

Then copy the resulting link:

Next, open your empty Google Sheet. In the first cell (upper left), type in: =importdata("pasteyourlinkhere") and press enter. Your TeamGantt project data in CSV format should populate the Google Sheet immediately. It should look like this:

Now you're done! Your Google Sheet will update the data from TeamGantt at regular intervals. 


How frequently does Google Sheets update data from TeamGantt?

Google's website currently suggests it could take up to 1 hour for Sheets to update the data.


Can I refresh data between automatic updates?

Yes. If you would like to force a refresh, simply click the first cell with your import formula, copy it, delete that cell, and then paste your formula back into it. This will force Google Sheets to pull fresh data from TeamGantt.

Still need help? Contact Us Contact Us