You can do this through Query.
UPDATE `products` SET status = 1;
but this will turn on all your product and there wont be any way to go back
Example:
('product1', 1),
('product2', 1),
('product3', 1),
('product4', 0),
('product5', 0),
('product6', 0);
after running this query all of the products would turn on:
('product1', 1),
('product2', 1),
('product3', 1),
('product4', 1),
('product5', 1),
('product6', 1);
So if you want to go back to normal after you made your CSV you cant go back to original as all the products are turned ON then you manually have to turn them off.
The other solution is edit your CSV file. you can do it using excel update `status` column values to '1' .