Or use Sqlcmd with [-e echo input] and [-o outputfile] options
p.s. Don't forget to batch the commands with GO

What is the format of your destination column, the input from Excel is Unicode, if your output is varchar then you will have truncation issues.

For a test a...

Not sure if the best solution

WITH cte AS (
 SELECT ROW_NUMBER() OVER (order by Value desc) Sequence_no,
   userid,
   Value,
   DENSE_RANK() over (order by Value desc) as Rank

Using a Tally table of integers

SET DATEFORMAT DMY;
WITH cte (CertNo,LodgeDate,MatDate,Term,Amount) AS (
   SELECT CertNo,LodgeDate,MatDate,Term,Amount
   FROM (VALUES (1,CAST('11/02/2017' as date),CAST('11/02/2018' as date),365,5000),
       (2,CAST('15/06/2017' as date),CAST('14/09/2017' as date),91,6500),

TOP allows an expression sin SQL 2008

TOP(