PowerShell Script for excel/CSV file apply the filter on data


I have a data in excel file and which contain data(Columns) like user name, county, Date, Primary Clicked(True/False), Acknowledgement(T/P) Reported (T/P), Business Units, Upload date(Based on location wise), Template name.

Form this, we have to apply the filets based our requirement.

As of now i am doing filters manually and it takes around 2 hr to complete the process by applying filters manual.

I am looking some automation with the help of power shell script to read the data (around 10K rows) and provide the values.


Compétences : Powershell, Excel

en voir plus : script import csv file database, script modify csv file, php script upload csv file mysql, powershell script to read csv file and write output, powershell import-csv select row, powershell import-csv select column, powershell import-csv | where, powershell import-csv foreach, powershell script to read and write csv file, powershell sort csv by multiple columns, powershell output to csv columns, perl script insert csv file data mysql, start excel csv file, csv file specification inventory data, asp script insert csv file, bash script parse csv file, excel csv file format, read excel csv file plsql, java script reads csv file, script upload csv file server web http

Concernant l'employeur :
( 0 commentaires ) Kalamazoo, United States

Nº du projet : #27861691

Décerné à:


HI, i read ur description. I have done such kind of large data handling in past. We can go via this approach but it is advisable to use python for this. the solution will be clean and simple. I am fine with both the me Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% INR en 3 jours
(0 Commentaires)

9 freelances font une offre moyenne de 1178 ₹ pour ce travail


Hello, I am a powershell and csv expert and i can help you make script quickly Kindly ping me for further discussion Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(61 Commentaires)

Hi. I have written many automation PowerShell scripts also apps for formatting files including Excel, CSV. Can format any Excel, CSV templates. Ready to write your project. Will complete within 1 day

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(68 Commentaires)

Hi there, I can make a software /app to filter Excel /csv file data. Any non technical person can easily run this app by double click. I have some questions regarding project please let me know when are you avail Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(15 Commentaires)

Hi, I work doing automations with powershell. I would like to participate in your project. Send me to chat to share details Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(7 Commentaires)

Hey, i am multitasking person, i am good on these fields (Excel, word,Data Entry, Software Development) and i do value of time. so, i do complete my work on time with better quality.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)

I understood the requirement of the assignment. i can convert the fields and data filterable format. The requirement is tailor made for me and would be comfortable in completing the job as per the requirement. Do sha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)

Hello I have several years of professional experience in PowerShell and have completed several projects that involve scripting tasks in Excel. I would be happy to assist with your project.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)

I've been a professional system engineer for the past 8 years and I'm using powershell daily, I can easily and quickly help you with this. What do you mean with filters? If there is x value in column b then something Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)