How to view column-aligned CSV files in Visual Studio editor
You can install csv-viewer extensions by searching for them in the search tool in the VSCode "Extensions" menu.
Some good ones are 'Excel Viewer' by GrapeCity, or 'Edit csv' by janisdd.
Both of these (and many more) allow you to view excel files in columns inside VScode, not just text files as is default.
kmote
I graduated from Washington State University in Computer Science (undergrad + masters). I've spent over 10 years in software development for a National Laboratory, a startup engineering company, and a nuclear processing plant. This has provided me with a diverse set of experiences and skills. I have worked extensively in such technologies as C++ (w/ MFC, STL, & Boost), C#, Python, and Qt. I'm also quite familiar with VB.Net, HTML/XML, SQL, Java, and Open Inventor as well as tools like Visual Studio, JIRA, and Subversion. I have a strong background in mathematics & graphics and have delved into graph & network theory, information visualization, data analytics, SCADA/HMIs, and artificial intelligence. I'm a Windows expert with Linux/Mac experience. Also, I'm not quite as old as I look. http://kevinmote.wordpress.com http://www.linkedin.com/in/kevinmote
Updated on June 14, 2022Comments
-
kmote almost 2 years
Opening a .csv file in Visual Studio produces an unreadable jumbled mess. Is there any way to set up Visual Studio to automatically format these files in columns (a "grid-view", so to speak) so I can edit them directly in the IDE? Are there any tricks or workarounds or extensions that could make these files more easily readable?
(VSCode has what looks to be a fantastic extension for this sort of thing, but alas, it won't work in Visual Studio Pro/Enterprise. Also, BeyondCompare4 does this automatically, and Notepad++ has the TextFX plugin which supports this as well. Has no one ever produced such a plugin for VS?)
(UPDATE: I have created a feature request here. Please vote for it if you upvote this ticket.)
-
kmote about 4 yearsUnfortunately, as I mentioned in my post, the VSCode extensions don't work in VS Pro. :(
-
NicoWheat about 4 yearsOh, sorry :( I came back at a later date to answer this and didn't remember you said VS Pro. Hopefully people who are looking for this (who don't have VS pro) can be helped. If not, I can delete the answer.
-
Dimitry K over 3 yearsWith VSCode "Excel Viewer" works nice with csv files. (If you have tab-delimited file, extension should be .tsv for the 'Excel Viewer' correctly assume delimiter).
-
greendino over 3 yearsI've used that for weeks let me tell you. it's not good. you cant search the data properly. and it's risky if u didn't aware of it
-
Arnab Biswas about 3 yearsI prefer "Edit csv" since I can edit. Also the interface uses larger fonts and borders, making it more usable (at least for me).