Help Center / Integrations

Export a Google Sheets document as CSV file

This tutorial will guide you through the process of converting a single sheet from a Google Sheets document into a CSV file.

Step 1: Open the Google Sheets Document

  1. Visit Google Sheets and sign in with your Google account if you haven't already.
  2. Open the Google Sheets document containing the sheet you want to convert to CSV.

Step 2: Select the Sheet

  1. At the bottom of the Google Sheets document, you will see tabs representing each sheet within the document.
  2. Click on the tab of the sheet you want to convert to CSV. This will make it the active sheet.

Step 3: Download the Sheet as a CSV File

  1. Click on File in the top-left corner of the Google Sheets interface.
  2. Hover your cursor over the Download option in the dropdown menu.
  3. From the list of available file formats, click on Comma-separated values (.csv, current sheet).

This will download the active sheet as a CSV file to your computer.

Step 4: Obtain the Publicly Accessible URL (Optional)

If you need a publicly accessible URL for the CSV file, follow these steps:

  1. Upload the CSV file to a file-sharing platform (e.g., Google Drive, Dropbox).
  2. Make the file publicly accessible by adjusting the sharing settings. For Google Drive:
  3. Right-click on the file and click Share.
  4. Click on Change to anyone with the link.
  5. Make sure the permission is set to Viewer.
  6. Copy the link provided.
  7. Use this link in any application that requires a publicly accessible CSV file URL.

Now you have successfully converted a single sheet from a Google Sheets document into a CSV file and obtained a publicly accessible URL (if needed).



Was this article helpful?

Thank you for your feedback!

Related articles


Categories

FAQ