Things You'll Need

Instructions

Opening a CSV File in Microsoft Excel Spreadsheet

1

Open a CSV file normally in Microsoft Excel. If Microsoft Office is installed on the computer, CSV files will open normally just by double-clicking them. If you want to create a CSV file from a spreadsheet, then choose File > Save As (from the file pull down menu).
2

A file can be created at the command prompt just by redirecting the output to the standard console. The command is "COPY CON [FILENAME]". Next, you can add text and delimit the characters with commas at the ends of the lines with the [ENTER] key. To save the file, press the [F6] key followed by [ENTER]
3

Once the file has been created, it can be opened in a spreadsheet program.
4

CSV files can be used to import data into a database. In Microsoft Access, you can "Get External Data" from the File drop-down menu and import it as a table. Then it can be incorporated into the database and queried along with the tables already in existence there.
5

When we open a CSV file in Microsoft Word, we can see it even more clearly. We can manipulate it in other ways and, provided it is saved as a CSV file, it can be imported back into our database (Microsoft Access) or manipulated in another way in our spreadsheet program (Microsoft Excel) without losing its formatting at all.