Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text?

[MR_Xishuai]

Hi All,

I am trying to get the Fama French 25 Portfolio Returns, but on Fama French's Data Library website:Kenneth R. French - Data Library

I could only get the txt files. And I could not just copy it to excel as it will result in just one variable(all the observations in just one row). Is there a way that I could make them into a nice format(either SAS or Excel format)? I am wondering do they provide these data in SAS or Excel format? Or is there a way for me to create them from the .txt file they provided? Thanks so much!

[Reeza]

When you have your data in Excel - the single row, highlight the rows, click on the DATA table then Text to Columns.

How to parse data using the Text To Columns command in Excel</title> <!-- integration code for PDF -...