CSV file- Steps to create it with excel
CSV file is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV file format can be imported to and exported from programs that store data in tables, such as Microsoft Excel, notepad etc. We will only discuss about Microsoft excel in this post for now. If you have information in Excel that you want to get into a different data-oriented program, chances are good that the other program will accept CSV files. In order to save your workbook data in CSV format, follow these steps:
This guide provides you detailed information on how to send SMS text messages in CSV file format with WEBSMS NG. Please follow the configuration guide below to be able to apply this solution.
Step 1.
Open an excel sheet and open a new file. Then enter the text data you want the file to contain as exactly in the picture below. The first row should be the “Sender ID”, second row should be “Recipients” while the third row should be “Message”
This is important for the system to automatically recognize your data and assign properly for sending.
Step 2.
Input data required as shown in step 1 and then save document in CSV (Comma delimited) (*.csv). Your file can be saved in your desktop, document or your preferred folder. Ensure that you are able to navigate to the folder and select the file.
Step 3.
Excel may display a dialog box telling you that not all Excel features can be maintained in the format you have chosen. Click on Yes to continue saving the information in CSV format.
Click on Yes to save the file and you can now send your SMS. At this point your worksheet is saved in CSV format. I generally find it a good idea to close the workbook, without saving. At this point you will have your original Excel workbook (in Excel format) and the CSV file, which contains the information you wanted in CSV format.