In this post, we will see how to resolve Convert txt python dictionary file to csv data file?
Question:
I have a text file with 300,000 records. A sample is below:
I tried the following, but it does not put any line breaks between the records. So in excel, the 300,000 records are in two rows, which doesn’t fit everything (16,000 column limit in Excel).
Best Answer:
You can try:If you have better answer, please add a comment about this, thank you!
Source: Stackoverflow.com