notepad ++ formatting data into actual table/columns

Question

I have this table which is basically a line of explanation headers and then separate lines with a bunch of numbers and such corresponding to those headers, each separated by a single tab on their line. This causes the whole thing to look like one big jumbled mess, and none of the numbers line up with the headers at the top. I am trying to find some way to get it to all line up so that it's readable like a normal table. Hope this is an actually fixable problem.

Answer 1

I come across this alot myself when I want to have a Table made into a Text which is readable. I did find a website that worked pretty well (https://www.tablesgenerator.com/text_tables); inspite of the fact that I reallly want to do this easily in Notepad++. I tried the Notepad++ TextFX plugin from answer by Terel TextFX --> TextFX Edit --> Line up multiple lines by (Clipboard Character), but that did not work like I was expecting.

ORIGINAL (input)

I have a table like this in Excel...

... and I copy it to Notepad it looks like this...

Sheet   Range   Old Value   New Value   Description
z_PublicConstants               Module Procedure: btnSubmit_ModelParamDate Deleted.
z_PublicConstants               Module Procedure: ResultSet_ModelParamDate Deleted.
ThisWorkbook                Module Procedure: Workbook_Open Changed.
z_PublicConstants               Module Procedure: OpenConnection_ProductionPlanning Changed.
z_PublicConstants               Module Procedure: btnResultSet_SynchronizeAll Changed.

FORMATTED (output)

What I think you want it for it be a textual format that is readable in table format. This was created with Tables Generator website link I provided.

+-------------------+-------+-----------+-----------+--------------------------------------------------------------+
| Sheet             | Range | Old Value | New Value | Description                                                  |
+-------------------+-------+-----------+-----------+--------------------------------------------------------------+
| z_PublicConstants |       |           |           | Module Procedure: btnSubmit_ModelParamDate Deleted.          |
+-------------------+-------+-----------+-----------+--------------------------------------------------------------+
| z_PublicConstants |       |           |           | Module Procedure: ResultSet_ModelParamDate Deleted.          |
+-------------------+-------+-----------+-----------+--------------------------------------------------------------+
| ThisWorkbook      |       |           |           | Module Procedure: Workbook_Open Changed.                     |
+-------------------+-------+-----------+-----------+--------------------------------------------------------------+
| z_PublicConstants |       |           |           | Module Procedure: OpenConnection_ProductionPlanning Changed. |
+-------------------+-------+-----------+-----------+--------------------------------------------------------------+
| z_PublicConstants |       |           |           | Module Procedure: btnResultSet_SynchronizeAll Changed.       |
+-------------------+-------+-----------+-----------+--------------------------------------------------------------+

Notepad++ TextFX plugin from answer by Terel TextFX --> TextFX Edit --> Line up multiple lines by (Clipboard Character) did not work, it just removed the TAB characters, like this...

Sheet Range Old Value New Value Description
z_PublicConstants    Module Procedure: btnSubmit_ModelParamDate Deleted.
z_PublicConstants    Module Procedure: ResultSet_ModelParamDate Deleted.
ThisWorkbook    Module Procedure: Workbook_Open Changed.
z_PublicConstants    Module Procedure: OpenConnection_ProductionPlanning Changed.
z_PublicConstants    Module Procedure: btnResultSet_SynchronizeAll Changed.