How to export a google spreadsheet to a clean HTML table

  1. Open your google spreadsheet.
  2. Click File > Download > Web page.
  3. Open the downloaded file with Visual Studio.
  4. Select All, right click and Format.
  5. Open the downloaded file with textpad.
  6. Click F8 and use search and replace to clean your table.
  7. First remove unneeded items by replacing with an empty string.
  8. Check Regular expression and use the . (dot) character to replace any character.
  9. To remove empty lines search for ^\r\n.