# Remove Matching Rows > Remove matching rows with a list subtraction tool. Subtract one list from another using whole-row matching, case sensitivity, or word-order matching. **Remove matching rows** by comparing a source list with a separate list of values to exclude. This list subtraction tool keeps source rows that do not match any removal value under the selected rules. ## Overview & Metadata - **Canonical URL:** https://million.tools/remove-matching-rows/ - **Markdown Copy (.md.txt):** https://million.tools/remove-matching-rows.md.txt - **Plain Text Copy (.txt):** https://million.tools/remove-matching-rows.txt - **API Endpoint:** https://million.tools/api/v1/run/remove-matching-rows (POST, Keyless, 60 req/min) - **SEO Title:** Remove Matching Rows Online | List Subtraction Tool - **Alternative Names:** List Subtraction Tool, Exclude Matching List Rows, subtract one list from another, remove list matches, delete matching lines - **Category:** [Remove](https://million.tools/remove/) - **Application Category:** `UtilitiesApplication` - **Platform:** Web (All modern desktop and mobile browsers, requires JavaScript) - **Price:** Free ($0.00 USD, no registration or sign-up required) - **Live Calculation:** Supported (`Auto / Live` toggle enabled by default) - **Usage Statistics:** 3 uses · 490 views - **Published:** 2026-10-30 - **Last Updated:** 2026-10-30 - **Author:** Egor Volchenko (Developer & Author) ## Key Features - Subtract complete matching rows using a second list - Choose case-sensitive matching - Optionally ignore word order - Preserve the order of retained source rows - Copy each result output - Clear text fields without resetting options ## Parameters & Interface Controls ### Input Parameters & Options - `input_text`: Insert list. - `needle`: Insert rows to delete. - `case_sensivity`: Boolean. Case-sensitive. - `ignore_word_order`: Boolean. Ignore word order. ### Output Fields & Metrics - `result`: Result. - **Metric:** `Rows remaining` - **Metric:** `Rows removed` - **Controls:** `Remove matches`, `Clear`, `Copy`, `Fill test data`, `Auto / Live` ## Interactive Example (Test Vector) **Settings:** - Insert rows to delete: `Banana Pear` **Insert list:** ```text Apple Banana Cherry Pear ``` **Result:** ```text Apple Cherry ``` - **Rows remaining:** `2` - **Rows removed:** `2` ## How to use Remove Matching Rows Use a separate exclusion list to remove complete matching entries from the source. ### List Subtraction Tool 1. **Enter the source:** Paste the source into *Insert list* and put the values to exclude into *Insert rows to delete*, one complete row per value. 2. **Choose the settings:** Use *Case-sensitive* when letter case matters. Select *Ignore word order* when rows with the same words in a different sequence should match. 3. **Run the tool:** Click *Remove matches* to process the current input. 4. **Review the output:** Read *Result* and check *Rows remaining* and *Rows removed*. Only the retained list is returned; the source remains in the input field. 5. **Copy or clear:** Click *Copy* under the output you want to keep. Use *Clear* where shown to clear the text fields; option selections stay as set. For `Apple`, `Banana`, and `Cherry`, enter `Banana` in Insert rows to delete. Result contains `Apple` and `Cherry`. ### Whole-row removal versus substring filtering A removal value must match the entire row under the active case and word-order rules. A row containing apple pie is not removed by the value apple alone. ### Preserve source order and repeated survivors The output follows the source order. Repeated source rows that do not match the exclusion list remain repeated; this operation does not also deduplicate the result. ## Frequently asked questions ### Does a search value remove part of a row? No. The tool removes complete rows that match a removal value. It does not delete individual words from a longer row. ### Will apple remove apple pie? No, because the complete row differs. A substring-based stop word filter is the appropriate workflow for that requirement. ### Are all occurrences of a matching row removed? Yes. Every source row matching an exclusion value is filtered out. ### Does the exclusion list need to follow the source order? No. Each source row is checked against the removal values regardless of their positions. ### Are remaining duplicates removed too? No. Unmatched duplicate rows remain in their original order. Deduplicate separately if that is also required. ## Related Tools - [Remove Extra Spaces](https://million.tools/remove-extra-spaces/): Remove extra spaces and trim whitespace in each row. Remove double spaces, delete empty rows, or remove all spaces while retaining line breaks. - [Remove Empty Lines](https://million.tools/remove-empty-lines/): Remove empty lines with a blank line remover. Delete empty rows and whitespace-only lines while keeping the remaining text in its original order. - [Remove Characters from the Beginning or End](https://million.tools/remove-characters-from-start-or-end/): Remove characters from the beginning or end of each row. Use fixed-length text trimming to remove first characters, last characters, or both. - [Remove Text Before or After a Symbol](https://million.tools/remove-text-before-or-after-character/): Remove text before or after a symbol in each row. Use character-based text removal to trim text by delimiter while keeping rows without the symbol. - [Remove Rows with Stop Words](https://million.tools/remove-stop-words/): Remove rows with stop words using a stop word filter. Filter lines by keyword, review matching and nonmatching rows, and choose case-sensitive matching. ## About the Author **Egor Volchenko** — *Developer & Author* Hi! I’m a WordPress developer with over 10 years of experience. I love Tailwind CSS, clean code, and intuitive interfaces. I’m currently working on million.tools — a service with convenient online tools for everyday tasks. I’m building it from scratch with great attention to detail and user experience. - **Links:** [x.com](https://x.com/egorleet) · [github.com](https://github.com/egorleet) · [t.me](https://t.me/egorleet) · [instagram.com](https://www.instagram.com/egorleet) · [facebook.com](https://www.facebook.com/egorleet/) · [egorleet.blog](https://egorleet.blog/) · [mastodon.social](https://mastodon.social/@egorleet) · [twitch.tv](https://www.twitch.tv/egorvolchenko) · [stackoverflow.com](https://stackoverflow.com/users/31679135/egor-volchenko) · [reddit.com](https://www.reddit.com/user/Vegetable_Window9185/) · [youtube.com](https://youtube.com/@egor-volchenko)