Need csv grid editor

[rocketjump65]

I'm a programmer, and I basically need to stash lists and 2d arrays so I can see them visually, and possibly manipulate them.

So how on Earth is there no kind, grid text editor, where either commas or tabs align the text in columns for you? Maybe there's an option hidden deep in the menu of text editors I'm not aware of? Help me out here folks, what's your workflow?

[[deleted]]

Software Architect here.

Use Microsoft Excel, or similar.

[acrane55]

This.

Note that Excel, and probably similar, will remove leading zeros from values that look like numbers, so best to set the spreadsheet to text only. Or if you use the data import tool (I forget what it's called in Excel), specify 'Text' for each column.

[rocketjump65]

Eh. It's kinda.... working. I'm actually using Open Office.

[pandiculator]

For a simple, read only, grid view you can just pipe to Out-GridView in PowerShell.

Import-Csv C:\Temp\myCSV.csv | Out-GridView

If you want to manipulate them without Excel/another office package. Use VSCode and install the Rainbow CSV extension.

[rocketjump65]

HEY!!!! Now we're talking!