The data in the Excel sheet does not refresh, so we need to import the data regularly. You can use this method to keep track of file changes and filenames. Read : How to merge Excel Files and Sheets .

If you list every file on a drive, Windows places the names of all files, including Windows system files, in the text file you specify. This file will be large and may take a long time to create.

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.

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.

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.