The list contains two options: "Excel 97 – Excel 2003 Workbook" and "Microsoft Excel 5.0/95," which is the default. In most cases, you should just leave the value set at the default.

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.

How to Download an Excel Spreadsheet. Downloading an Excel spreadsheet from a link in a Web page isn't complicated: just click the link and the browser saves the associated file to the computer.

If you’re able to download a .csv file, you can open this file in Excel by clicking the Data tab. In the Get & Transform Data group, click Get Data. Then, choose From File and finally From Text/CSV.