l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2010 Jan 28 07:45

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
[vox-tech] Exporting multiple sheets to CSV?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[vox-tech] Exporting multiple sheets to CSV?

I've got an ODS spreadsheet file that I'm maintaining with OpenOffice.org Calc.
It contains multiple sheets, which I'd like to export each as separate CSV
text files (tab-delimited text, in my case).

Unfortunately, the "Save As..." option, when I choose CSV as the output type,
only saves the current sheet.  (And brings up that: "Warning: only saved the
current sheet" (paraphrased) dialog.)

_Is_ there a way to dump every sheet in an ODS file into individual CSVs,
without going doing a bunch of manual labor?  (Switch to first sheet, save as;
switch to second sheet, save as; switch to third sheet, save as; ad infinitum.)

Aside from it being easier to manage all the sheets at once (rather than
managing them all as separate files), they also do a lot of cross-referencing
of each other.  So splitting the ODS up into individual files is something
I'd like to avoid.

Thanks in advance,

Sent from my computer
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
EDGE Tech Corp.
For donating some give-aways for our meetings.