<div>
try this 
 

<pre><code class="code-10 nolinks" id="code-20-42057071-1">&gt;&gt;&gt; data = []
&gt;&gt;&gt; with open(&quot;data.txt&quot;) as f:
... for line in f:
... data.append([word for word in line.split(&quot; &quot;) if word])
...
&gt;&gt;&gt; print data
[['nothing doing', 'nothing[0]', 'doing[0]\n'], ['hello world', 'hello[0]', 'world[2]']]
&gt;&gt;&gt;
&gt;&gt;&gt; import xlwt
&gt;&gt;&gt; wb = xlwt.Workbook()
&gt;&gt;&gt; sheet = wb.add_sheet(&quot;New Sheet&quot;)
&gt;&gt;&gt; for row_index in range(len(data)):
... for col_index in range(len(data[row_index])):
... sheet.write(row_index, col_index, data[row_index][col_index])
&gt;&gt;&gt;
&gt;&gt;&gt; wb.save(&quot;newSheet.xls&quot;)
&gt;&gt;&gt;
</code></pre>
</div>

newSheet.xls

test.py

test.txt

<div>
Required output is achieved with this code modification and added extra features. Thanks
</div>

<div>
<div class="content wysiwyg-content">
Hi All, 
 
I have an requirement to convert/extract the contents from the text file into excel file using python script. 
input text file format... 

<pre><code class="code-10 nolinks" id="code-10-29010452-1">1
00:00:04,195 --&gt; 00:00:06,140
This text needs to be extracted.

2
00:00:04,195 --&gt; 00:00:06,140
This text needs to be extracted.

3
00:00:04,195 --&gt; 00:00:06,140
This text needs to be extracted.

.....
</code></pre>
 
and the output excel file format... 

<pre><code class="code-1 nolinks" id="code-10-29010452-2">Column1 Column2
This text needs to be extracted. This text needs to be extracted.
This text needs to be extracted. This text needs to be extracted.
This text needs to be extracted. This text needs to be extracted.
</code></pre>
 
Can you please suggest the reference or sample code for this. 
 
Thanks, 
Shail
</div>
</div>

Hi All,

I have an requirement to convert/extract the contents from the text file into excel file using python script.
input text file format...
(CODE)

and the output excel file format...
(CODE)

Can you please suggest the reference or sample code for this.

Thanks,
Shail

Text file to excel conversion using python

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.