We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

calc web page table pastes as single column

asked 2021-02-19 04:42:23 +0200

dave@cincinnati gravatar image

In Yahoo Finance I have a defined view with 3 columns: Symbol, Last Price, & Forward Annual Div Yield. I enter a column of stock symbols, and yahoo populates the other 2 columns. I want to update a calc sheet of stocks, whose first 3 columns are Symbol, Price, & Yield. But when I copy and paste the yahoo 3 columns into my calc sheet's first 3 columns, all the data gets pasted into just the first column, using 5 rows for each row from the yahoo view.

I am guessing there is some way using pivot tables or ? to fold that first column into five columns, so I end up with a row for each stock, with the 3 columns the Yahoo view shows.

But I sure can't figure out how to do that. How can I do this?

Thank you, from Dave

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2021-02-19 14:19:08 +0200

erAck gravatar image

You can try to use menu Sheet -> Link to External Data... and paste the URL, hit Enter, and then select a table there.

edit flag offensive delete link more

answered 2021-02-19 10:15:24 +0200

Przemo gravatar image

There is no guaranteed method as far as I know due to the nature of html formatting. Sometimes I use cell splitting in Calc, sometimes I paste the text in a text file and use vim (text editor) to make columns with tabs or spaces.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-02-19 04:42:23 +0200

Seen: 30 times

Last updated: Feb 19