title: Loading a generic Google Spreadsheet in Pandas
body: <p>When I try to load a Google Spreadsheet in pandas </p>
  
  <pre><code>from StringIO import StringIO  
  import requests
  r = requests.get('https://docs.google.com/spreadsheet/ccc?key=&lt;some_long_code&gt;&amp;output=csv')
  data = r.content
  df = pd.read_csv(StringIO(data), index_col=0)
  </code></pre>
  
  <p>I get the following:</p>
  
  <pre><code>CParserError: Error tokenizing data. C error: Expected 1316 fields in line 73, saw 1386
  </code></pre>
  
  <p>Why? I would think that one could identify the spreadsheet set of rows and columns with data and use the spreadsheets rows and columns as the dataframe index and columns respectively (with NaN for anything empty). Why does it fail?</p>