Thanks for sharing more about your spreadsheet and workflow. It clears up a lot of my confusion.
I now understand that your Excel ledger uses multiple rows to hold the information in a multiple line hledger plain text transaction. Posting information has its own columns.
I agree that it is difficult to track lot info in hledger and then do FIFO analysis. I’m not sure what the best workaround is.
As far as using the CSV import functionality in hledger, it is strictly one csv line generates one transaction. Simon did discuss it in another thread where he said that was a design decision to avoid making it too complex.
I think Simon uses the Emacs text editor to manipulate his journal files. Emacs is programmable in LISP much as Excel is programmable in VBA.