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

2,378 views (last 30 days)
Fernando De Ita on 2 Dec 2017
Commented: Peter Perkins on 8 Nov 2021
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
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?

### More Answers (3)

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
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.