csvlint.io icon indicating copy to clipboard operation
csvlint.io copied to clipboard

Published 20 hours ago • verified publisher icon Data-Liberation-Front

Support for Googlesheets

Open Stephen-Gates opened this issue 8 years ago • 2 comments

I have created a list of Australian Open Data Portals in Google Sheets.

By using /export?format=csv at the end of the sharing link, you can download a CSV file instead of launching the Google Sheet.

  • Sheet link: https://docs.google.com/spreadsheets/d/1GrTr1msgUJ_Nx1boZ4d2y2tFPWaWtTNfmCMm2C5NdcQ/edit?usp=sharing
  • CSV link: https://docs.google.com/spreadsheets/d/1GrTr1msgUJ_Nx1boZ4d2y2tFPWaWtTNfmCMm2C5NdcQ/export?format=csv

It may be worth sharing this tip in the /About page so people know that Google Sheets is a publishing option for CSV and that it works with CSVLint.

Stephen-Gates avatar Mar 08 '16 01:03 Stephen-Gates

Inspired by @Floppy convincing GitHub to serve .CSV files correctly as mentioned in this video (4:40min in). Perhaps we could get Google to do the same?

That way I can have a valid CSV badge instead of a CSV warnings badge.

Stephen-Gates avatar Mar 08 '16 04:03 Stephen-Gates

Ooh, nice, they validate (almost) correctly? That's great. We should add it to the documentation. Nice one!

Floppy avatar Mar 08 '16 13:03 Floppy