Form email (php) to spreadsheet

[nomad]

I have a form email created in HTML and php and I want to have the info populated to:
1. an email (I know how to do this part)
2. to a spreadsheet which updates without losing the previous data (ie much like google forms but I don't want to use them because of the logos and copy write info)

If anyone can help me that could be great the easier the better,

Thanks
damon

[Luuk]

Why not simply write info to a csv file?
It is very simple to read those in a spreadhseet.

[nomad]

Thanks Luuk

I need some help I wrote some code but I need the 3 fields created instead of one when I open the data in excel
Here is my info
Html

<form name="contactform" method="post" action="contact_us_how_can1.php">
 
  <section class="form">
    <textarea name="comments" cols="110" rows="6" class="col_form_bold">How can we help you?</textarea>
 </section>
 
   <section class="col_form"> 
 Your Name: <input name="Your_name" type="text" class="col_form_bold1" value="Full Name" size="35"  />
  </section>
 
   <section class="col_form"> 
 Your email: 
   <input name="email" type="text" class="col_form_bold1" value="email@example" size="32"  />
   </section>
   <section class="col_form">  
     <input type="submit" class="message"    value="   Send Message   " />
     </section>
 </form>
 

PHP code

 <?
 
 
if(isset($_POST['email'])) {
 
    // EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "[e-mail]" ;
    $email_subject = "How can I help you";
 
 
 
    if(!isset($_POST['comments']) ||
        !isset($_POST['Your_name']) ||
        !isset($_POST['email'])) //{
        died('We are sorry, but there appears to be a problem with the form you submitted.');      
   // }
   $del = "\t";
    $data[1] = $_POST['comments'];
    $data[2] = $_POST['Your_name'];
    $data[3] = $_POST['email']; 
    $file = fopen("data.csv", "a");
    $data = "\r\n".implode($del, $data);
    fwrite($file, $data);
    fclose($file); 
 
 
 
    $comments = $_POST['comments']; 
    $Your_name = $_POST['Your_name']; 
    $email = $_POST['email']; 
 
 
 
    $email_message = "How can I help you.\n\n";
 
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
    $email_message .= "Comments:    ".clean_string($comments)."\n";
    $email_message .= "Name:    ".clean_string($Your_name)."\n";
    $email_message .= "Email:      ".clean_string($email)."\n";
 
 
// create email headers
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers); 
?>
 
<!-- include your own success html here -->
 
<p>Your response has been recorded and one of our friendly, <br>
support staff  member will answer your questions and brighten your day.<br>
Have a great day!</p>
<?php
}
?>
 
 
Any help would be great. 
damon
 

[Luuk]

maybe:
You have to tell excel to use a tab as separator?

But if that does not solve the problem, i would like to know what you see in this 1 kolom you are getting.

i.e.

$data[1] = "comments";
    $data[2] = "Your_name";
    $data[3] = "email"; print implode(";",$data);

prints:

comments;Your_name;email

This should lead to 3 columns in excel if ";" is set as separator.