image thumbnail

GetGoogleSpreadshee​t

version 1.0.0.0 (1.97 KB) by Daniel
Download a google spreadsheet as csv and import into a Matlab cell array.

2.6K Downloads

Updated 02 Jan 2016

View License

result = GetGoogleSpreadsheet(DOCID)
[DOCID] A value like '0AmQ013fj5234gSXFAWLK1REgwRW02hsd3c', which is found in your spreadsheet's url: https://docs.google.com/spreadsheets/d/<here>/edit#gid=0.

[result] cell array of the the values in the spreadsheet

IMPORTANT: The spreadsheet must be shared with the "anyone with the link" option.

This has no error handling and has not been extensively tested.
Please report issues in comments below.

Thanks to @MarkTomaszewski and @Constantine for noting the updated url format (the above description has been updated to reflect this).

Cite As

Daniel (2021). GetGoogleSpreadsheet (https://www.mathworks.com/matlabcentral/fileexchange/39915-getgooglespreadsheet), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2012b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired: Matlab to Google Sheets (matlab2sheets)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!