The _PP at the end of the module name indicates that it is "pure perl", so it doesn't actually need to be installed. You can take the source code from http://search.cpan.org/src/MAKAMAKA/Text-CSV-1.10/lib/Text/CSV_PP.pm and use it as follows.

Make a subdirectory of your current directory named "Text" (it's case sensitive), then save CSV_PP.pm into that directory. Then

use Text::CSV_PP;
[download]

will work just as though the module were "properly installed." You could even just paste indivdual subroutines into your source code instead of using the whole module. But if you do that, be a good netizen and paste in the author's copyright statement, and the source where you downloaded the code.