GetGoogleSpreadsheet
Download a google spreadsheet as csv and import into a Matlab cell array.
You are now following this Submission
- You will see updates in your followed content feed
- You may receive emails, depending on your communication preferences
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 (2026). GetGoogleSpreadsheet (https://nl.mathworks.com/matlabcentral/fileexchange/39915-getgooglespreadsheet), MATLAB Central File Exchange. Retrieved .
Acknowledgements
Inspired: Matlab to Google Sheets (matlab2sheets)
General Information
- Version 1.0.0.0 (1.97 KB)
MATLAB Release Compatibility
- Compatible with any release
Platform Compatibility
- Windows
- macOS
- Linux
| Version | Published | Release Notes | Action |
|---|---|---|---|
| 1.0.0.0 | minor reformat description update description as suggested by commenters |
