TurboSoftwares

Turbo Excel Column and Row Extractor

Buy now

About 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

  1. Point to a folder.
    Add a filename pattern and press Scan Files.
  2. Choose sheets and mode.
    Columns, Rows or both.
  3. Pick columns or rows.
    Add filter conditions if needed.
  4. Set the output.
    Combine or split, XLSX or CSV.
  5. 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.