3

I'm looking for a software (not an online tool) that can transpose large CSV files. I found this answer, but the proposed tool can't handle my file. I also heard about EmEditor, which can handle large files and has CSV capabilities, but at least I couldn't find the "Transpose" feature.

My OS is Windows, but I'm happy with any GUI or command line tool that does the task.

  • Because your file is small enough, Excel works. But I'm curious which "proposed tool" you are talking about which can't handle your file. The one answer to the linked question mentions pyspread, and it easily handles many, many, many more columns than what you have. – John Y Jun 8 '18 at 18:09
2

Microsoft Excel will do this for you. It has a special paste option called 'Transpose':

enter image description here

It supports up to 16,384 columns so this should work for your CSV file; just copy the content and Paste Transpose it in another workbook or sheet.

It's an online solution, but Google Sheets has the same option, and I expect other spreadsheet tools do too:

enter image description here

  • I should have tried this...Thanks. – Stefan Berger Jun 8 '18 at 9:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.