Export ONE column from spreadsheet

larowc

unread,

Mar 9, 2014, 3:28:10 PM3/9/14

to k12ap...@googlegroups.com

Is it possible to export a single column from a Google spreadsheet?

If so, what formats is it possible to export to?

Some spreadsheets are cumbersome to read, and I have some teachers who

would like to export just one or two columns. Is it possible?

Thank you,

Carol LaRow

Randy Damewood

unread,

Mar 9, 2014, 4:28:11 PM3/9/14

to larowc, Google Apps Group

I would just copy the 2 columns to a separate worksheet and then download as a csv.

--
--
You received this message because you are subscribed to the Google
Groups "Google Apps K12 Technical Forum" group.
To post to this group, send email to k12ap...@googlegroups.com
To unsubscribe from this group, send email to
k12appstech...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/k12appstech?hl=en?hl=en

---
You received this message because you are subscribed to the Google Groups "Google Apps K12 Technical Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to k12appstech...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Randy Damewood

Director of Technology

Coffee County Schools

931-222-1055

@randydamewood

Google+

Mike Lawrence

unread,

Mar 9, 2014, 5:21:44 PM3/9/14

to Randy Damewood, larowc, Google Apps Group

Or copy, paste into the spreadsheet software of your choice.

Or, depending on what you are attempting to accomplish, you can embed just a range of cells on a webpage...

M

--
• • •
Mike Lawrence
Executive Director
Computer-Using Educators (CUE)
www.cue.org
925.478.3461
• • •

Member, ISTE Board of Directors | www.iste.org

Director, California Student Media Festival | www.mediafestival.org

Founder, Leading Edge Certification | www.leadingedgecertification.org

Co-Executive Producer, Infinite Thinking Machine | www.infinitethinking.org

• • •

Joel Lowsky

unread,

Mar 10, 2014, 1:17:40 PM3/10/14

to larowc, K12 Google Apps Tech List

I would use formulas to pull in the data you want into either another sheet in the same spreadsheet (easy formulas) to to another spreadsheet altogether (a little more complicated). The first method will work really well ... depending on what you need to do with the data, you could publish-to-the-web just the 2nd sheet with the formulas and make it available to whomever you want.

The advantage to using formulas is that once you set it up, it will continuously update as records are added via form submissions.