I was looking for a quick way to get a structured table from some data I had in Numbers. Unfortunately Numbers isn’t scriptable and doesn’t seem to offer plain HTML export. After a little poking around, I just ended up writing a script to do what I wanted.
This little AppleScript will convert anything text in the clipboard into a simple, unstyled HTML table. View the script in Script Editor
Just save it into your Scripts folder and call it after copying some data to the clipboard. Any text on your clipboard will be converted to a basic, un-styled HTML table, ready to paste.
set oldDelims to AppleScript‘s text item delimiters
set AppleScript‘s text item delimiters to return
set TRs to every text item of (the clipboard as text)
set AppleScript‘s text item delimiters to tab
set theTable to “<table>” & return
repeat with TR in TRs
copy theTable & “<tr>” & return to theTable
repeat with TD in text items of TR
copy theTable & “<td>” & TD & “</td>” & return to theTable
copy theTable & “</tr>” & return to theTable
copy theTable & “</table>” to theTable
set AppleScript‘s text item delimiters to oldDelims
set the clipboard to theTable