Import data from google sheets to matlab

2019 12 12
3 个回答
更新时间：2026 2 1
75 次查看（30 天）

1 个投票

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.

请先登录，再回答此问题。

回答（3 个）

Donald
Donald 2021-3-4

10 个投票

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);

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Stuart Mangles
Stuart Mangles 2021-3-12
This is great - is there a way to skip the first row? The sheet I am using has header info in the first row and the actual variable names in the second row.
Bennet Den Hoed
Bennet Den Hoed 2021-8-3
Stuart,
I am finding that any headers that I have in my Google Sheet get included into the "header" of the MATLAB table (unsure of the technical term - see yellow highlight in screenshot). Only the numeric values are included in the MATLAB table itself, making it 4x2 instead of 5x2.
I am actually interested in having the headers included in the table (5x2 case is desirable for me). I've played around a bit, without much luck.
  1. Inserting another row of "dummy headers" in row 1 of the Google Sheet: The two strings get concatenated and left in the "header" of the MATLAB table, still.
  2. Placing the headers at the bottom row of the Google Sheet: These headers are ignored and generic names (Var1, Var2) are instead assigned.
  3. Creating a table of only characters in the Google Sheet: First row is put into the MATLAB "header" and the body of the MATLAB table becomes the other strings.
It seems that the table must be either all numbers or all strings. Again, I would like there to be a mix of this (5x2 case, with the headers as the first row of the MATLAB table).
Can anyone help me figure out how to do this?
Umair Mughal
Umair Mughal 2021-12-21
That's really great, but doesn't work for protected sheets. The url returns the html content of google login page
thierry Lanoe
thierry Lanoe 2023-3-25
is there a solution with "protected sheets"
O.Hubert
O.Hubert 2024-6-5
Bennet, have you tried passing the ContentType option to webread (see the help here)?
Marcos Hannibal
Marcos Hannibal 2026-2-1，20:06
thierry quitale la proteccion cambiando la opcion de compartir a "cualquier persona que tenga el enlace" en google sheets
Walter Roberson
Walter Roberson 2026-2-1，22:45
Approximate translation of what @Marcos Hannibal posted:
Thierry, remove the protection by changing the sharing option to "anyone with the link" in Google Sheets.

请先登录，再进行评论。

Hiro Yoshino
Hiro Yoshino 2019-12-12

0 个投票

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

I think this is for the offline files, I want to take from online source which is specifically google sheets.

请先登录，再进行评论。

0 个投票

I have same problem please help me I want to real time uptade data fron google sheet to mathlab gui

类别

在 帮助中心 和 File Exchange 中查找有关 Google 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by