You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Troubleshooting > How to Convert Tab-Delimited TXT Files to Comma-Delimited Format Using Notepad++
How to Convert Tab-Delimited TXT Files to Comma-Delimited Format Using Notepad++
print icon

This article provides a step-by-step guide on converting a tab-delimited TXT file into a comma-delimited format using Notepad++. This simple method allows users to replace tab characters with commas efficiently, making the file compatible with detamoov's file definition requiring comma-separated values. Follow these instructions to ensure the file is formatted correctly.

  1. Download and Install Notepad++
    • If you don’t already have Notepad++, download it from this link and install it on your computer.
  2. Open the File in Notepad++
    • Launch Notepad++.
    • Go to File > Open, then select and open the file you need to correct.
  3. Open the Find & Replace Tool
    • Press CTRL + F on your keyboard to open the Find dialog box.
  4. Configure Regular Expression Search
    • Select Regular Expression in the Search mode.
    • In the Find dialog, click on the Replace tab.
    • At the bottom of the dialog box, check the option for Regular expression (this enables special character patterns for find-and-replace).
  5. Set Up the Replace Action
    • In the “Find what” field, type \t (this represents a tab character in regular expressions).
    • In the “Replace with” field, enter a comma , (this will replace each tab character with a comma).
  6. Execute the Replace Action
    • Click on the Replace All button to replace all instances of tab characters with commas throughout the file.

 

  1. Save the Updated File
    • Go to File > Save to save the modified file.
  2. Upload the Corrected File
    • Now that the file has been modified and saved with commas instead of tabs, it’s ready for uploading without errors.

This process will reformat the file and eliminate tab-based formatting issues.

 

 

 

scroll to top icon