Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

CSV Links and Google Sheets Export

December 9th, 2021
Post Cover Image

Importing your query results data into spreadsheets can be a tedious process that involves a lot of manual upkeep and file management. PopSQL's new CSV links allow enterprise customers to pull data directly from PopSQL into their spreadsheet programs like Google Sheets.

Using the Google Sheets IMPORTDATA function and a query's CSV link, Sheets will fetch your query results, import them into the spreadsheet, and refresh the results up to every hour. If you reference the imported results in formulas and charts, they will also update automatically as the results are refreshed. For more instructions on using this feature with Google Sheets, check out our docs on CSV links.

Google Sheets IMPORTDATA

Ready for a modern SQL editor?