Re: [libreoffice-users] How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

Hi :)
For this answer i think after successfully opening 1 test-file renamed from tsv to csv and then 
changing the default from commas to tabs Calc should (hopefully) automatically open tsv's just by 
double-clicking on the tsv files.  

So, Jays answer becomes the set-up process and then normal use is just to open the files as normal 
without having to rename any of them.  

As usual i think Andreas' answer, the database route, might well be a technically better answer and 
if you can follow it you gain far more flexibility in using the data contained in the tsv.  The 
idea of using a database is a bit scary because 
1.  people make such a fuss about it and 
2.  there is not much documentation about how to set-up so that it works well (but Andreas is 
already helping you with targeted and highly specific advice about that and that type of advice 
beats generic documentation anyway).  

Regards from
Tom :)  





> ________________________________
> From: Jay Lozier <jslozier@gmail.com>
> To: users@global.libreoffice.org 
> Sent: Friday, 14 September 2012, 14:08
> Subject: Re: [libreoffice-users] How do I open a file with a .tsv extension as a .csv file on a 
> Mac OSX (Lion?) using OpenOffice Calc.
>
> Richard
>
> On 09/14/2012 06:25 AM, Richard Quadling wrote:
> > Hello.
> >
> > I'm new to using a Mac and some of the things I can do in Windows I'm
> > unable to even work out the question for on a Mac, so please bear with me.
> >
> > The files are generated from an automated system, several hundred a day and
> > have a .tsv extension (can't change it for every file). The files are UTF-8
> > encoded text files with TAB separated content.
> >
> > I need to be able to double click the file and have it open in Libre Office
> > Calc. Even if it has to ask me to choose the delimiter to process it with.
> >
> > I've no idea if this is possible. On Windows, I'd associate .tsv with Excel
> > and all would be "just done".
> >
> > I can't even find Calc for LibreOffice, only the LibreOffice.app in my
> > Applications directory - again, this may be me - I'm VERY VERY new to Mac
> > and the differences are sometimes confounding.
> >
> > If I try to open Libre Office first and then open a Spreadsheet file, the
> > open file dialogue doesn't allow me to pick the .tsv files. They are all
> > greyed out.
> >
> > Really stuck. Renaming the files first, editing the content as I need, and
> > then reversing the rename takes forever on a mac - OK I know this bit is
> > me, I'm so used to doing everything from the keyboard and having to
> > constantly go to the mouse to do things just beeps me off a bit.
> >
> > If I get Finder to open .tsv files all the time, they open in the word
> > processor part.
> >
> > Any useful suggestions would be brilliant!
> >
> > Thank you.
> >
> > Richard Quadling.
> As an experiment, change the extension on one of a copy of a files from
> *.tsv to *.csv. From your description, it sounds like *.tsv is a tab
> delimited text file and *.csv nominally is comma delimited text file.
>
> When importing into Calc make sure to highlight Tab as the delimiter not
> comma, Calc will remember the last delimiter used.
>
> If this is successful there are two possible options: change the default
> settings of the program that generated the file or determine an "easy"
> way to convert the *.tsv files to *.csv files.lo
>
> -- 
> Jay Lozier
> jslozier@gmail.com
>
>
> -- 
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted