In CSV files (especially ones with a lot of columns and/or a lot of rows) I find that it's hard to tell which column I'm on. Normally I'd like to know either the column heading, or sometimes the column index (usually I want the index only if there are no headings). I know about
csv-align-fields, which helps, but:
- The heading names are not visible when you scroll down
- Even with two windows displaying the CSV buffer (one scrolled to the top always), it takes mental effort to figure out which column you are on, and it is inconvenient to set up that window configuration for each CSV file you visit.
I can already just create two windows, but that is a bit tedious and does not solve problem 2.
I guess ideally I'd want something like
which-function-mode but showing the current CSV heading name and index, AND also have headers always visible at the top of the frame or window by some means?
Short of that, I think this could be solved by some way to apply a saved window configuration to a buffer? Then I could have one very short window at the top of the frame, scrolled to the top so that the headings are visible, and another window at the bottom displaying the same buffer for viewing/editing the bulk of the CSV. Note that all the window configuration tools I've come across save the buffers together with the window configuration, but here I want a particular set of windows & their sizes to be restored and then have both windows display the same buffer.