If you have embedded newlines, Text::CSV won't handle them but Text::CSV_XS and Text::xSV will. If you're a database person, consider DBD::CSV or DBD::AnyData both of which can treat CSV files as DBI data sources.