You can paste the text into a highlghted cell and each hard return in the text will trigger another row (by default, hard returns create rows and tabs create columns) so providing there are no tabs in the text it will be confined to a single column.

As long as the text frame spans 2 pages then so can your table. The table can be autoflowed into as many spreads as necessary by clicking on the red overflow sybol on the text frame's out port. With the cursor now loaded, add a second page and shift and click inside the empty text frame (you will need to have created a text frame on the master page spread first).