Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
  • 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

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

Copy your template over the plain vanilla with Paste special, Paste format only.

share|improve this answer

Your Answer


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.