# How do I convert table data to double to manipulate them?

3,475 views (last 30 days)
Fernando De Ita on 2 Dec 2017
Commented: Peter Perkins on 8 Nov 2021 at 22:12
I extracted data from a table, when I get an element it comes as table format but when trying to make some operations like multiplication there is an error, is there any direct command or a series of steps? Can you help please
Peter Perkins on 8 Nov 2021 at 22:12
This new example goes even further into indexing and the topic of "doing math on data stored in a MATLAB table":
It's a new-for-R2021b example, but doesn't require the latest MATLAB for anything (most anything?) it covers.

Star Strider on 2 Dec 2017
I would use the table2array (link) function. It will put your table into a double array, so you can do whatever you want with it then.
Ivania Jimenez-Lara on 3 Nov 2020
would you mind showing me what the code for that would look like?

Peter Perkins on 19 Dec 2017
The answer might be as simple as something like T.Z = T.x .* T.y. Without more information, hard to tell.

Roger Breton on 8 Mar 2021
Edited: Roger Breton on 8 Mar 2021
It does not work for me : all I want is to be able to import a range from Excel, and all I get is a "Table" on which I can't do any operation?
Stephen on 25 Aug 2021
If you just need a numeric matrix, why are you importing the data as a table? Use REDAMATRIX instead.

Arshey Dhangekar on 7 Jul 2021
Hello I have csv data of 18 columns and want to convert into double
so instead of writing 18 str2double code how can I convert all the 18 columns in short line of code
Temp.x310_Ambient__C_ = str2double (Temp.x310_Ambient__C_);
Peter Perkins on 8 Nov 2021 at 22:10
1) Post a new question, don't ask a question in a reply to someone else's question.
2) This example may be of help for the topic of "doing math on data stored in a MATLAB table":
It's a new-for-R2021b example, but doesn't require the latest MATLAB for anything (most anything?) it covers.