Convert Text File to CSV using Python (example included)

You may use the following approach in order to convert a text file to a CSV file using Python:

import pandas as pd

read_file = pd.read_csv (r'Path where the Text file is stored\File name.txt')
read_file.to_csv (r'Path where the CSV will be saved\File name.csv', index=None)

In the next section, you’ll see the complete steps to convert your text file to CSV.

Steps to Convert a Text File to CSV using Python

Step 1: Install the Pandas package

If you haven’t already done so, install the Pandas package. You may use the following command to install the Pandas package under Windows:

pip install pandas

Step 2: Capture the path where your text file is stored

Next, capture the path where the text file is stored on your computer.

Here is an example of a path where a text file (called ‘Product_List’) is stored:

C:\Users\Ron\Desktop\Test\Product_List.txt

Step 3: Specify the path where the new CSV file will be saved

Now, you’ll need to specify the path where the new CSV file will be saved. For example:

C:\Users\Ron\Desktop\Test\New_Products.csv

Step 4: Convert the text file to CSV using Python

Finally, you may use the template below in order to facilitate the conversion of your text file to CSV:

import pandas as pd

read_file = pd.read_csv (r'Path where the Text file is stored\File name.txt')
read_file.to_csv (r'Path where the CSV will be saved\File name.csv', index=None)

For our example:

  • The path where the text file is stored is: C:\Users\Ron\Desktop\Test\Product_List.txt
    • Where the file name is Product_List and the file extension is txt
  • The path where the CSV will be saved is: C:\Users\Ron\Desktop\Test\New_Products.csv
    • Where the new file name to be created is New_Products and the file extension is csv

So this is the complete code to convert the text file to CSV for our example (note that you’ll need to modify the paths to reflect the location where the files are stored on your computer):

import pandas as pd

read_file = pd.read_csv (r'C:\Users\Ron\Desktop\Test\Product_List.txt')
read_file.to_csv (r'C:\Users\Ron\Desktop\Test\New_Products.csv', index=None)

Once you run the code in Python (adjusted to your paths), you’ll get the CSV file at your specified location.