№ 001

PasteNinja

Cleans and reformats clipboard data for SQL, Power Query, NAV, and Excel.

v2.81 Windows 10+ Released 2026-05
PasteNinja screenshot

About

PasteNinja takes messy clipboard content and reformats it into something a query or data tool can actually use. Paste in a column of values, choose a separator, optionally strip duplicates and sort, then copy the result straight back to the clipboard. Useful when moving data between Excel, SQL, Business Central (NAV), or Power Query.

The window remembers its position across sessions and can be pinned to a corner of either monitor. A history tab keeps recent results, and processed outputs can be saved to a log for later reference. Settings are written to a local JSON file — nothing goes anywhere else.

What it does

  • Remove duplicate values from pasted input
  • Sort entries alphabetically before output
  • Choose output separator: tab, newline, pipe, semicolon, colon, or custom
  • Copy formatted result to clipboard automatically
  • Remember window position per monitor and corner

Requirements

Windows 10+, 64-bit. No Python installation required for the .exe — everything is bundled via PyInstaller.

Verify the download

Before running the executable, compare its SHA-256 hash to the one below.

SHA-256 7b25710186803e3e58d93be2e9295a3f97d413c7b7e5831cb7f1864e52b1812f

In PowerShell, from the folder where you saved the file:

Get-FileHash .\pasteninja-v2.81.zip -Algorithm SHA256

If the output matches the hash above, the file is intact. If not, delete it and re-download.

Build it yourself

The source .zip contains everything needed to rebuild the executable from scratch:

  • pasteninja.py — the full source.
  • requirements.txt — pinned Python dependencies.
  • build.bat — installs deps into a local venv and runs PyInstaller.
  • README.md — build and usage notes.

With Python 3.12 installed, unzip and run:

build.bat

Known limitations

Windows only; requires a Python environment with the listed dependencies — no standalone executable is included.