Save Excel as tab delimited
Posted on 2014-12-03
We have an excel spreadsheet that we save as a tab delimited (.txt) file for subsequent uploading to a web server for loading into a web database table.
I have done this for years; seems to function correctly using a Windows (7 or XP) PC.
A current customer uses a Mac. When they save an Excel sheet as tab delimited, there are no line breaks between the rows so the entire sheet is one massive blob. Of course, the web upload fails.
Is there an option one must use on the Mac to make it work like it does on a PC?
Note I DO NOT have a Mac, I am taking this from the customer, they emailed me the file & it was like I indicated.