A couple of months ago I downloaded a CSV file from Google containing the stats of my sites. I decided to turn it into an HTML table using PHP. Here's how it's done:
<?php
$csv = fopen('top-search-queries.csv', 'r') or die ("Can't open file.");
echo '<table border="1" cellspacing="2" cellpadding="3">' . "\n";
while($csv_line = fgetcsv($csv)) {
echo "<tr>\n";
for($i = 0, $j = count($csv_line); $i < $j; $i++) {
echo '<td>' . htmlentities($csv_line[$i]) . '</td>' . "\n";
}
echo "</tr>\n";
}
echo "</table>\n";
fclose($csv) or die("Can't close file");
?>
I used the fgetcsv() function to parse the CSV file line by line. It's a really straightforward function, but it's very useful in cases like this.