How to Create a CSV File. A CSV file is a text file that is formatted as a table. Each line has data that is separated from each other by commas.

If you've encountered a CSV file and you're unsure what they're for, the good news is they're pretty straightforward and easy-to-use with apps you already know.

Launch Microsoft Office Excel 2007 and open the spreadsheet that you wish to save in CSV format. Use the "Ctrl-O" keyboard shortcut to open the file faster.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

To save the data as a CSV/OFX/QFX/QBO file, tap the Share icon in the upper-right corner of the screen, where you can opt to AirDrop it to another device such as your Mac, print it, or Save to ...