Creating a CSV file using Notepad is quit simple. This is because all you need do is write is plain text on a line, then separate each column with a comma and make a new `roll by inserting a line break, that is pressing the enter button on your keyboard. Let consider two example to help you understand it more.
EXAMPLE ONE:
- Open Notepad and type or copy this text into it
This is an, example of a, CSV file
With three, columns and, Two rows. - Now Save it as example one.csv and open it with a spreadsheet program like Microsoft Excel.
EXAMPLE TWO:
In this example, let's suppose you want to make the middle column of the second row empty, but the want something to be written in the first and third column but the second column which is in the middle should be empty.
- Open Notepad and type or copy this text into it
This is an, example of a, CSV file
With three columns, ,and Two rows - Now Save it as example two.csv and open it with a spreadsheet program like Microsoft Excel.
That's how easy it is to create a CSV file using Notepad.
Join our newsletter and we will keep you updated on surfs like this.
Team Pinfoltd
0 comments: