xlsx lens

JetBrains Marketplaceplugin 33721free viewer, Pro subscription

XLSX Lens opens an Excel workbook in the editor tab of IntelliJ IDEA and the other JetBrains IDEs, streamed, and never writes to it. The first page renders while a 500,000-row sheet is still loading behind it. Every sheet is one click away, merged cells are rendered, a date cell is read by the date system the workbook declares, 1900 or 1904, and the built-in and the common custom number formats are applied. The workbook is neither locked nor recalculated. Pro writes a sheet out as CSV, JSONL, Markdown or Parquet and profiles its columns into a report. It also sorts and filters every row rather than the loaded page, diffs two workbooks sheet by sheet, shows the formulas grid-wide, and reloads the file when it changes on disk.

opens

.xlsx and .xlsm workbooks, a .xlsm as data with its macros never read; no legacy .xls, and .csv is never claimed

runs on

IntelliJ IDEA, PyCharm, WebStorm, Rider, GoLand, Android Studio and every IntelliJ-based IDE from 2024.2 on

store

JetBrains Marketplace, plugin 33721

newest version

1.4.0, published 2026-09-11

pro

a subscription with its own 30-day trial; the price is quoted below as the store shows it

Before a release ships we run it on IntelliJ IDEA Community 2024.2, IntelliJ IDEA Ultimate 2026.2 and Android Studio 2026.1.

price, as the store shows it

Pro is $2.90 a month or $29 a year for individual use, $5.80 or $58 for organizations. Each Lens plugin comes with its own free 30-day Pro trial. A subscription carries a perpetual fallback license: after 12 uninterrupted months, the version from the start of that subscription year, with its fixes, stays yours even if the subscription ends.

where it stops

• No editing and no cell writes of any kind
• No formula recalculation: cached results are shown
• No legacy .xls
• No font and color fidelity: values and layout, not print styling

what's new

• 1.4.0published 2026-09-11

  The column profile report, a second Pro export for the open sheet. Give the export a name ending .profile.html, .profile.md or .profile.json and the rows are profiled instead of copied: every column gets its row, null and empty counts and the kinds of cell it holds, a numeric column its min, max, mean, quartiles, a histogram and an outlier count, a text column its distinct count and most frequent values, a date or timestamp column its earliest and latest value and the largest gap in the series. The sheet as a whole gets an exact duplicate-row count and a correlation matrix over its numeric columns, forty at most. Wherever a figure came from a sample rather than every row, the report says so beside it. The HTML page opens in your browser from the finished balloon, the Markdown pastes into a ticket as it is, and the JSON keeps every number at full precision. Search matches and the current view profile the same way the whole sheet does, and a cancelled run leaves no file.

• 1.3.0published 2026-09-09

  Export to Parquet, a Pro action. Pick a .parquet name in the export dialog, where the filter reads CSV, JSONL, Markdown or Parquet, and the sheet, the search matches or the current view are written as one Parquet file, one column per sheet column, named by its letter. A column of numbers is written as numbers, and a column of dates as dates, or as timestamps when the cells carry a time, read by the date system the workbook declares, 1900 or 1904. Where a column mixes kinds, say a header row over numbers, the cells are written as the text the grid shows, so it reads the way the CSV would. The open workbook is refused as a destination, as it is for CSV, and a cancelled export leaves no file behind. When the export finishes, the balloon offers Open exported file, which lands in Parquet Lens when that is installed; with no viewer for it, the click says so and points at Parquet Lens instead. The Theme picker has four more themes, Duskhollow, Abyss, Obsidian and Moonlit Garden, and two entries at the end, lamplighter and catacombs, each with a padlock and its own line in the open list: "unlocks when you share Lens with a colleague" for lamplighter, "unlocks the first time Pro runs for you" for catacombs. Pick a locked one and the plugin opens the way to earn it. For lamplighter that is the share card, also under Help as Share XLSX Lens: plain text for a colleague, a marketplace line, a Lens family line and a referral code of this install's own. "Copy share card" earns the theme here, and a colleague who enters that code under Theme in any Lens plugin earns it there. An earned theme stays, whatever the license says. The four night themes follow the rule of the eight: trying one is free for the open window, keeping it is Pro.

• 1.2.2published 2026-09-08

  Reload and watch mode reopen the workbook on the sheet that was open; both used to land on the first sheet, with the selected row carried over to the wrong one. File | Open Workbook... opens an .xlsx or .xlsm from anywhere on disk in an XLSX Lens tab, attaching nothing to the project, and the same entry answers in Search Everywhere; it is free, like the rest of the viewer. Each sheet in the list shows its size as rows x columns once it has been read, and a sheet with nothing in it reads empty.

more

• every format, every product
• opening a large file
• the exports and the profile report
• support

Pricing, invoices and licensing questions go to [email protected]; anything else about the product to [email protected].