Turbo Excel Column and Row Extractor
Buy nowAbout the Software
Data often arrives as one workbook per branch, month or client, each holding far more than you need. Opening every file to copy four columns into a master sheet is slow.
Turbo Excel Column and Row Extractor removes that loop. Describe the extraction once, with the folder, sheets, columns, rows and conditions, and the app applies it to every file it finds. The output is a clean, data-only workbook or CSV.
Screenshots
Features
- Columns
- Choose by header name from a sample file, or type letters such as A,C,F:H.
- Rows
- First N, Last N, a range, specific rows or skip the first N, combined with filters.
- Filters
- Twelve operators, joined with AND or OR, applied before columns are narrowed.
- Worksheets
- Read all sheets, the first, the active sheet or a checked list.
- Header row
- Set where the real header sits when a title block comes first.
- Source tracking
- Optional columns show the source file, sheet and row of every record.
- Output
- Combine everything into one file or write one file per source.
- Cleaning
- Trim whitespace, drop empty rows and remove duplicates.
- Preview
- Test the settings on the first matching file before the full run.
Supported formats
Lock files are ignored automatically. Macros in XLSM files are never executed.
- XLSX
- XLSM
- XLS
- CSV
How to use it
- Point to a folder.
Add a filename pattern and press Scan Files. - Choose sheets and mode.
Columns, Rows or both. - Pick columns or rows.
Add filter conditions if needed. - Set the output.
Combine or split, XLSX or CSV. - Preview, then extract.
Save the setup as a configuration file for reuse.
Filtering and output in detail
Filter operators range from Equals and Contains to Greater Than or Equal and Is Blank. Because conditions run before columns are narrowed, you can filter on a column you do not keep.
Choose XLSX when a person will open the result, or CSV when a database, Power BI, Python or another tool will read it. CSV has no row ceiling of its own.
Stop lets in-flight files finish, so no output is half-written. Progress shows files per second and time remaining, and settings save to a file you can load later.
Offline use
Files are read on your PC and nothing is uploaded.
Typical uses
Collect four columns from every branch workbook into one master sheet. Keep every column but return only the rows where Status says Open. Take columns for rows where the region is South and the amount is over 10,000.
The output is meant to feed pivot tables, BI tools, imports and reports. It is not meant to reproduce the formatting of the originals, and each result holds exactly the cells you asked for.