title: Copy a range from a csv file to a Google Spreadsheet
body: <p>I am building a Google Spreadsheet that for various reasons (mostly to do with me being MUCH better with Excel than Google) will need to import a range of cells from a CSV file and copy them into my Google Spreadsheet.</p>
  
  <ul>
  <li>The <strong>csv file I am copying from</strong> is called 'WorkFlowDataStore.csv
  and I want to copy cells A1:Y1001....it is stored in the same google
  drive folder as my spreadsheet</li>
  <li>The <strong>spreadsheet I am copying to</strong> is called 'WorkCalendar', and I want to paste the information into cell A1 on the sheet 'WorkCal'.</li>
  </ul>
  
  <p>I am reasonably competent using copy-and-paste to cobble together some VBA, but know next to nothing about Google scripts.</p>
  
  <p>Things I have already tried include:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/9737354/how-to-write-to-a-google-spreadsheet-from-excel-2003-vba">How to write to a &quot;Google Spreadsheet&quot; from Excel 2003 VBA</a> ....this half-works, but all I see is a load of wingdings-style gobbledegook</li>
  <li><a href="https://developers.google.com/apps-script/articles/docslist_tutorial" rel="nofollow noreferrer">https://developers.google.com/apps-script/articles/docslist_tutorial</a> ...but this is not really doing what I want</li>
  <li>The 'importData' formula...but this gives me a #REF error telling me I need to create 1000 more columns</li>
  </ul>
  
  <p>Any help you can give would be greatly appreciated...I am frustrated as this would take me 30 seconds to do in Excel.</p>
  
  <p>Thanks,</p>
  
  <p>Jon</p>