Home » Mac, Reviews, how to

Mac Tips: Convert a Numbers Table to HTML

4 February 2014 1,428 views No Comment

Wanna tip? Don't pet a burning dog. Wanna Mac tip? Here are two quick and easy ways to convert a Numbers table into HTML — both free!

Wanna tip? Don’t pet a burning dog. Wanna Mac tip? Here is a two-fer for ya! A pair of quick and easy ways to convert a Numbers table into HTML, both are free and did I mention easy?

Once upon a time, tables ruled the web. Since the advent of CSS and JavaScript, tables haven’t gotten much love, though they still have a place.

The first thing to remember is that heavily formatted tables won’t convert well — simple is better. For example, cell, row and column specific text size, justification and other settings will likely get lost in the conversion.

Additionally, you will might need to hand tweak the HTML code to get the look you want.

Numbers Table to HTML: TextEdit

Wanna tip? Don't pet a burning dog. Wanna Mac tip? Here are two quick and easy ways to convert a Numbers table into HTML — both free!

In Numbers, copy the contiguous cells you want to convert to HTML. Paste into a blank TextEdit document.

Next, press Command + S (File > Save) and then, as shown above, choose Web Page (.html) from File Format drop down menu.

And, as you can see in this side by side comparison — Safari on the left, TextEdit on the right) — the output is very true to the original, including funky superscript characters.

Numbers Table to HTML: AppleScript

Wanna tip? Don't pet a burning dog. Wanna Mac tip? Here are two quick and easy ways to convert a Numbers table into HTML — both free!

Brati’s Lover has created an Export Table to HTML AppleScript for Numbers. Happily enough, with the last week’s release of Numbers 3.1, AppleScript support is back — yea, Apple.

Just download the script and save it to ~/Library/Scripts/Applications/Numbers/ (see also How to: Make Library visible in OS X 10.8). If your Library folder doesn’t have the Applications/Numbers directories, you can either manually add them or just save the script anywhere inside Scripts.

Mac Tip: Be sure to add AppleScript to your menubar (Utilities > AppleScript Editor > Preferences > click “Show script menu in menu bar”).

Now, with the script successfully installed and the table you want to export to HTML on top, run the Number to Table HTML script from the menu bar. The script will prompt you to make some adjustments (leave them blank if you don’t understand).

The output is automagically copied to the clipboard > just paste it into your HTML document (i.e. WordPress, TextEdit, etc). You may find that formulas and other hidden formatting in the resulting HTML code is visible when viewed in Safari.

You can clean that up by pasting the code into TextEdit and performing a Find & Replace.

Share your Mac tips and AppleScript secrets in the comments below…

Table data: US EPA Top 30 Tech & Telecom Green Power Users

Related Posts:
MacBook Pro Tops Gigabit WiFi Speed Test
Mac Keyboard Shortcut: Print Directly from the Finder
Mac Keyboard Shortcut: Print Directly from the Finder
Show and Hide OS X Dock with Mac Keyboard Shortcut
12-Core Mac Pro Posts 33K Genchbench Score

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.