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 <[email protected]> >To: [email protected] >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 >[email protected] > > >-- >For unsubscribe instructions e-mail to: [email protected] >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: [email protected] 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
