Copy pasting CSV (Comma Separated Values) is pretty easy in Excel 2013 !
In short : use the Data > Text to Columns option.
Starting with a CSV file, like the following one, open it in Excel : each row is in one single cell, while you might want them to be separated.
Select your column
Then click on the Data > Text to Columns option
In the Convert Text to Column Wizard, step 1, leave the default option, Delimited file type
In the Convert Text to Column Wizard, step 2, select Comma as a Delimiters (or another one if necessary, like semicolon ; or pipe |)
In the Convert Text to Column Wizard, step 3, you might want to change all the non numerical columns formatting to Text, this to avoiding loosing leading zeros for example
Simply click on the first column, then while holding Shift butting, click on the last one or your selection – you can also add columns to the selection by holding Ctrl and clicking on the column – then select Column data format as Text.
Before hitting the Finish button, in case you get the error message “There’s already data here. Do you want to replace it ?“, or to avoid getting it
Select another Destination cell, and click on an empty cell in the same sheet.
You can then click Finish – and voilà ! Your CSV values have been pasted properly in Excel cells