Ask Your Question

best way to make a tab delimited .txt file?

asked 2019-09-02 00:45:02 +0200

clos911 gravatar image

updated 2019-09-02 00:45:29 +0200

I am trying to import information from my calc spreadsheet into a CAD program, through a .txt file..

It requires: " tab-delimited text, with the value information in the rows and the field information in the columns"

I tries to paste my spreadsheet into Writer but the tabs did not follow and the page was not wide enough for the columns (30+ columns)...

To make due I copied the columns of my spreadsheet then did an unformatted paste with Tab selected as the separator into a new calc spreadsheet, then copied those unformmated columns and pasted into window's notepad, with that I was able to do my import..

of course I would like to use LO instead,

any thoughts on a better way to do this?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-09-02 01:48:03 +0200

Ratslinger gravatar image


  • From Calc menu File->SaveAs....

  • Then in dropdown box just above Cancel & Save buttons, select Text CSV (.csv).

  • Give file name & where to be saved.

  • Next click Save button.

  • Next dialog, click Use Text CSV Format.

  • Final dialog is where you can set the delimiter.

  • After saving, you can change the extension from .csv to .txt if needed.

edit flag offensive delete link more


thank you!

clos911 gravatar imageclos911 ( 2019-09-02 02:46:13 +0200 )edit

answered 2019-09-02 01:50:36 +0200

robleyd gravatar image

File | Save As

Choose Text CSV (.csv) in the Filter selections and check the box Edit filter settings If you want the file extension to be .txt, uncheck Automatically select filename extension (.csv) and add the extension to the filename you are going to save to.

Click on Save and choose the text delimiter you need from the options available. Click OK - done

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-02 00:45:02 +0200

Seen: 904 times

Last updated: Sep 02 '19