提示:其他語言是Google翻譯的。 你可以訪問 English 版本。
登入
x
or
x
x
註冊
x

or

在Excel中快速列出文件夾或目錄的所有文件和子目錄

許多人可能會想知道為什麼沒有直接的方法來獲取和創建Excel中特定文件夾或目錄的文件列表。 但是與 Kutools for Excel文件名列表 實用程序,特定文件夾或目錄的所有文件和子目錄將與Excel中的文件屬性一起列出。

列出新工作表中文件夾中的所有文件名

Office選項卡在Office中啟用選項卡式編輯和瀏覽,使您的工作更輕鬆......
Kutools for Excel解決了您的大多數問題,並使您的生產率提高了80%
  • 重用任何東西: 將最常用或最複雜的公式,圖表和其他任何內容添加到您的收藏夾中,並在將來快速重複使用它們。
  • 超過20文本功能: 從文本字符串中提取數字; 提取或刪除部分文字; 將數字和貨幣轉換為英文單詞。
  • 合併工具:將多個工作簿和工作表合二為一; 合併多個單元格/行/列,而不會丟失數據; 合併重複的行和總和。
  • 拆分工具:根據價值將數據分割成多個工作表; 一本工作簿可轉換為多個Excel,PDF或CSV文件; 一列到多列。
  • 粘貼跳過 隱藏/過濾行; 數和總和 按背景顏色; 將個性化電子郵件批量發送給多個收件人。
  • 超級過濾器: 創建高級過濾方案並應用於任何工作表; 分類 按週,日,頻率等; 過濾 通過大膽,公式,評論......
  • 超過300強大的功能; 與Office 2007-2019和365一起使用; 支持所有語言; 在您的企業或組織中輕鬆部署。

點擊 Kutools Plus > 進出口 > 文件名列表。 看截圖:

鏡頭文件名列表1 1


列出新工作表中文件夾中的所有文件名

1。 打開要在新工作表中的特定文件夾中創建文件列表的工作簿,然後應用該工作簿 文件名列表 點擊實用工具 Kutools Plus > 進出口 > 文件名列表.

2。 在 文件名列表 對話框,請執行以下操作:

(1。)單擊 123 按鈕選擇要列出文件的目錄;

(2。)如果您需要列出子文件夾中的文件或列出隱藏文件,請檢查 將文件包含在子目錄中 or 包含隱藏的文件和文件夾 選項。

(3。)指定您想在列表下列出的文件類型 文件類型 部分;

(4。)從中選擇一個要顯示的文件大小單位 文件大小單位 部分。

(5。)檢查 創建超鏈接 選項將為每個列出的文件創建超鏈接。

射擊 - 文件名,list2

3。 完成上述設置後,單擊 Ok 創建列表。 該文件夾中包含的所有文件都已在新工作表中顯示,並帶有一些屬性。 看截圖:

射擊 - 文件名,list3

小技巧: :該列表將包含其他屬性,如文件大小,文件類型,創建日期等。


生產力推薦工具
以下工具可以大大節省您的時間和金錢,哪一個適合您?
Office Tab: 在您的Office中使用方便的選項卡,作為Chrome,Firefox和新Internet Explorer的方式。
Kutools for Excel: Excel的300高級函數 2019,2016,2013,2010,2007和Office 365。
Classic Menu for Office: 把熟悉的菜單帶回到Office 2007,2010,2013,2016,2019和365,就像它是Office 2000和2003一樣。

Kutools for Excel

上述功能只是Kutools for Excel的300強大功能之一。

專為Excel(Office)2019,2016,2013,2010,2007和Office 365而設計。 免費下載並使用60天。

Excel的Kutools屏幕截圖

BTN閱讀更多 BTN下載 btn購買

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Asif · 1 years ago
    I am tried . It does import file names however it keeps files names with digit in top and drags with alphabet bottom ?? How can we keep same sequence as in folder?? Thanks
  • To post as a guest, your comment is unpublished.
    kanhaiya · 2 years ago
    how can I get list of folder names only
  • To post as a guest, your comment is unpublished.
    Jeff Williams · 2 years ago
    I am trying to list the files off of my Samsung phone, connected as an external drive, however, it is grayed out for all files on my phone. Will it not work this way? I seem to remember using my external hard drive and doing the same thing. Thanks. Still learning about your product, but it is definitely a time saver.
  • To post as a guest, your comment is unpublished.
    Akshay Jagtap · 2 years ago
    Hi, The tool is just awesome.
    In my Scope, I am Extracting the Video/Audio file names,
    I would like to know if file duration can be extracted too.
    Thanks.
  • To post as a guest, your comment is unpublished.
    max · 2 years ago
    hi

    how can i get only folder lis
  • To post as a guest, your comment is unpublished.
    Eleanor H · 5 years ago
    I have experiencing the same issue as Gary P. The app will not list files in folders with more than 10,000 files, even if I specify a file type
    • To post as a guest, your comment is unpublished.
      admin_jay · 5 years ago
      [quote name="Eleanor H"]I have experiencing the same issue as Gary P. The app will not list files in folders with more than 10,000 files, even if I specify a file type[/quote]
      We will enhance it soon. :-)
      • To post as a guest, your comment is unpublished.
        Abhijit Ghatge · 2 years ago
        Has this issue been addressed in the recent versions....I am using v16.5 and it does not list anything above 32766 files...tried couple of times but still stops at the same level
  • To post as a guest, your comment is unpublished.
    Gary P. · 5 years ago
    This is a cool tool but it won't list files in folders with more than 10,000 files. I have multiple folders with 100,000 PDF files I'm trying to use this tool for. Any way to change the limit?