• Export Folder Structure To Text File Converter
• Export File Directory List
• Export Folder Structure To Text Files

With the help of a PowerShell script, you can export folder permissions to a CSV file and open it in Excel, so you can spot users with unnecessary permissions, adjust those permissions to align with your data security policy, and thereby minimize the risk of a data breach. Sep 17, 2020 Open or extract the zip-file and double click on ExportOutlookFolders.vbs Select the mailbox or folder you want to export the folder names of. Select whether you want to structure the output or not (see the example screenshots below). Within a few seconds the file outlookfolders.txt will appear on your Desktop containing the exported folder names. I have a folder of media files that are about 1TB big. I want to save the file names and directory structure to a text file for backup and reference. I want to attach a batch or PowerShell script to my backup process so the file gets saved before the backup. Open Windows Explorer and navigate to your favorite folder for which you want to create a list of filenames as text. Copy File Names as Text from folder Now select only those files for which you want to copy file names into excel from the folder.

How to export Excel data (selection or sheets) to Text files in Excel?

If you are required to deliver a workbook in the format of text file, you need to convert the workbook into text files. And this article will introduce you two methods to export Excel data into text files easily.

• Batch export multiple sheets to separate text files in Excel
• Export selection (or one column) to text file with Kutools for Excel

Export one single sheet to text file in Excel

By default, the Excel data will be saved as workbooks in the format of .xlsx. However, we can export a worksheet of existing workbook as text files with the Save As feature. Please do as follows:

1. Shift to the worksheet which you will export to text file, and click File (or Office button) > Save As.

2. In the opening Save As dialog box, select the destination folder you will save the exported text file into, name the file in the File name box, and then select the Unicode Text (*.txt) from the Save as type drop down list. See screenshot:

3. Then it will pop up two warning dialog boxes asking you to export only active worksheet as text file and leave out any incompatible features with text file. Click OK button and Yes button successively.

Then the data in the active worksheet are exported as a new text file.

Note: the Save As command is only able to export data of active worksheet as a text file. If you want to export all data of the whole workbook, you need to save each worksheet as a text file individually.

Export selection (or one column) to text file with VBA

The following VBA code also can help you to export the selected range data (for example one column) to the text file, please do as this:

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

Export Folder Structure To Text File Converter

VBA: export selection or entire worksheet to text file

3. Then press F5 key to run this code. And then select the data range that you want to export in the popping up dialog box, and click the OK button, see screenshot:

4. And now in another Save As dialog box, please specify a name for this text file and a folder to put this file into, and click the Save button.

Export selection (or one column) to text file with Kutools for Excel

The Save As command can export all data in the active worksheet as text. What if exporting all data of specified inactive worksheets, or part of the data in a worksheet as a text file? Kutools for Excel's Export Range to File utility can help us export and save the data in selection as a text file easily..

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Free Trial Now!

1. Select the rang you will export to a text file (in our case, we select the Column A), and click Kutools Plus > Import / Export > Export Range to File, see screenshot:

2. In the Export Range to File dialog box, do as below screenshot shown:
(1) Check the Unicode Text option in the File format section;
(2) Check the Save the actual values option or Save values as shown on-screen option as you need in the Text options section;
(3) Specify the destination folder you will save the exported text file into;
(4) CLick the Ok button.

3. Name the exported text file in the new opening dialog box, and click the Ok button.

And then the selection (selected Column A) has been exported as a text file and saved into the specified folder.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

Export multiple sheets to separate text files in Excel

Sometimes you may need to export multiple worksheets to multiple text files in Excel. The Save As feature may be a little tedious! Do not worry! Kutools for Excel’s Split Workbook utility provide Excel users an easy workaround to export multiple worksheets to many separate text files with several clicks.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Free Trial Now!

Export File Directory List

2. In the opening Split Workbook dialog box, please do as follows:
(1) Check the worksheets you will export to separate text files in the Workbook name section;
(2) Check the Specify save format option, and then select the Unicode Text (*.txt) from below drop down list, see left screenshot:
(3) Click the Split button.

3. And then in the popping up Browse For Folder dialog box, select the destination folder you will save exported text files into, and click the OK button.

So far each specified worksheet has been exported as a separate text file and saved into the specified folder.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

Easily mass save each sheet as a separate PDF/text/csv file or workbook in Excel

Normally we can save active worksheet as a separate .pdf file, .txt file, or .csv file with the Save As feature. But Kutools for Excel’s Split Workbook utility can help you easily save each workbook as separate PDF/TEXT/CSV file or workbook in Excel. Full Feature Free Trial 30-day!

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

Demo: export Excel data (selection or sheets) to Text files in Excel

Related Articles:

Export Folder Structure To Text Files

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

• To post as a guest, your comment is unpublished.
  Hi, this code is very useful for me. So thank you very much.

  
  

  When i'm using this code, a new line append automatically at the end of the txt content.

  Can you help me about preventing this by vba?
• To post as a guest, your comment is unpublished.
  hi guys, i used that code:
  Sub ExportRangetoFile()
  'Update 20130913
  Dim wb As Workbook
  Dim saveFile As String
  Dim WorkRng As Range
  On Error Resume Next
  xTitleId = 'KutoolsforExcel'
  Set WorkRng = Application.Selection
  Set WorkRng = Application.InputBox('Range', xTitleId, WorkRng.Address, Type:=8)
  Application.ScreenUpdating = False
  Application.DisplayAlerts = False
  Set wb = Application.Workbooks.Add
  WorkRng.Copy
  wb.Worksheets(1).Paste
  saveFile = Application.GetSaveAsFilename(fileFilter:='Text Files (*.txt), *.txt')
  wb.SaveAs Filename:=saveFile, FileFormat:=xlText, CreateBackup:=False
  wb.Close
  Application.CutCopyMode = False
  Application.DisplayAlerts = True
  Application.ScreenUpdating = True
  End Sub
  and have working, but i need to savea column with cells that contain the function'concatenate', and when i play the vba code, and i save the .TXT file, only what appears it's #REF. how can i to fix it? cause i need the data that appears on that cells?

  • To post as a guest, your comment is unpublished.
    Has anyone been able to figure this out? I am having the same issue.
• To post as a guest, your comment is unpublished.
  HELLO
  THANK YOU FOR YOUR VBA CODE
  SOMETIMES ON CERTAIN TEXT THERE IS 'TEXT' IN EXPORT .TXT
  THANK YOU FOR WHY
• To post as a guest, your comment is unpublished.
  Thanks for the awesome piece of VBA code to export data to a text file. I have used your code with some of my own. The data I am dealing with is extremely line-length specific and after the macro has run, the text file contains some double quotation marks ' at random places, which was never present in my data before. I have tried adding a code line to remove this character at various stages but that does not seem to be working. I am aware that I can manually remove this but would like to resolve it in the VBA code.
  Sub Macro3()
  Dim wb As Workbook
  Dim saveFile As String
  Dim WorkRng As Range
  On Error Resume Next
  Selection.AutoFilter
  ActiveSheet.Range('$A$1:$B$10591').AutoFilter Field:=1, Criteria1:= _
  '=NSZAP*', Operator:=xlAnd
  Range('A1').Select
  ActiveCell.Offset(200, 0).Range('A1').Select
  Range(Selection, Selection.End(xlDown)).Select
  ActiveCell.Rows('1:10101').EntireRow.Select
  Selection.Delete Shift:=xlUp
  Range('A1').Select
  Selection.AutoFilter
  Range(Selection, Selection.End(xlDown)).Select
  Set WorkRng = Application.Selection
  Set wb = Application.Workbooks.Add
  WorkRng.Copy
  wb.Worksheets(1).Paste
  Selection.Replace What:='', Replacement:=', LookAt:=xlPart, _
  SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
  ReplaceFormat:=False
  saveFile = Application.GetSaveAsFilename(fileFilter:='Text Files (*.txt), *.txt')
  Selection.Replace What:='', Replacement:=', LookAt:=xlPart, _
  SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
  ReplaceFormat:=False
  wb.SaveAs Filename:=saveFile, FileFormat:=xlText, CreateBackup:=False
  Selection.Replace What:='', Replacement:=', LookAt:=xlPart, _
  SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
  ReplaceFormat:=False
  wb.Close
  Application.CutCopyMode = False
  Application.DisplayAlerts = True
  Application.ScreenUpdating = True
  End Sub

  • To post as a guest, your comment is unpublished.
    Hi Harish,
    For removing a specified character in bulk, you can replace the character with nothing.
    Ctrl + H to open the Find and Replace dialog box, type the specified character in the Find what box, and type noting in the replace with box.
• To post as a guest, your comment is unpublished.
  3/2
  You might also note that you don't need to specify the wb prefix once you've .Add ed the workbook since it becomes active. Specifying wb might or might not be more efficient but it can be omitted from some commands. Actually I entirely scrapped the variable wb; I just go Workbooks.Add, and use ActiveWorkbook when needed. (As you are suppressing ScreenUpdating it wouldn't be obvious to some that wb is Active. Tip for beginners (and higher): I always, always develop with ScreenUpdating and DisplayAlerts as True, and when done with development, I consider toggling them off for some passage of code.)
• To post as a guest, your comment is unpublished.
  2/2
  - vbYesNoCancel msgboxes and Booleans to indicate whether to export all, selection, or a user specified range
  - a static String for the prior range address
  - if len(that static)1 then I set WorkRng=activesheet.UsedRange (You can't copy multiple areas with a single copy, though with a little work you could walk the areas and copy them piecemeal.)
  - Idiotic Microsoft does not save off empty rows at the start and the bottom of the saved range, and does not save off empty columns at the leftmost and the rightmost of the saved range. When I detect that (UsedRange is not row 1, col. 1, or xlLastCell is not completely lower-right) I msgbox to ask user if they want to plug A1 or the lower right cell.
  - Then I decided to preemptively address the upper left issue by inserting a row and setting A1 to be text like 'The following is for range '
  - I close with activeworkbook.close SaveChanges:=False
  - Long time habit since I'm an angry proponent of cleaning up (and the world is a sad place thanks to irresponsible programmers who shirk that responsibility when it matters), I set WorkRng = Nothing on the way out :)
• To post as a guest, your comment is unpublished.
  1/2 (since your software limits comment length)
  I am a serious coder and I want to inform you that the VBA code here is outstanding. It's clean, and not one line too much, or one too few. It's exemplary coding for demonstration of the process.
  I'll also mention that as I extensively researched solutions for export of selection, you and only one other person suggested dropping the range into a temp new workbook. All other answers were painfully manually, walking through cell by cell. Even Chip's code is much longer and runs slower (but intentionally so, as it is much more flexible - specifiable delimiters, etc.)
  Just for your amusement, I made some very minor tweaks but otherwise nearly lifted the code word for word because it basically dropped right into a very intricate and specialized application. Some of these tweaks are something I'm sure you do in practice, but they add lines of code (e.g. error checking) so showing them on this webpage would have muddied your display so that the essential elements of processing would have been cumbersome for readers to follow along. Anyway: (see part 2)
• To post as a guest, your comment is unpublished.
  My query is as mentioned below:
  I have a report to generate everyday.
  The data what I get on the final row (only one row but more than one columns) I want it to export to another excel sheet which is a summary excel sheet saved separately on my desktop.
  Eg:
  Day1 report - final row export to Summary excel sheet row1
  Day2 report - final row export to Summary excel sheet row2
  Day3 report - final row export to Summary excel sheet row3 and so on..
  Export should be done through a click button., which means when I click on export button the data on the sheet I calculated today should go and save on the Summary excel sheet row1, next day a new excel sheet report calculated should go and save on the Summary excel sheet row2 and so on..
  Will this be possible to do...
  If yes please someone help me on this...
  Thank you in advance...:-)
• To post as a guest, your comment is unpublished.
  One of the best site where I find my queries.
• To post as a guest, your comment is unpublished.
  Someone knows how to do it for excel 2016 MAC?? ty
• To post as a guest, your comment is unpublished.
  Hi!
  The cells I want to export as a text-file refer to other cells and contain if-codes. This means that when I export I don't get the number-values, but 'N/A'. Do you know how i can fix this?
  Thank you.
• To post as a guest, your comment is unpublished.
  i have problem after saving my .xls to .txt, size of the file getting bigger, from 500kb to 1,523kb how i fix it?
  thanks
• To post as a guest, your comment is unpublished.
  need to past data from excel to a notepad and then seperate data using a comma. how do i do this

  • To post as a guest, your comment is unpublished.
    you need to select 'save as .csv file' (comma separated values)
• To post as a guest, your comment is unpublished.
  really is it very usefull,thanku :D