7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

How Do I Do This? (I NEED HELP)

by Mukul Verma
6 replies
There must be something that exists that can do this.

Input
1. A template with a bunch of fields I want to fill in.
2. A excel spreadsheet (cvs file) with the information that needs to be filled it

Lets say that the spreadsheet had 1,000 lines of information

Output
- A single document for each line with that exact template filled with the information.

In the end I have 1000 documents of the templated filled with each line from the speadsheet

Anyone know how to do this?
#cvs #database #spreadsheet
  • Profile picture of the author BigDaddys101
    Google sites offers free hosting and site creation. But more importantly a widget to manipulate CSV files. usually you do need to understand a little bit of java to get the widget to work exactly how you want it to.

    Being a PHP and MySQL programmer of course I love my Data Bases but Googles functionality is actually pretty awesome at manipulating a CSV (or flat file) almost as if it were a DB.

    Almost all CMS's will do what you are looking for if you can upload your CSV into the Database correctly
    Signature
    {{ DiscussionBoard.errors[2325135].message }}
  • Profile picture of the author Mukul Verma
    Thanks, you got a link on google site where to go?
    Signature
    {{ DiscussionBoard.errors[2325171].message }}
    • Profile picture of the author txconx
      Originally Posted by Mukul Verma View Post

      Thanks, you got a link on google site where to go?
      From the Google homepage, go to settings (upper left corner of the browser window). Sign in and you'll see the available services listed, including Docs.
      {{ DiscussionBoard.errors[2325335].message }}
  • Profile picture of the author timpears
    Sounds to me that what you are looking for is Mail Merge in MS Word. I have used that to create dynamic documents (form letters with name and address) to send out for mailing. It can be used to create any number of document types as you can use a spread sheet, or data base etc. to hold the data to fill in the form fields. Takes a little bit of getting used to in order to use it, but one you get the hang of it, it works great.
    Signature

    Tim Pears

    {{ DiscussionBoard.errors[2325359].message }}
  • Profile picture of the author BigDaddys101
    Mukul

    First I have to apologize for the long response time, being kind of new to this forum I still haven't figured the ins and outs. Not to mention Warrior Forum doesn't make it as easy as some other sites to follow your conversations or even search for un answered posts in that matter.

    Google Gadgets For Your Webpage

    Here is the Google Gadgets that deal with CSV but also search for spreadsheet or even exactly what you are trying to do if what you want is not right there
    Signature
    {{ DiscussionBoard.errors[2412698].message }}
    • Profile picture of the author Mukul Verma
      Originally Posted by BigDaddys101 View Post

      Mukul

      First I have to apologize for the long response time, being kind of new to this forum I still haven't figured the ins and outs. Not to mention Warrior Forum doesn't make it as easy as some other sites to follow your conversations or even search for un answered posts in that matter.

      Google Gadgets For Your Webpage

      Here is the Google Gadgets that deal with CSV but also search for spreadsheet or even exactly what you are trying to do if what you want is not right there
      Thank you.

      How I find myself on Warrior Forum. You can be notified on threads that you have comments on (or subscribe if you have not). Also I use google alerts, so if my name is mentioned elsewhere, I know about it.

      Cheers,
      Mukul
      Signature
      {{ DiscussionBoard.errors[2424939].message }}

Trending Topics