How to Copy File Names in Excel from a Folder? (3 Easy Methods)

The copy file name option in Excel is a useful way to display chunk of files in excel or make changes to the name of a file. If you want to copy large number of file names into excel, it will be a hectic and tedious task if you type them manually. In this article we will show you how copy file names in excel in easy and simple way. There are different methods to do it. Let us take you through to each one by one.

Tips that are provided in this article are compatible with versions 2010/2013/2016.

Method 1：USING CTRL+C AND CTRL+V TO COPY FILE NAMES IN EXCEL

If you want to copy the name of a file in Excel, use CTRL+C and CTRL+V. The keyboard shortcut is Ctrl+c, followed by Ctrl+v on your PC or Command+c followed by Command+v on Mac. This works well if you want to paste the copied name into another column or cell of your workbook. For example, if you want to copy a filename from one sheet and paste it into another sheet, then use ctrl-c followed by ctrl-v.

1. Open Excel as well as file explorer Open File Explorer

2. Select the file you want to copy.

3. Press CTRL+C

4. Paste the file by using CTRL+V on Excel sheet.

Method 2：USING COPY AS PATH TO COPY FILE NAMES IN EXCEL

Copy as Path is used to create shortcuts on the desktop and in the Start menu. It is very useful when you want to create shortcuts for files or folders that are located at different locations on your computer.. You can also use this to copy file names into excel. To copy a file name in Excel, you can use the following steps:

1. Open Excel. 

2. Navigate to the folder and select the required files.

3. Right click the mouse, a window will pop up. In this window, select copy as path. This copy the path of files to clipboard.

4. Navigate to excel, press the ALT + TAB key, and paste the files.

And that's it , you have copied file names into the excel.

Method 3：USING IMPORT DATA TO COPYING FILE NAME IN EXCEL

With just a few simple steps, you can import your file names into Excel, eliminating the need for manual entry. This not only saves you valuable time but also ensures accuracy and consistency in your data. Say goodbye to tedious manual copying and hello to streamlined data management. Try using import data to copy file names in Excel today and experience the benefits of increased efficiency and improved workflow.

1. Click on Data > Import Data > From File > Select data source.

2. Enter the main folder of your files and select the files you want to import

3. Select open and your file name is copied into excel.

You can download WPS office to edit the word documents , Excel Spread sheets, and PowerPoint free of cost. WPS Office is a free all-in-one office software, established in 1989 by Kingsoft Office Software, currently has more than 500M users worldwide, with a score of 4.8 on Trustpilot (from 880 reviews). Download Now! And get an enjoyable working space.

Trustpilot4.8

WPS Office- Free All-in-One Office Suite

• Use Word, Excel, and PPT for FREE, No Ads.

• Edit PDF files with the powerful PDF toolkit.

• Microsoft-like interface. Easy to learn. 100% Compatibility.

• Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

Free Download

5,820,008 User

Algirdas Jasaitis

logo