I need an .exe or something online very basic and simple that does the following:
1. allows me to input .csv files into it
2. remove certain columns and rows based on name I specify (I only need 5 columns from each .csv)
3. save the new/edited .csv as a text .csv file in location I can specify locally
Here's an example:
Say I have 5,000 .csv's. I need data from certain columns but the rest of the columns need to be deleted. Then the 1st row of the .csv needs to be deleted basically then saved as a new one... The input .csv files may have a different number of columns and rows but the column names I need are global/universal and 1st row is the same too.