Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: travelin cat
1) Copying all the cells
2) Opening a new text file - using notepad
3) Paste the lot into notepad
On my Mac I do this and the first Excel row is OK but after that I have new line characters causing line breaks. This causes my products import to fail. It is as if word wrap was on or I had set the column width in Outlook (you know how emails look when a column width is set.
Thanks for your help.
(FYI, Windows uses both: CR then LF. This sometimes ends up looking like "extra" line breaks.)
As the other poster mentioned, BBEdit is a great tool to fix this. Should be just: open the file and save it, choosing Options...Line Breaks...<desired platform>.
(Just ignore the Excel message that all formatting will be lost. You know this - you want this. With these silly Excel alerts, just always remember Excel is a MS product so it always asks you if you really want to do what you want to do. :P)