CSV Row Filter
Keep CSV rows that match a selected rule
CSV Row Filter — what it does
Keep only the rows you want by choosing a column, a rule and a value. Rules cover contains, equals, starts with, ends with, greater than and less than, with an optional case-sensitive match, so text and numeric filtering are both handled in one pass over the file.
When this tool helps
- Extracting a single region, status or customer from a large export before sharing it.
- Pulling every transaction above a threshold for review or approval.
- Isolating rows whose reference code starts with a particular prefix.
How to use it
- Choose the CSV file.
- Select the column to filter on.
- Pick a rule and enter the comparison value.
- Process and download the filtered CSV.
Accuracy, limits, and good practice
- Greater than and less than compare numerically, so a column stored with currency symbols or thousands separators will not filter as expected.
- Case-sensitive matching is off by default, which is usually right for user-entered text and wrong for codes where case carries meaning.
- Contains is the most forgiving rule when values have inconsistent spacing or punctuation around the term you are searching for.
Frequently asked questions
Can I apply two filters at once?
Run the tool twice, feeding the output of the first pass into the second. Successive filters combine as an AND condition.
How do I keep rows that do not match?
Invert the logic where you can — for example use starts with on the values you want — or filter, then diff against the original to get the remainder.
Does the header row survive filtering?
Yes. The header is always written to the output, even when no data rows match the rule.
Related tools on this site
- Excel to CSV — Export one worksheet or every worksheet as CSV files
- JSON to Excel — Turn JSON arrays into an XLSX worksheet with optional flattening
- CSV Group & Aggregate — Group rows and calculate sum, average, count, min, or max
Everything above runs inside this page. CSV Row Filter needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 資料篩選能做什麼
選定欄位、規則與比較值，就能只保留需要的資料列。規則涵蓋包含、等於、開頭為、結尾為、大於與小於，並可選擇是否區分大小寫，因此文字與數值篩選都能在同一次處理中完成。
什麼時候用得上
- 在分享大型匯出檔之前，先抽出單一地區、狀態或客戶的資料。
- 撈出所有超過門檻的交易，供覆核或簽核。
- 篩出參考代碼以特定前綴開頭的資料列。
使用步驟
- 選擇 CSV 檔案。
- 選定要篩選的欄位。
- 選擇規則並輸入比較值。
- 執行處理並下載篩選後的 CSV。
精確度、限制與實務建議
- 大於與小於是數值比較，若欄位存有貨幣符號或千分位逗號，篩選結果會不如預期。
- 預設不區分大小寫，這對使用者輸入的文字通常正確，但對大小寫具有意義的代碼就不適用。
- 當值的前後空白或標點不一致時，「包含」是最寬容、也最不容易漏掉資料的規則。
常見問題
可以同時套用兩個條件嗎？
把第一次的輸出再跑第二次即可，連續篩選等同於 AND 條件。
怎麼保留「不符合」的資料列？
盡量把邏輯反過來寫（例如改用「開頭為」指定要留的值），或先篩選再與原檔比對差異取得其餘資料。
篩選後標題列還在嗎？
在。即使沒有任何資料列符合規則，標題也一定會寫入輸出。
本站相關工具
- Excel 轉 CSV — 將指定工作表或全部工作表匯出為 CSV
- JSON 轉 Excel — 將 JSON 陣列轉為 XLSX，並可攤平巢狀資料
- CSV 分組彙總 — 依欄位分組並計算加總、平均、計數、最小或最大值
以上步驟全部在這個頁面內完成，CSV 資料篩選 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。