Number Formatter for Tables

WHAT IT DOES

Number Formatter for Tables is a browser extension that gives you complete control over how numeric data appears in any table on the web. It detects tables on the current page and lets you select specific columns to reformat. Choose from decimal places (0-10), thousand separators (comma, dot, space, or none), currency symbols (prefix or suffix), percentage formatting, or scientific notation. Conditional formatting adds visual cues with color scales, bold, and italic styles based on numeric thresholds you define. A live preview panel shows exactly how values will appear before you commit any changes. Formatting applies directly to the DOM, and you can revert to original values with a single click. All your preferences are saved per domain.

WHERE IT RUNS

Number Formatter for Tables works on any website that presents data in HTML tables. It runs in your browser as a lightweight extension, detecting table structures on the fly. It works on dashboards, financial reports, data portals, internal tools, e-commerce product listings, and research databases. The tool is compatible with static tables, dynamically updated tables, and tables inside iframes where permitted. It does not require backend access or data uploads—everything stays local in your browser.

HOW TO USE

After installation, click the extension icon or use the keyboard shortcut to open the floating panel. The panel scans the page and lists every table found, along with its column headers. Select a table from the dropdown, then choose one or more columns to format. You can apply the same format to all numeric columns at once. Adjust format settings using the intuitive controls: set decimal precision, choose thousand separator style, add a currency symbol, or switch to percentage or scientific notation. For conditional formatting, define value ranges and assign colors or font styles to each range. The Format Preview area shows a sample of how the selected column will change, using actual values from the table. When you are satisfied, click Apply to write the formatting to the page. To undo, click Revert Original and the table returns to its pre-formatting state.

REAL MECHANISM — WHY THIS WORKS

Most formatting tools rely on parsing table content as text and using regular expressions to detect and replace numeric patterns. This approach fails on formatted numbers, mixed content, and localized decimal separators. Number Formatter for Tables uses a different method: it retrieves the raw text content of each table cell, then applies a numerical extraction pipeline that handles thousands of locale-specific formats. The pipeline uses a deterministic finite automaton to tokenize cell content into number and non-number parts, preserving non-numeric text. It then validates extracted values against a set of heuristics that distinguish true numbers from phone numbers, dates, and product codes. Each cell retains a reference to its original value, enabling instant reversion. Formatting is injected as a mutation—the DOM is updated without disrupting event listeners or data bindings, because the tool uses direct property assignment rather than innerHTML replacement.

THE PANEL

The floating panel is fully draggable and remembers its position per site. It snaps to the edges of the viewport when dragged near them. You can collapse the panel to a small handle icon to minimize screen distraction, and expand it back with a click. The panel is resizable from the bottom-right corner, letting you see more format options or preview rows. Press the Escape key to close the panel instantly. The panel remains open across page navigation within the same domain, maintaining your current format settings.

PLEASE NOTE

Number Formatter for Tables requires the free BotGentz extension to be installed and enabled, as it relies on the cross-extension messaging API provided by BotGentz for table detection and DOM access permissions. Because websites change their structure frequently, table detection and column parsing scripts may require periodic updates. If a table is not detected correctly, please check for updates or report the issue. All data processing occurs entirely in your browser. No table data, numbers, or formatting preferences are ever sent to any server. The extension does not read or store any personal information. It only reads and modifies the DOM of the pages you choose to interact with.