title: Reading csv files from colab saved as format csv.gsheet
body: <p>I uploaded a folder with multiple CSV files to google drive.</p>
  <p>When I list the files in the directory they seem to end with a csv.gsheet rather than the expected .CSV. This means pandas doesn't recognize the format.</p>
  <p>This is how I am listing the files:</p>
  <pre><code># Loop all files and get their names in a list
  file_names = []
  
  for filename in os.listdir(folder):
      file_names.append(filename)
  
  file_names
  </code></pre>
  <p>output example:</p>
  <p><strong>Lincoln Park, NJ_sales_history_1638560672.csv.gsheet</strong></p>
  <p>I need a way to read the files using pandas.</p>