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

6 min read

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. 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.

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 on the Microsoft Store as well as the Mac App Store. The macOS version is the reference surface and gets new features first — 6.0.0 in particular is a macOS-native release, with the Liquid Glass refresh and dark-mode propagation being very much Apple-specific. On Windows the import/analyze/export core is there, but not all macOS niceties are mirrored yet. If you want the full experience described above, the Mac build is where it lives today.

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.

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