Keyword Job Search Spreadsheet

Getting Started

The Job Search Spreadsheet is an automated Python Application that will search non-PAL websites for internships or full-time jobs and conveniently place them into an Excel document. After typing in a "Job Type" and "Location" when prompted, the automation code lists job title, company name, location, and a link to apply in an Excel Document saved to where the application file is on your computer.

Download

Windows Download: https://1drv.ms/u/s!AqbxXbBaXp0agtljDtKp3lLjuBVZFw?e=0heVjX

Mac Download: https://1drv.ms/u/s!AqbxXbBaXp0agtllWl4k9R3TLVSJsQ?e=59lf5r

Tutorials

Windows:

• Click the download link called "Windows Download" above.
• You will get a redirect notice. But click the OneDrive link to continue to the download.
• A download will begin at the bottom of your screen for "GetJobs.exe". A warning will pop up saying the file is not common. Ignore this and hit the arrow to the right of the warning. Then select "keep".

• Double-click on GetJobs.exe. Or save it to any folder you would like.
• A warning will pop up since it is an unknown application. Ignore this and select "More Info". Then at the bottom select "Run Anyway".

• After pressing ENTER the program will wait for a couple of seconds and create an excel document. The excel document is located where GetJobs.exe is (It is at the top of the application. Notice my script will be at C:\Users\pelts\Downloads\GetJobs.exe.

• Double-click on the excel document called "JobSearch" that was created. This is where all the results will be from your input!

• There you have it! Now just a couple of warnings. If you decide to run the application again make sure the JobSearch document is closed or it will cause an error. Also I highly recommend saving the JobSearch excel document as something else and moving it to save it for later (as it will be overwritten if the program runs again. The document will be created each time in the location of the script even after multiple uses.

Mac:

• Click the download link called "Mac Download" above.
• You will get a redirect notice. But click the OneDrive link to continue to the download.
• A download will begin at the bottom of your screen for "GetJobs.app". A warning may pop up saying the file is not common. Ignore this and select "open".

• If your Mac does not allow allow third party applications to run: click the apple symbol in the top left of your computer and select "System Preferences" then "Security & Privacy". Next select the lock in the bottom left corner and choose "Allow apps downloaded from: App store and identified developers".

• Double click on the GetJobs file that was downloaded and a terminal screen will open. Please give this at least 5 seconds to load.
• A command prompt window will pop up momentarily with the prompt "Enter in desired job type or title:". Type the job you are searching for in and press ENTER.
• Next enter in a location and press ENTER. Note: You do not need a location and can leave the input blank and just press ENTER for all locations. Also capitalization does not matter. Spelling does!
• After pressing ENTER the program will wait for a couple of seconds and create an excel document. The excel document is located where GetJobs.app is. (Sometimes it will save randomly to /Users/(your computer username) in finder. Make sure to search your computer if you cannot find the or see the file right away. It will be saved to your computer).
• Double-click on the excel document called "JobSearch" that was created. This is where all the results will be from your input!
• There you have it! Now just a couple of warnings. If you decide to run the application again make sure the JobSearch document is closed or it will cause an error. Also I highly recommend saving the JobSearch excel document as something else and moving it to save it for later (as it will be overwritten if the program runs again. The document will be created each time in the location of the script even after multiple uses.