Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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 <>
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.


On 09/14/2012 06:25 AM, Richard Quadling wrote:

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 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

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.