Design HTML tables with Google Sheets.

Box Table Baker for Google Sheets.

Version 6

Box Table Baker is a Google Sheets editor add-on that exports selected ranges or entire sheets as HTML tables.

Box Table Baker is a simple HTML table generator for Google Sheets. It uses the Google Sheets user interface as your HTML table designer. Export range selections or entire sheets as HTML tables. Copy and paste the HTML tables. Save to Google Drive.

Convert only the HTML you need.

Export HTML tables with merged cells and complex layouts.

Availability

The latest version is Version 6.

Box Table Baker is currently available in the G Suite Marketplace in all regions.

Explanation of Permissions

  • PERMISSION: See, edit, create, and delete your spreadsheets in Google Drive

    • Required to create files and/or folders in Google Drive.

  • PERMISSION: View and manage spreadsheets that this application has been installed in

    • Required to read the spreadsheet values and properties.

  • PERMISSION: Display and run third-party web content in prompts and sidebars inside Google applications

    • Required to generate the Markdown export sidebar.

Features

The following is a list of Box Table Baker features:

  • Exports a selected range (a selection) to an HTML table.

  • Exports an entire sheet to an HTML table.

  • Exports multiple ranges to an HTML table group.

  • Exports pre-defined named ranges to an HTML table group.

  • Exports HTML tables with merged cells as spreadsheet ranges, providing automatic processing of complex layouts that require colspans and rowspans.

  • Exports HTML tables with font colors and sizes.

  • Exports HTML tables with bold font styles .

  • Exports HTML tables with italic font styles.

  • Exports HTML tables with strikethrough font styles.

  • Exports HTML tables with table row heights.

  • Exports HTML tables with table column widths.

  • Exports HTML tables with cell background colors.

  • Exports HTML tables with cell left alignments.

  • Exports HTML tables with cell center alignments.

  • Exports HTML tables with cell right alignments.

  • Exports HTML tables with cell top vertical alignments.

  • Exports HTML tables with cell middle vertical alignments.

  • Exports HTML tables with cell bottom vertical alignments.

  • Skips hidden rows and columns.

  • Multiline support.

  • Default right-to-left support (based on language settings).

  • Monospace font support.

    • Adds generic "monospace" font name after selected Google Sheets font.

  • Supports hidden gridlines.

    • If the gridlines are hidden, the HTML tables are borderless.

  • Exports as HTML table for copy and paste of HTML table into MediaWiki or Wikipedia.

  • Saves HTML table to Google Drive as HTML document.

    • Stores HTML documents in "Box Table Baker" folder on Google Drive.

  • Support for =HYPERLINK formulas with addresses:

    • =HYPERLINK("https://example.com" & A1, "Hello")

    • =HYPERLINK("https://example.com" & foo!A1, "Hello")

    • =HYPERLINK(A1, A2)

    • =HYPERLINK(foo!A1, A2)

Additional Notes

HTML tables are created in HTML syntax. HTML is a fundamental building block for the World Wide Web. HTML is short for Hypertext Markup Language, which is specified by W3C. There are many uses for HTML online.

Learn more:

Google Sheets, Google Chrome Web Store, and G Suite Marketplace belong to Google. All other products and trade names belong to their respective owners.

Live long and prosper. 🖖



... Skadoosh.