Import text files with over a million lines into Excel

Text File Importer in detail

The Text File Importer for Excel can quickly and easily import text files (CSV, TXT, PRN, ASCII,....) containing over one million rows of data into Microsoft Excel. It is entirely menu driven. When you click on the first button on its toolbar, the following dialog appears:

Select the first menu option to import a large file into an Excel workbook. Once you have selected the file, the following dialog controls how many lines are imported into each worksheet.

New worksheets are created as needed. The first input on the above dialog allows you to reserve rows for titles.

In our tests, we imported over a million lines in just two minutes!

In addition to importing large text files into Excel, the Text File Importer can also import many text files at one time into Excel. Just use the second option on the main dialog and select the files to be imported. The following dialog displays the import options one has when using this feature:

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..