How to Open Multiple CSV Files in One Excel Spreadsheet. The CSV file extension appears on text documents that contain comma-separated values. Like spreadsheet data, each line in a CSV file ...

How to Format Text in an Excel Spreadsheet. Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically ...

If you have a list of items in a text file and you want to import data from a text file into Microsoft Excel, you can do that without writing them manually. An option in Excel allows users to ...

Edmond Woychowsky walks you through his process, including all the necessary sample code, to convert an XML file to an Excel spreadsheet.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.