Import data from google sheets to matlab

253 views (last 30 days)
Hello guys,
I wanted to import data from google sheets to matlab. However I couldn't find any information about it. Since the google sheets always geting update I can't just copy and paste so I wanted to import new data for every time I run the matlab script. Is there a way?
Thanks in advance.

Answers (3)

Donald
Donald on 4 Mar 2021
First, find the ID for your Sheet. It's the long string if you look at the URL. For example,
http s://docs.google.com/spreadsheets/d/bladjaljd77442n2j3ljk2j3j2jdkdjad/edit#gid=1498695871
Then it's easy
ID = 'bladjaljd77442n2j3ljk2j3j2jdkdjad'
sheet_name = 'My Sheet';
url_name = sprintf('https://docs.google.com/spreadsheets/d/%s/gviz/tq?tqx=out:csv&sheet=%s',...
ID, sheet_name);
sheet_data = webread(url_name);
  3 Comments
Umair Mughal
Umair Mughal on 21 Dec 2021
That's really great, but doesn't work for protected sheets. The url returns the html content of google login page

Sign in to comment.


Hiro
Hiro on 12 Dec 2019
  1 Comment
Hüseyin Cagdas Yatkin
Hüseyin Cagdas Yatkin on 12 Dec 2019
I think this is for the offline files, I want to take from online source which is specifically google sheets.

Sign in to comment.


dimuthu chathuranga
dimuthu chathuranga on 9 Apr 2021
I have same problem please help me I want to real time uptade data fron google sheet to mathlab gui

Categories

Find more on Files and Folders in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!