Automate simple spreadsheets
Im not very savvy when it comes to Programming. I have done some basic powershell but that’s about it.
I was wondering if there was a way to automate this. I will give a workflow, the task is simple, im just not sure where to start. The purpose is to create a contact list out of data we export from our records software.
I get a CSV txt document. Open in excel and use “Text to columns” to create a spreadsheet out of data Remove first two and last two columns Replace top row with updated values Remove any rows that have no email or phone number. Save new excel spreadsheet for import into website.
Any help at all would be greatly appreciated.