Tutorials

Convert Text File (TXT) to CSV Using Python 3 Pandas Script

This tutorial will teach you how to convert a Text (.txt) file to CSV using the pandas library in Python. I’ll give you the complete source code of this application so you could easily test it out on your PC.

Let’s get started by installing the pandas library using the pip command.

pip install pandas

Now create a new Python file for this project and name it as code.py. After that, copy the below-given code-snippet and paste it in code.py.

code.py

# importing pandas library
import pandas as pd

# reading given csv from .txt file
# and creating dataframe
dataframe = pd.read_csv("file.txt", delimiter = ',')
  
# storing this dataframe in a csv file
dataframe.to_csv('new_file.csv', index = None)

According to our code, we need to provide a file.txt that contains our data. By default, commas will be used as delimiters, but you can easily change them to whatever character you like.

So, let’s create a file.txt in the root folder of your project and add some comma-separated values. For example, have a look at this file.

file.txt

ID, Name, Score
1, Furqan, 100
2, Ibrar, 95
3, Ammar, 87
4, Sheraz, 90
5, Babur, 65

Run Python Convert TXT to CSV Project

python code.py

The Output of Python TXT to CSV

A file named new_file.csv will be generated automatically in your project’s root folder.

Here’s a screenshot of that file:

Furqan

Well. I've been working for the past three years as a web designer and developer. I have successfully created websites for small to medium sized companies as part of my freelance career. During that time I've also completed my bachelor's in Information Technology.

Recent Posts

MiniMax-M1 vs GPT-4o vs Claude 3 Opus vs LLaMA 3 Benchmarks

MiniMax-M1 is a new open-weight large language model (456 B parameters, ~46 B active) built with hybrid…

June 22, 2025

How to Use Husky with npm to Manage Git Hooks

Managing Git hooks manually can quickly become tedious and error-prone—especially in fast-moving JavaScript or Node.js…

June 22, 2025

How to Use Lefthook with npm to Manage Git Hooks

Git hooks help teams enforce code quality by automating checks at key stages like commits…

June 22, 2025

Lefthook vs Husky: Which Git Hooks Tool is Better? [2025]

Choosing the right Git hooks manager directly impacts code quality, developer experience, and CI/CD performance.…

June 22, 2025

Llama 3.1 vs GPT-4 Benchmarks

We evaluated the performance of Llama 3.1 vs GPT-4 models on over 150 benchmark datasets…

July 24, 2024

Transforming Manufacturing with Industrial IoT Solutions and Machine Learning

The manufacturing industry is undergoing a significant transformation with the advent of Industrial IoT Solutions.…

July 6, 2024