Convert Text to CSV Using Notepad or Notepad++

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

In notepad, convert text to CSV using the Replace command.

You can also try this free online tool to convert text to CSV.

Text File Sample

7369 SMITH CLERK 7902 17/12/1980 800 20
7499 ALLEN SALESMAN 7698 20/02/1981 1600 300 30
7521 WARD SALESMAN 7698 22/02/1981 1250 500 30

Convert to CSV Example

  1. Open the text file in Notepad or in Notepad++.
  2. Press ctrl+H to invoke Replace window.
  3. Then in Find What type single space and in Replace with type a comma.
  4. Then click on Replace All button to replace all single space with the comma ",".
  5. Save as CSV file.

Result

7369,SMITH,CLERK,7902,17/12/1980,800,20
7499,ALLEN,SALESMAN,7698,20/02/1981,1600,300,30
7521,WARD,SALESMAN,7698,22/02/1981,1250,500,30

This method will work if your text file is containing only one space between each column. If having multiple spaces or having complex data, then it is better to convert using Microsoft Excel.

See also:

  1. Split large CSV using PL/SQL
  2. Import CSV using Toad in Oracle