Blog

Open Sharesight reports directly in Google Sheets

by Angela Thompson, Senior Digital Marketing Manager, Sharesight | Dec 7th 2015

Following on from our update to provide reports in OpenXML format, we have additionally enabled support for opening reports directly in Google Sheets, where you can edit them online. These documents are automatically stored in your Google Drive account, where you can access them again in future.

Open Sharesight reports directly in Google Sheets - Featured

To open a report directly in Google Sheets, click on the Google Drive icon next to the Excel and PDF icons on all Sharesight reports:

Open Sharesight report in Google Sheets

To use this feature for the first time, you will be prompted to sign in to your Google account and authorise Sharesight to create files in Google Drive. If you have multiple Google accounts, you will be asked to select the Google Drive account in which you wish to open the report:

Select Google account

Click “Allow” to authorise Google to open your report in Google Sheets:

Authorise Google

Your report will then open in Google Sheets , where it will be automatically saved and can be edited directly:

Sharesight report in Google Sheets

Please let us know in the Sharesight forum if you experience any issues or would like to provide feedback!

FURTHER READING

Top 50 investing and finance blogs

Top 50 finance and investing blogs in 2025

by Stephanie Stefanovic | Mar 30th 2025

Check out this list created by the Sharesight team, covering the 50 best personal finance and investment blogs from around the world.

Listed investment companies2

Why invest in listed investment companies?

by Geoff Wilson AO, Founder and Chairman, Wilson Asset Management | Mar 26th 2025

Listed Investment Companies (LICs) offer access to professional fund management, franked income and long-term capital growth. Keep reading to learn more.

Sharesight vs alternatives

Sharesight vs. alternatives: Why investors choose our portfolio tracker

by Prashant Mohan | Mar 19th 2025

Compare Sharesight to alternative portfolio trackers and see why 500,000+ investors trust Sharesight for smarter portfolio management and tax reporting.