Best Way to Format an Excel Data Sheet for export to R.

#1
Hi.

I am conducting a multiple linear regression using Panel data for my finance honours research project.
I have collected data for 100 stocks each month over 13 years for 6/7 explanatory variables.
I have attached my spreadsheet in this post.

My question is as follows:

What is the best way of formatting the data in this excel spreadsheet so it can be exported to R? I (think) I need to remove the company names (the ticker symbols) and the dates and organise the data per variable? What is the best way of formatting excel so it can be exported to R?