CSV Viewer/Editor - Searching CSV like Everything Search
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
CSV Viewer/Editor - Searching CSV like Everything Search
I'm looking for a tool can search CSV files the same way like Everything Search does, Search is filtering the lines in the table.
Suppose you have a Contacts or a Library data base, and you want to find/view fast the desired info in the data base.
Suppose you have a Contacts or a Library data base, and you want to find/view fast the desired info in the data base.
-
- Posts: 109
- Joined: Wed Jun 12, 2013 10:43 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Just a single .csv file?
Try Notepad++ (even better with the Search+ plugin), any spreadsheet program (EXCEL, LibreOffice, etc), or just plain Notepad or Wordpad
Try Notepad++ (even better with the Search+ plugin), any spreadsheet program (EXCEL, LibreOffice, etc), or just plain Notepad or Wordpad
-
- Posts: 258
- Joined: Tue Jun 17, 2014 10:52 am
Re: CSV Viewer/Editor - Searching CSV like Everything Search
You can also use CSVFileView from Nirsoft - only read... or CSVed: http://csved.sjfrancke.nl/
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Thank you.
I couldn't find the feature I was looking for but only in CSVFileView from Nirsoft (it's called there Quick Filter - Ctrl+Q).
This feature is good, and behaves like Everything, but I think CSVFileView still not enough good. Everything looks much better and has more features. the problem is that Everything designed for search files and not text of database.
The idea started from a library PC supposed to let the library users to search books from a database of books of the library.
Everything style ("Quick Filter") looks to me much better for use by many users, than Excel search dialog-box.
Yes. Support for more kinds of database files, is better of course.Just a single .csv file?
I couldn't find the feature I was looking for but only in CSVFileView from Nirsoft (it's called there Quick Filter - Ctrl+Q).
This feature is good, and behaves like Everything, but I think CSVFileView still not enough good. Everything looks much better and has more features. the problem is that Everything designed for search files and not text of database.
The idea started from a library PC supposed to let the library users to search books from a database of books of the library.
Everything style ("Quick Filter") looks to me much better for use by many users, than Excel search dialog-box.
-
- Posts: 258
- Joined: Tue Jun 17, 2014 10:52 am
Re: CSV Viewer/Editor - Searching CSV like Everything Search
And you checked CSVed is an advanced editor .csv files.
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
@salazor
I've checked CSVed but not much. It's looked indeed as advanced tool. Maybe too advanced for the goal I looked for.
I think I didn't find there "Quick Filter" feature and also I had trouble to display Unicode characters correctly.
I've checked CSVed but not much. It's looked indeed as advanced tool. Maybe too advanced for the goal I looked for.
I think I didn't find there "Quick Filter" feature and also I had trouble to display Unicode characters correctly.
-
- Posts: 8
- Joined: Wed Jan 18, 2017 10:18 am
Re: CSV Viewer/Editor - Searching CSV like Everything Search
This question is a bit offtopic for everything, but i recommend Logparser (https://technet.microsoft.com/en-us/scr ... 19274.aspx). It has SQL-like access too.
-
- Posts: 1063
- Joined: Wed May 24, 2017 9:22 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Saw this on the AutoHotKey forum and remembered your question.
Sources are no longer available there (due to a hack, it seems), but can be found here.
Seems to do what you want. And if not: you can finetune the AHK code to your liking ..
BTW: I recommend Logparser too (handy tool; not only for logs, but most structured data), but maybe not specific for this purpose.
Sources are no longer available there (due to a hack, it seems), but can be found here.
Seems to do what you want. And if not: you can finetune the AHK code to your liking ..

BTW: I recommend Logparser too (handy tool; not only for logs, but most structured data), but maybe not specific for this purpose.
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Thanks. I tested it a littleNotNull wrote:Saw this on the AutoHotKey forum and remembered your question..
CSV Quick Filter (CSVQF) also seems it has a way to do till it will reach Everything GUI features and performance.
I can't see a GUI here.BTW: I recommend Logparser too (handy tool; not only for logs, but most structured data),
Maybe it would be better to find a Spreadsheet Program with this Quick Filter (Filter-As-You-Type) feature.but maybe not specific for this purpose.
-
- Posts: 133
- Joined: Thu Jul 13, 2017 9:14 am
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Yes. Looks like the commercial version of EmEditor has a Quick Filter with a good GUI features and performance.
Note for RTL users
Note for RTL users
EmEditor Support wrote:EmEditor curently doesn’t support RTL documents.
-
- Posts: 1063
- Joined: Wed May 24, 2017 9:22 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Another alternative:
In powershell, issue this command:
and take a closer look at all the interface elements
I think it will supprort RTL
type for more configuration options (or ask here
)
EDIT: There are rather big improvements in Out-GridView with newer PS versions. Depending on what Windows verso=ion you will run this, you get extra options.
In powershell, issue this command:
Code: Select all
Import-Csv c:\path\to\your.csv | Out-GridView
I think it will supprort RTL
type
help ogv

EDIT: There are rather big improvements in Out-GridView with newer PS versions. Depending on what Windows verso=ion you will run this, you get extra options.
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
My experience with Powershell is very low. I remember I need to make changes with the policy or something like that. I'm using W7 x64.
Before going further with this, can you find a video (YouTube) or screenshot that describes what you saw?
Before going further with this, can you find a video (YouTube) or screenshot that describes what you saw?
-
- Posts: 1063
- Joined: Wed May 24, 2017 9:22 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Those execution policies (you remembered correctly
) are for running .PS1 scripts.
In this case you can do without those policies:
- Run Powershell.exe
- Enter command
And there you go!
Import-csv has several options for importing ASCII, UTF8, etc layouts so things may not look perfect this 'first round'.
Just to give you an idea ..
I *did* create a snapshot to make it more clear, but was not allowed tro post it.
A video ? You're asking a lot from a command-line guy
But I'll see what I can do for you ...

In this case you can do without those policies:
- Run Powershell.exe
- Enter command
Import-csv c:\path\to\your.csv | Out-GridView
And there you go!
Import-csv has several options for importing ASCII, UTF8, etc layouts so things may not look perfect this 'first round'.
Just to give you an idea ..
I *did* create a snapshot to make it more clear, but was not allowed tro post it.
A video ? You're asking a lot from a command-line guy

-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
I managed to run it. Here's how it looks on my side:
https://snag.gy/9axf24.jpg
I didn't asked to record a video, just to try to find prepared one ...
https://snag.gy/9axf24.jpg
I didn't asked to record a video, just to try to find prepared one ...
-
- Posts: 1063
- Joined: Wed May 24, 2017 9:22 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
Ah, OK; missed that one ...
Still not in the neigbourhood of a Win7 machine. As an alternative:
1. Different input file
Try it with
Get-process | select * | out-gridview
Input (file) itself is less Important here; focus on the Filter bar and the "Add criteria" button and the search options tht hide behind it.
2. Different encoding
When importing your csv, you can use different encodings. On Win10 (PowerShell 5.1), those are:
- Unicode
- UTF7
- UTF8
- ASCII
- UTF32
- BigEndian
- Unicode
- Default
- OEM
help import-csv
For example: try
Import-csv -Encoding Default "c:\path to \your.csv" | Out-GridView
HTH ..
-
- Posts: 679
- Joined: Sat Aug 31, 2013 9:05 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
On W7 I couldn't find encoding options and didn't work.
But I tested it on a W10 VM, and it worked.
https://snag.gy/J3s6r5.jpg
I like:
The default search applies on all columns.
The advanced search (Add criteria).
Search RTL Text works.
I dislike:
There is no highlighting of the search in results.
I couldn't flip the view, to get RTL layout.
Thank You.
Import-csv -Encoding Default "c:\path to \your.csv" | Out-GridView
But I tested it on a W10 VM, and it worked.
https://snag.gy/J3s6r5.jpg
I like:
The default search applies on all columns.
The advanced search (Add criteria).
Search RTL Text works.
I dislike:
There is no highlighting of the search in results.
I couldn't flip the view, to get RTL layout.
Thank You.
-
- Posts: 1063
- Joined: Wed May 24, 2017 9:22 pm
Re: CSV Viewer/Editor - Searching CSV like Everything Search
You're welcome!
Whenever the next suitable CSV viewer appears on my radar, I'll post it.
Whenever the next suitable CSV viewer appears on my radar, I'll post it.