Whatever they do, save it as a CSV (comma separated variable) file. .csv
Those will automatically open with Excel even if you open it from the website itself.
The only thing you lose is RTF rich text formatting. But I would guess it's the
values that you're interested in, not the Excel sheet layout itself. To me, the .csv
would be the easiest way. You can also combine them all into one .csv before
you open it if you want.
Run this little PHP script test. Save this script as "test.php" run it,
and then try to open the "test.csv" file using your browser.
PHP Code:
<?php
$text="
Smith, John, 12345, xxx,
Johnson, Richard, 3243, xxx,
Anderson, Jane, 5674, xxx,
";
$file="test.csv";
$fw = fopen($file, 'w') or die("can't open file");
fwrite($fw, $text);
fclose($fw);
echo"<br /><br />
<a href='test.csv'>Open me</a>
";
?>
Make sure the directory you upload in has permission to write to a file.
.