How to insert a matrix from a website into a sheet?

[Adel Makram]

Say, I have a matrix which I obtained from a website for matrix calculation, how to insert it into an excel so as for each cell in the matrix, there is a corresponding cell in the excel sheet?

 

[jedishrfu]

Have you tried copy and paste ?

Also some apps will have a paste special menu where you can select paste options like unformatted or preserve formatting that you could try.

 

[Adel Makram]

Have you tried copy and paste ?

Also some apps will have a paste special menu where you can select paste options like unformatted or preserve formatting that you could try.

Trying pasting it into excel, leads to insertion in the first cell only.

 

[jedishrfu]

So did you see if there's a paste special?

Another idea is to paste in a document and adjust it to be a csv file, a comma separated variable file.

You could also try pasting it into googles spreadsheet and then copying from there to yours.

Google will have an export feature too where you can mark cells and rxport as a csv.

 

[Adel Makram]

So did you see if there's a paste special?

Another idea is to paste in a document and adjust it to be a csv file, a comma separated variable file.

You could also try pasting it into googles spreadsheet and then copying from there to yours.

Google will have an export feature too where you can mark cells and rxport as a csv.

It is not working in google spreadsheet. Regarding, csv file, I have no option to do so when I saved the file into the MS word.

 

[jedishrfu]

So you want to copy a spreadsheet from google to excel? That should work. Is it only numbers?

Do you have google drive installed? Google won't let you copy if its not installed as it can't access your local clipboard without google drive software running.

 

[Adel Makram]

So you want to copy a spreadsheet from google to excel? That should work. Is it only numbers?

Do you have google drive installed? Google won't let you copy if its not installed as it can't access your local clipboard without google drive software running.

The attached image is a matrix from a site for matrix calculation, I just want to past it into excel so that each number occupies one cell!

 

[phyzguy]

Trying pasting it into excel, leads to insertion in the first cell only.

After you have the data pasted into the first cell, select "Text to Columns" from the Data menu. This will allow you to split it into separate columns. You can choose the delimiter to be spaces, commas, or whatever.

 

[Adel Makram]

After you have the data pasted into the first cell, select "Text to Columns" from the Data menu. This will allow you to split it into separate columns. You can choose the delimiter to be spaces, commas, or whatever.

wow, it works, thank you very much

 

[jedishrfu]

When I used the copy/paste feature, MS Excel had a little menu next to the paste location where you could specify using the text wizard where you selected fixed column text which did the same thing.

Glad Phyzguy's suggestion worked for you.

 

[Borg]

After you have the data pasted into the first cell, select "Text to Columns" from the Data menu. This will allow you to split it into separate columns. You can choose the delimiter to be spaces, commas, or whatever.

Interesting, I never paid attention to that button. Every once in a great while that would have come in handy. Now if I can just remember about it when the next time comes around...

 

[jtbell]

Regarding, csv file, I have no option to do so when I saved the file into the MS word.

How many entries does the table have? If it's not a huge number and you need to do it only once, you could simply add the commas by hand.

If you know some programming language, you could write a program to read the data and write it back out again with commas or tabs. This is worthwhile only if there's a huge number of entries, or you need to do it repeatedly.

 

[jtbell]

a little menu next to the paste location where you could specify using the text wizard

Aha, now I remember the text wizard. You also get it if you save the table into a text file, then open that file in Excel. That's how I've used it.