Do you ever have a bunch of data that you need to compile but don’t want to take the time of fussing with Excel spreadsheets or creating tables? In this kind of situation, I’ll create my own data intake using Google’s Free Form creator.  I find it easier to enter the data through a form, plus once I’ve established the field, the table headers automatically generate with no additional set up.  For my demonstration, I’ve compiled easy-to-find bar opinions and rules on use of trade names by law firms. Here are the steps as well as the final product:

Screen Shot 2014-12-16 at 12.28.17 PM


STEP 1 – Go to Google Forms

Once there,  “create free form.” You probably need a Google account because ultimately, the final document will be deposited in your Google Drive.

STEP 2 – Create Fields

Screen Shot 2014-12-16 at 12.30.56 PM


The form will prompt you to create questions, which are effectively the fields/headers for the form. For my form, those include State Bar, Rule/Op. No. (already created), Link and Summary (shown being created)

STEP 3 – Fill Out the Form

Screen Shot 2014-12-16 at 12.32.41 PM


Once the form is completed, it will provide you with a link to the form. Insert the link in your browser bar, and the final form will render – and you can input the date as shown.

After you’ve completed one response, submit another to enter the next row of data

Screen Shot 2014-12-16 at 12.40.40 PM


STEP 4 – View Responses

You can view responses either in your Google Drive or by going back to the original form and clicking on the View Response tab.

Here’s the final result:

I hope that this post – or at least the content of the table was in-FORM-ative.