How to change a delimiter/separator in CSV file

Question:

How can I change a delimiter in CSV file? I am not able to upload a CSV to the Pushwoosh Control Panel in order to update Tag values or import new email contacts. 

Answer:

Before uploading the file, please ensure that the delimiter is a comma and that the file is saved in CSV format.

Here are most common methods for changing the delimiter in a CSV file. It’s worth noting that a CSV file is essentially a plain text document, which means it can be edited using any text editor (though this might be less convenient) or specialized software.

Method 1: Using a Text Editor

1. Open the File:
   
   • Open the .csv file in a plain text editor (e.g., Notepad on Windows, TextEdit on macOS in plain text mode, or VS Code).
2. Replace the Delimiter:
   
   • Use the Find and Replace feature of the editor:
     • Press Ctrl + H (Windows) or Cmd + H (macOS).
     • In the Find box, type ;.
     • In the Replace box, type ,.
     • Click Replace All.
3. Save the File:
   
   • Save the file with the changes.

Method 2: Using Excel or Spreadsheet Software

1. Open the File in Excel:
   
   • When importing the file into Excel:
     • Open Excel and go to File > Open.
     • Locate and select your CSV file.
     • Use the Import Wizard if prompted, and specify ; as the delimiter.
2. Change the Delimiter:
   
   • After the file is opened in Excel, export the data:
     • Go to File > Save As.
     • Choose CSV (Comma delimited) (*.csv) as the file format and specify , as the delimiter.
     • Save the file.