Filter spreadsheet test data

[kazurayam]

This is a F.A.Q in this forum. In short, there is no built-in feature to “Filter spreadsheet test data”. But you can invent your way. Please search this forum for relevant topics. You will find some. For example,

Apply Filter to Header before reading CSV

Hi, I have the CSV with nearly 20 fields and has nearly 6k records. The Main fields are ID and Status. My task is to have filter for all single column and then fetch the data after applying filter. As I have 6k records fetching each field by separator and checking the column value doesn’t work as it is time consuming. If column ‘Status’ is ‘Scheduled’ need to fetch the ‘ID’ corresponding to that ‘Status’ Pls suggest way to apply filter to CSV(As we do for Excel) and then fetch the ID when …