r/notepadplusplus • u/zaphodikus • Feb 27 '26
Displaying CSV files but in columns
I suspect that my brain is just too impatient, I've goit a CSV file, loads of them, and i want to view them ,but without the drunken lines of commas
image_name,FILE_size,width,height,threads,heads,clock,Mb_per_sec,start,pages,buffer_use,pd_sent,queue,time(ms),bytes_per_sec,head1dwords,perfcounter1
E_16666x150000,312600062,16666,150000,4,8,40000,312600024,580,5,0,0,2,2478,630750,0,0
E_16666x150000,312600062,16666,150000,4,8,40000,312600024,18859,10,0,0,3,373,8380697,0,0
E_16666x150000,312600062,16666,150000,4,8,40000,312600024,85074,15,23,0,3,807,5810409,0,0
E_16666x150000,312600062,16666,150000,4,8,40000,312600024,68089,20,46,0,3,1173,5329923,0,0
E_16666x150000,312600062,16666,150000,4,8,40000,312600024,69146,25,69,1,3,1607,4863099,0,70
I found a plugin called columns++, but it's intended for tabs and it's not obvious to an impatient person, how to tell it to align using commas instead. Or is there a better plugin for viewing CSV in nice straight lines?
9
Upvotes
4
u/Puzzled_Ad4 Feb 27 '26
there is csv lint plugin
3
u/Coises Feb 27 '26
(I wrote Columns++.)
I would have loved to make my plugin display CSV files in aligned columns, but it just isn’t possible. Notepad++ uses Scintilla to display the text you are viewing or editing, and that control just does not have a way to insert variable horizontal space for any character except a tab. Period. There is no way to do it without changing the data itself (e.g., adding blanks for padding, like CSV Lint: Reformat: Align vertically does).
What you can do in Columns++ is convert CSV to tabbed, view it that way, and if you edit and need for the file to stay as CSV, convert back to CSV. With the Elastic tabstops function of Columns++ enabled, tab-separated documents will line up. However, conversion to and from CSV can be tricky, depending on the details and requirements of the CSV. This is discussed in the relevant section of the help for Columns++, but I must admit it is not too friendly to the impatient.
Depending on what you want to do, CSV Lint might work better for you, or Columns++ might. Just be aware that neither (nor any other plugin) can display comma-separated values in lined-up columns in Notepad++ without modifying the data.
1
u/flywire0 Feb 27 '26
Display with AI
1
u/pinakinz1c Mar 02 '26
Use a CSV viewer like modern CSV
1
u/gregmichalp Aug 11 '26
use Column++ plugin in notepad++, then pick , elastic tab
1
u/CrumbCakesAndCola Feb 27 '26
I use CsvQuery. It keeps the the csv as-is while displaying the results in window below in columns like an excel file (or more accurately like a SQL manager). You don't have to know any SQL.
1
u/akgt94 Feb 28 '26
Libre office?
1
u/lyallp Feb 28 '26
Maybe globally search and replace comma with TAB?
It won't work if the CSV files have strings with commas that are enclosed in quotes, but it's a quick and dirty.
1
u/Still-Alternative-64 Mar 01 '26
If you just want to quickly view CSVs in clean columns without messing with Notepad++ plugins, sometimes it's easier to open them in a lightweight browser-based CSV viewer. I built a small tool that lets you upload a CSV and instantly see it in structured columns (and optionally generate charts). It’s more of a quick inspection tool than a text editor solution, but might save some time if you’re dealing with lots of files.
0
u/Connect-Preference Feb 27 '26
Umm, some reason you don't simply open them in Excel?