How to get a list of files in a folder into Excel

In this post we will see how to get a list of files in a folder into Excel. We will show you how to use Excel to view Files and Folders details in Windows, by importing all files and folders details in to Microsoft Excel to keep track of file size, file type and last modified date.

We have many files and folders in our Windows PC and we may delete or add more files and folders frequently. There could be some folders and files which are very important to us and someone might edit them without our notice. But, we cannot keep on looking at each and every folder and file to know which one was edited. If it was modification of a file or folder, we can sort them by using ‘Last modified’ and we can get to know which were modified recently.

But, what if some of the files and folders were deleted from that directory? We would not be in a position to keep track of what were exactly deleted. But, you can use Excel to view files and folder details of directory which would be helpful to you to know at least the list of files and folders that were deleted.

Import and get a list of filenames into an Excel sheet

If you use Microsoft Excel to import all details of files and folders in to Excel, it will help you keep track of last modified date and time, file types, list of files, files size and many more regularly. To do this, follow these simple steps.

Move to the directory or folder on Windows File Explorer which you want to keep track of. Here, I want to keep track of my files and folders of Documents folder. Copy the path of that directory.

Now, open any web browser of your choice and paste the copied path (Path of the folder you just copied in the previous step) in the address bar of the browser. I used Google Chrome here. Just prefix the URL by file:///and the content will be shown as the web page.

To save this web page as the offline copy, press CTRL+S or right-click on the web page and select “Save Page As”. Select the destination, give it a name and save the webpage.

Now, via Windows Explorer go the location you saved the offline webpage and copy the path. The, open the Excel sheet and tap on the Data tab and click on From Web. It opens up the Window and in the Address bar paste the copied path and click “Go” button. It will load all the contents of the webpage.

It shows you the yellow boxes with arrows and it will allows you to select the required frame. You can find here that I selected the part I want.

Once done with these steps, now click on import button and you see that all the files and folders details are imported to your Excel sheet in no time. You can see that, data is shown the columns and gives us the clear idea of every detail.

Conclusion

As we are engaged most of the time, in organizing files and folders, it is advisable to import files and folders details in to Excel. This would be helpful if any of your file or folder was to get deleted. The data in the Excel sheet does not refresh, so we need to import the data regularly. You can use this method, when to not only keep track of file changes, but also filenames.

Read More

What is BIOS in computers and how does it work

BIOS is short for Basic Input Output System. It is much more than the name suggests. One might think that BIOS controls input and output system. But the BIOS does much more and it is not possible for any operating system to continue without a proper BIOS in place. Today, we will see what is BIOS in computers.

BIOS has been there in our computers since the days of DOS – Disk Operating System… even prior to the structured DOS created by Microsoft. It is one of the most important components of the computer though it does not take the credit by appearing on your screen regularly. This post also looks at the most basic component of computers and explains why is it required in computers for computers to work.

What is BIOS

BIOS is a firmware, in short. It is stored on a chip on a part of the computer motherboard and is basically, a set of instructions that run to help load the operating system. You OS would fail to load, if not for the BIOS!

When you turn on the computer, BIOS instructions are initiated. These instructions make it check the RAM and the Processor (for faults) on your computer.

1. It enumerates the RAM by checking each compartment to see if all of them are working.
2. After checking out RAM and Processor, it checks for other devices attached to the computer
3. It detects all the peripherals, including the keyboard and mouse and then checks for the boot options
4. Boot options are checked in the sequence configured on your BIOS: Boot from CD-ROM, Boot From Hard Drive, Boot from LAN etc.
5. It checks for bootstraps on the devices in the order you or the machine vendor configured the BIOS.
6. It passes reigns of the computer to operating system by loading the essential parts of the OS into the random access memory (RAM) reserved for the OS, after bootstrap is located.

This is not a comprehensive list of functions of the BIOS. It also checks up CMOS, and other chips to set up the date and time on the computer, and to load the device drivers into the memory. It checks and uploads input and output interrupts (signals) to the RAM so that the operating system knows what is happening. For example, if a user presses a key, an interrupt request is created and passed on to the BIOS which sends it to the operating system. The operating system then decides what action to take, according to the way it is programmed.

The reason why operating system cannot work without BIOS is because the former resides on hard disk or a removable disk. It is the BIOS that loads the drivers of the hard disks and removable disk drives, so that they are functional. It then loads the primary portions of the operating system such as the MBR, GPT, FAT, etc, into memory, so that the operating system can continue loading itself.

Making Changes to BIOS

It is easy to make changes to BIOS when required. The most common changes people make in BIOS is to change the BOOT ORDER. While the computer is booting, press DEL key on your keyboard to enter BIOS. From there, you can see different options grouped under different headers. Use tab and arrow keys to navigate. Sometimes Page Up and Page Down keys are required to change values of essential items. When you are done, press F10 to save changes and exit. The options are displayed on right or bottom on the screen so that you know what keys to press for saving or discarding changes. The options also specify what keys to use for changing values.

How to Update BIOS

As the computing scenario changes, new devices etc are introduced. To make a computer work with these devices, the BIOS has to be upgraded. If your operating system fails to detect a new peripheral, it is possible because BIOS doesn’t know how to handle it. If you face any such issues, it might be a good idea to check if any BIOS updates are available.

You have to check the BIOS version first. This can be done by entering BIOS at the time of booting, by pressing DEL. Once you have the version of your computer BIOS, you visit the website of your computer manufacturer to see if there is any updated version of BIOS is available. If there is, download it and run it. The process is generally wiping off all the previous information on the BIOS chip and rewriting it with the new information.

Make sure you have power backup while upgrading the BIOS. Because if the computer turns off during the process, the BIOS may be corrupted and you will need a technician to fix it. Your boot CD/DVD may or may not help depending upon how the BIOS stands after a powercut or a sudden system turn off while rewriting the BIOS.

IMPORTANT: If your computer is working properly, you do not need to update or flash your BIOS. In any case, should you wish to, we recommend that you do not try to update your BIOS yourself, but instead take it to a computer technician who may be better equipped to do it.

Read More