Exporting Data as a Self-Contained HTML Table
Sometimes you need to share data with someone who does not have Excel, cannot open a CSV reliably, and will not install anything new. The HTML export in ExploreMyData produces a single .html file that opens in any browser on any operating system.
What the output looks like
The exported file contains a complete HTML document with inline CSS. No external stylesheets, no JavaScript dependencies, no CDN links. The file is entirely self-contained.
The table is responsive: it scrolls horizontally on narrow screens and remains readable on desktop. It includes alternating row colors, sticky headers, and proper text alignment for numeric columns. Dark mode is built in via prefers-color-scheme, so the table adapts to the viewer's system preferences automatically.
Here is a simplified example of what the rendered output looks like:
| product | category | revenue | units |
|---|---|---|---|
| Widget A | Hardware | 12,400 | 310 |
| Widget B | Hardware | 8,750 | 215 |
| Service Plan | Software | 23,100 | 462 |
| Connector Kit | Accessories | 3,200 | 640 |
The actual exported file includes a page title (the file name), a timestamp, and a row count at the top. The styling is clean and minimal.
When to use HTML export
HTML is the right export format in a few specific situations:
- Sharing with non-technical stakeholders. Attach the file to an email or Slack message. The recipient double-clicks it and sees a formatted table. No software needed beyond a web browser.
- Embedding in internal wikis or documentation. Many wikis (Confluence, Notion, internal tools) accept HTML embeds or allow you to paste HTML source. The self-contained nature of the export makes this straightforward.
- Quick visual previews of query results. If you ran a complex pipeline and want to snapshot the output for later reference, HTML preserves the formatting better than a raw CSV.
- Archiving data snapshots. HTML files are stable over time. They don't depend on a specific application version or online service. A file exported today will render identically in a browser ten years from now.
How to export
- Load your file (CSV, JSON, Parquet, Excel, or XML).
- Apply any transformations: filter rows, rename columns, aggregate, sort.
- Click Export in the toolbar.
- Select HTML from the format options.
- The file downloads immediately.
The export includes all rows currently visible in the table after your pipeline has run. If you filtered from 10,000 rows down to 200, only those 200 appear in the HTML file.
Compared to other export formats
| Format | Best for | Limitations |
|---|---|---|
| CSV | Programmatic consumption, database import | No formatting, encoding issues in Excel |
| JSON | APIs, web applications, nested data | Not human-readable at scale |
| Excel | Recipients who need formulas or further editing | Requires Excel or compatible software |
| Print-ready documents, formal reports | Static, hard to extract data from | |
| HTML | Browser-readable sharing, zero-setup viewing | Not ideal for programmatic processing |
HTML fills a gap between raw data formats (CSV, JSON) and presentation formats (PDF). It preserves visual structure without requiring any software beyond a browser.