Parqet X-Ray CSV: What to Do With It (Pecuniator 6.0.0)

Pecuniator 6.0.0 shipped on 19 April 2026 — and if you are one of the many parqet.com users who has ever exported your X-Ray data as CSV and then wondered what am I actually supposed to do with this file?, this release is the answer. It is a full macOS 26 modernization of the offline X-Ray analyzer, and it is built around a single, specific workflow: take the CSV parqet gives you, turn it into a real portfolio breakdown, keep everything on your own machine.

This post is for the parqet users who never find tools like this through a search engine because the vocabulary does not line up. You search for parqet X-Ray CSV auswerten or parqet Länderaufschlüsselung offline and find very little. So let’s spell it out.

What parqet’s X-Ray export actually gives you

Parqet’s X-Ray view is one of its best features. It looks through your funds and ETFs to show the underlying positions, so what appears as “one world ETF” is broken down into the hundreds of individual stocks inside it. The export button on that view produces a CSV file — usually with a semicolon separator, a header row, and columns for the position ID (the ISIN), the holding name, the share count, and the current value.

So far, so good. The CSV is complete and structured. What it does not contain, by design, is:

• whether each position is a bond or a stock or something else
• the country of registration in a form you can filter on
• any enrichment like logos or additional identifiers
• any way to filter, pivot, or search — it is a flat file

You can of course open it in Excel and build all of that yourself — and if you are on a Mac, converting the CSV to Excel takes only a few steps. A lot of parqet users do. But every time you export a fresh snapshot, you redo the work. This is the gap Pecuniator 6.0.0 fills.

What 6.0.0 does the moment you drop the CSV on the app

There are four things that happen automatically, without any setup, without any API key, and without any network call:

1. Every ISIN is classified as bond, stock, or other

Pecuniator ships with a built-in reference database of over 804,000 EU-listed instruments, sourced from ESMA FIRDS and cross-referenced with GLEIF issuer data. When you import the CSV, each ISIN is looked up locally and the Type column is populated automatically. This is the single column parqet’s X-Ray CSV does not give you, and it is the one most people actually want.

If the database gets a classification wrong, you click the Type cell, pick the right value, and the correction is remembered. In 6.0.0 those manual corrections now round-trip through the pecuniator file format — so when you re-import next month’s parqet export, your edits survive.

2. The three-way filter parqet X-Ray does not have

Once the Type column is populated, the toolbar, menu bar, and sidebar all expose the same three-way switch: All / Bonds only / Stocks only. This is the view parqet’s own X-Ray does not offer, and it is surprisingly useful — especially for tax-year bond-coupon review, or for anyone running a core-satellite strategy and wanting to see only the satellite sleeve.

3. Country and region visualization from the ISIN prefix

Every ISIN’s first two characters are a country code. Pecuniator decodes all of them and builds a sidebar tree: region → subregion → country → positions. Click any level and the main view filters to just that slice. You immediately see things parqet’s aggregate breakdown does not surface in the same way — for example, how much of your “Irish exposure” is actually Irish-domiciled ETFs invested globally (ISINs starting with IE), versus truly Irish operating companies.

In 6.0.0 the sidebar has a dedicated country search field separate from the global ⌘F: type spain or ES and the tree filters live. Collapse-All and Expand-All controls sit in the sidebar footer so you can reset the view in one click.

4. Nothing leaves your machine

Core analysis — import, ISIN decoding, bond/stock classification, country rollup, filtering, sorting, Excel export — never touches the network. Your portfolio composition, including exact values, stays on your computer. This is a deliberate architecture choice, not an afterthought: Pecuniator does not ask you to create an account, does not phone home, and ships the 804k-row reference database inside the app bundle for exactly this reason.

Optional layers if you want them

For people who want more, there are two opt-in modules:

• OpenFIGI enrichment — bring your own free API key and Pecuniator will look up instruments from markets outside the ESMA corpus (Korean, Taiwanese, Indian, US listings). Off by default.
• Company logos via elbstream.com — small, tasteful icons next to each position, cached locally, with smart content-hash placeholder detection so generic “unknown ISIN” icons never land in your cache. 6.0.0 adds automatic re-check of previously missing logos on every import, so newly added ones appear on their own. Off by default, enabled in Settings → Logos, with attribution wherever the logos are shown.

Both modules are strictly opt-in, both are gated behind a clear toggle, and both can be turned off at any time without losing your portfolio data.

Excel export — the boring feature everyone needs

When you are done analyzing, one click exports the current view — filters and all — to XLSX. That is usually the format your accountant, your financial advisor, or your tax software expects. You get a clean spreadsheet with country codes already resolved and Type already classified, instead of the flat CSV parqet hands you. Before you run that export it also makes sense to back up your parqet portfolio so your snapshot and the underlying data stay in sync.

What else is new in 6.0.0 on the surface

If you already used Pecuniator before 6.0.0, the visible changes you will notice first are:

• A native macOS 26 Liquid Glass visual refresh — gradients and layered materials replaced with the real system glass effect, so cards in the import overlay, form panes, and the rewritten About view pick up proper edge lensing.
• A rewritten About view with app icon, version, tagline, and five icon-led sections (acknowledgments, disclaimer, data sources, affiliation, developer).
• Dark mode now carries through every auxiliary window — Settings, About, Help — and through the macOS file open/save panels, so there are no more light sheets flashing in a dark UI.
• A rewritten Help view that actually reflects the 6.0.0 surface area.
• Retired-ISO-code flag fallback so the few older country codes (Netherlands Antilles, Yugoslavia, Soviet Union, Zaire, East Timor, Burma) now show a sensible flag instead of a dotted-letter box.

A note on Windows

Pecuniator is fully available on both the Microsoft Store and the Mac App Store, and the complete workflow described above — import, ISIN classification, the bond/stock filter, the country and region rollup, and Excel export — works the same on Windows as on macOS. The main platform-specific difference is look and feel: the macOS 26 Liquid Glass refresh is an Apple technology, so the Windows build keeps its own native styling. Functionally, you get the same offline X-Ray analysis on either platform.

The practical workflow

1. In parqet, open your portfolio’s X-Ray view and export the CSV.
2. Drag the CSV file onto Pecuniator (or use ⌘O).
3. Review the Type column, the country/region sidebar, and filter to All / Bonds / Stocks as needed. Correct anything the database got wrong — it will remember.
4. Hit Export to get an XLSX with everything resolved, ready for Excel, Numbers, or your advisor.

That is the whole loop. It takes about fifteen seconds after the first time you set it up, and it gives you a view of your parqet portfolio that the X-Ray view itself does not provide. For a deeper dive into what you can do with your portfolio data once it is offline, see how to analyze your Parqet portfolio offline with X-Ray data. And if you check your positions on the go, the Parqet Apple Watch complications are a good complement to the desktop workflow described here.

Pecuniator 6.0.0 is available today on the Mac App Store and the Microsoft Store.