how do I convert an .xlsx spreadsheet to a txt(tab delimited) format

Question

Level 1

4 points

I exported my contact list from Bento to an .xlsx spreadsheet in Numbers 3.6.1

In order to import this spreadsheet into SendOutCards, they require that it be saved as a txt (tab delimited) document.

How do I do this with Numbers 3.6.1?

MacBook Pro (13-inch Late 2011), OS X El Capitan (10.11.1)

Posted on Dec 14, 2015 1:33 PM

Reply

Answer 1

Top-ranking reply

Level 8

37,622 points

If you are sure you need tab-delimited (as opposed to comma-separated) then the easiest way may be this:

With Numbers open, select all the cells in the table you wish to export.
Command-c to copy the values to the clipboard.
Open TextEdit and in TextEdit Preferences make sure Format is set to 'Plain Text'.
Click in a new TextEdit document and command-v to paste.
Save the TextEdit document with the extension that SendOutCards requires.

SG

Reply