Opening tab delimited file in openoffice

Burley holds a Bachelor of Science in political science from Arizona State and a Master of Science in computer information systems from the University of Phoenix. By Matthew Burley. References OpenOffice: Saving Spreadsheets. I was seeking a way to have excel recognize.

All of these methods require a manual splitting of the columns. The closest method is Jim Gordon's in which I could create a script to rename all. But that still is an extra step that feels unnecessary. There is an existing feature request specific to support for tsv files in Excel. Please vote for it. I am using Excel for Mac version This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse.

By Tim Kloos December 10th, I recently wanted to create a tab delimited separated text file using Open Office Calc. Although this task is not one I perform often, it is something that can come up from time to time.

Really, performing this task should be fairly straightforward process. I was a bit suprised though when I found out that getting this done within OpenOffice wasn't as intuitive as I expected it to be. Hopefully these steps will help someone find the right answer quickly.

Some feeds use comma as the 'delimiter' or 'separator'. Open Excel and close the blank workbook. Drag and drop the file onto the dark gray working area of Excel.

Excel will automatically detect the format and load the spreadsheet instantly. If this doesn't work, use the full instructions below. Our system produces feeds with UTF-8 character encoding.