CSV File: View, Add Column Colors and Sort Data using Notepad++

preview_player
Показать описание
This tutorial will show you how to view CSV File (Comma Separated Values file), add column colors and also sort data by any columns using Notepad++. We will use Notepad++ TextFX plugin and CSV Lint Plugin.

CSV files can also be opened with Microsoft Excel, but it often forces users to save files as .xlsx files. CSV Data file does not need Excel to open, it can be opened in any text editor. It is easy to manipulate CSV files, sorting the columns using Notepad++.

[2022-11-08] Note from Bas, the creator of this Plugin:
The latest update of the CSV Lint plugin v0.4.6.2 now has a Sort feature. Meaning you can sort CSV files on a selected column. Note that integer, decimal and datetime values won't be sorted alphabetically, but they are sorted correctly according to their integer, decimal or datetime values.

🚩 TIMESTAMPS 🚩
00:00 Introduction
00:58 What is CSV File?
02:32 Add Syntax highlighting colors and column detection using CSV Lint plugin
05:22 Sort Columns in CSV file using Notepad++ TextFX plugin
07:00 Example 1: Sort CSV by Text (Last Name)
09:52 Example 2: Sort CSV by numbers (Price, Mileage)

#CSVFile #CSVFiles #CSVSortColumns

---

🚩 Checkout My other playlists 🚩

---
🚩 please LIKE or SUBSCRIBE.
🚩 Please COMMENT If You Like To See Any Video On Specific Topic

Music Credits:
––––––––––––––––––––––––––––––
Track: Our Leaves in the Breeze — Artificial.Music [Audio Library Release]
Music provided by Audio Library Plus
––––––––––––––––––––––––––––––
Рекомендации по теме
Комментарии
Автор

Hi Amit How do you increase column width in CSVLint Thanks great videos!

unitedstandardpos
Автор

CSV Lint is not highlighting the columns. It says the data validates and properly recognizes the columns, but no highlighting.

dezertson
Автор

Hola estuve intentado realizar los mismos pasos pero en la version que tengo no aparece el textFX Edit, existe alguna manera de hacer la alineacion sin usarlo?

ingenieriapaula
Автор

Hello, thank you for the content, been wondering where did you prepare such a neat leaf directory of the topics covered in the vid? Very neat and good visual support for what you are relating.

andreyzhuchkov
Автор

Hi Amit! Thank you for producing such useful videos. Would you mind sharing which mind mapping program you are using in this video?

jaimenash
Автор

Thank you. Something unfortunate for me:
1- I've installed the plugin, then exit the program and reload just to make sure;
2- Loading a Google contact CSV file shows the colors, however the columns are not aligned: empty fields are squeezed, and others are as large as their data for each record (line). It's a coma delimited file.
EDIT: same thing with an Outlook CSV file... I'll try to see with the creator (if it's possible in some manner)
EDIT2: I solved the problem: in the CSVLint window, I had to click the "Reformat" button, check "Align vertically" and then "Ok". All is good now! 🙂

HawkFest
Автор

Hi Amit, first of all thank you for your content! I wanted to ask you if you knew how to install TextFX, it seems modern versions of NotePad++ won't support it anymore. Thanks in advance.

samuelunbelievable
Автор

Manged to download Text FX 64 but upon editing lineup multiple lines I'm getting a pop up saying out of memory 😏

StephenBrincat
Автор

Hi Amit... do you have a recommendation for a TextFX replacement, apparently its not supported anymore and one can't install in the 64 bit version. I found the delimiter "line up" function super helpful. Any advice would be most helpful. thank you sir!

imezunv
Автор

Where are you getting TextFx, it doesn't exist in my latest version of Notepadd++. I just need to align columns using commas

robertminardi
Автор

My columns don't all line up. What do you do to get them in a straight column? I have windows 11 64bit and there is no TextFX for Notepad++ 64bit.

NealHartsChannel
Автор

Hi Amit! Nice video. I have a question. If I have a large file with 10k records, how do I select the column? For instance, using the Alt and mouse down the column would take forever, so how would you do it?

rbdenham
welcome to shbcf.ru