title: How do I extract rows from a PDF file into a csv file?
body: <p>I want to get a list of all the colleges in USA from this <a href="https://studyinthestates.dhs.gov/assets/certified-school-list-9-16-2015.pdf" rel="nofollow">PDF file</a> and put it into a CSV file. I will then import the CSV file into SQL server (so that I can run queries easily). </p>
  
  <p>I tried several online pdf to csv converters and Java based pdf to CSV tutorials. Nothing worked. I have spent 6-8 hours today for this and failed. My csv files were messed up and I had lot of nulls in my DB when i imported the csv.
  I even tried searching for a DHS api which could give me this info but found none.</p>
  
  <p>Can someone please help me to extract the colleges exactly like they are shown in the pdf file ? </p>
  
  <p><strong>PS:</strong> You can see all the colleges using <a href="https://studyinthestates.dhs.gov/school-search?field_school_name_value=&amp;field_location_city_value=&amp;field_location_state_value=All&amp;field_education_level_value=All" rel="nofollow">this url</a> also. BUT, you have to scroll manually to extract all the results. It will take too long and data will not be in format given in pdf file.</p>