Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
  • I am generating a .CSV file with an application.
  • I then upload the .CSV file to Google Docs, which creates a Google Docs Spreadsheet which is "plain and white".
  • I then have to manually format the .CSV file with colors and bold-headers, etc.

Is there a way for me to create a Google Doc Spreadsheet and then say "upload this CSV file and use this spreadsheet as a template"?

share|improve this question
add comment

1 Answer

You can use the importData("URL") function to achieve your goal.

  1. Upload the CSV file somewhere that you can have public access to (I suggest Dropbox or Ge.tt) and you'll endup with something like http://example.com/foo.csv
  2. Go the the first cell that you want to insert your data and write: =importData("http://example.com/foo.csv")
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.