Copy a complete chat from whatsapp to PC
Open the conversation. Enter options menu -&gt; more -&gt; export chat -&gt; with media -&gt; send via email
Check your email. Save all attachments to disk.
Open the text file with Wordpad. Press CTRL + H. Replace string - Name 1: with the string |Name 1| and repeat for Name 2. Save it.
Open spreadsheet, and use | as separator, when importing a text file.