A few questions

Colleges and Universities A-Z Columbia University
1
  1. Does my GPA need to be 4.0 or above weighted to even be considered?
  2. Do I need to take the SAT 2?
  3. Will there be an interview?
  4. How can I get an interview if there isn't?
  5. Will the fact that I went to public school hinder my chances?
  6. Will the fact that I live in the 43rd worst state education wise hinder my chances?
  7. If I want to prove proficiency or fluency in another language (as that's a big chunk of what I'm gearing my application around) will I have to take test confirming that I'm a B2 speaker?
  8. How significant is Freshman year grades to Columbia applications?
  9. Will the fact that I'm probably going to take less than 7 periods during senior year hinder my chances? (Most, if not all AP)
  10. What was your fastest mile time?
2
  1. Weighted GPA is only important for internal HS purposes; Columbia looks at UW GPA primarily.
  2. It's strongly recommended if you are not lower socioeconomic status
  3. Maybe. Not all applicants get an interview. It depends on how many interviewers are available. 4.You don't.If you are not offered one, you don't get one.
  4. No
  5. No
  6. Columbia will not ask you to"prove"proficiency" for admissions. If you are admitted and want to use the language to place out of the language requirement, there are internal exams.
  7. They are important. Perhaps less so if there is a strong upward trend.
  8. No
  9. Not relevant.
3
  1. No! It should be as high as possible, but I didn't have a 4.0 GPA and still got in
  2. More than one, if financially possible, and there are fee waivers
  3. I didn't have one and got in
  4. You can't; Columbia asks that applicants not request interviews
  5. Not at all
  6. No, as you have less competition than someone from, say, California or New Jersey
  7. It's not required, but an SAT 2 or AP in the language would be useful to back up your claims
  8. Significant. They should be high unless you have a reason like illness
  9. It depends on what's normal for your school. My school's norm was 5
  10. N/A
4

According to their website, you do not need to worry about SAT Subject Tests (SAT II)
“No, the SAT Subject Test is not required, but Columbia will accept scores from the exams if you choose to submit them. You will not be at a disadvantage should you choose not to take the tests or submit the scores to Columbia.”