Results 1 to 9 of 9
  1. #1
    Excel 2008 for mac question

    Member Since
    Aug 17, 2010
    Posts
    5
    Excel 2008 for mac question
    Hello,
    I'm in the process of moving from a PC to an iMac. I upload an Excel file to my shopping cart in tab delimited format. Worked fine on the PC. On the mac it's not putting an end of line character in the tab delim. file. Comes across as one long line instead of almost 2000 lines. Anyone know how to get the CR or what ever other symbol is needed at the end of each line?

    Thanks in advance for any advice.

  2. #2
    Excel 2008 for mac question
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,284
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    Upload an Excel file to your shopping cart? Sounds like you're buying it. Are you saying that you're trying to open an Excel file from Windows on your Mac using Excel from Office 2008? And the file was saved as tab delimited?

    Tab delimited format displays like plain text. There's no guaranty of compatibility when saving that way. As a matter of fact, delimited format is generally used when there is no compatibility between programs. Which is one reason many banks use it as a download option for their users to fill in accounts. Is there any reason it can't be saved as a normal Excel file?

    Regards.

  3. #3
    Excel 2008 for mac question

    Member Since
    Aug 17, 2010
    Posts
    5
    No, it's my shopping cart and the database file I'm trying to upload contains all the products on my site. The cart uses it as my product database. It has to be uploaded in some kind of delimited format. It can be tab, or , or | but not as an Excel file. My Windows Excel sent it correctly. When I saved it as a tab delimited file on the mac I got the problem Got the same problem when I tried a , delimited file. Looked back at the save form and didn't see any variables that could be changed.

  4. #4
    Excel 2008 for mac question
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,284
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    OK, I understand what you're trying to do, but the answer is going to be the same. It's a common problem with CSV and delimited files especially when moving them between operating systems. Best I can suggest is to experiment with the file format to see if it will you can get it to save correctly on your Mac. Otherwise you might be stuck with manually placing the EOL marker at the end of each line in order to break it down to the right format.

    Regards.

  5. #5
    Excel 2008 for mac question

    Member Since
    Aug 17, 2010
    Posts
    5
    OK. It would be easy to add the EOL marker at the end of each line in my file. But I have a dumb question...what is the EOL marker?

    Thanks!

  6. #6
    Excel 2008 for mac question
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,284
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    EOL is what's known as a carriage return. You've got a lot of work ahead of you if that file is actually a 2000 line data base. Hitting return that many times is no fun. You need to find a better way of uploading that file to the shopping cart. How about MS Office 2008 for the Mac? Do you have a copy? If not, you can try the free Open Office for the Mac. File compatible with MS Office for Win and Mac.

    Regards.

  7. #7
    Excel 2008 for mac question

    Member Since
    Aug 17, 2010
    Posts
    5
    Yes, I have MS Office 2008 for the mac. That's the Excel program that I keep the file in, saving as a tab delimited before uploading. If it would see the CR I could enter it in my last column. It's just a letter N so N{CR} would not be hard to copy/past down the line. If it would go into the tab delimited file OK.

    Thanks for your help. I appreciate it!

    I tried putting a command return after the N in the last column. Didn't work. I'm new to the mac...I'm assuming (that can get me into trouble) that command return would be the same as control return in windows.

  8. #8
    Excel 2008 for mac question

    Member Since
    Aug 17, 2010
    Posts
    5
    Problem solved! Excel for mac Office 2008 doesn't save as a tab delimited file well. Saved file as "Windows formatted text file". Worked fine then.

    Thanks for all the help!

  9. #9
    Excel 2008 for mac question
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,284
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    Thanks for posting back. We both learned something...

    Regards.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel for Mac 2008 and Yosemite
    By benneal in forum OS X - Operating System
    Replies: 3
    Last Post: 11-11-2014, 10:13 AM
  2. New User- Complex Excel for Mac 2008
    By ws242 in forum OS X - Apps and Games
    Replies: 2
    Last Post: 03-07-2011, 07:17 PM
  3. Excel 2008 For Mac
    By khullar in forum OS X - Apps and Games
    Replies: 1
    Last Post: 01-27-2010, 01:24 PM
  4. Excel 2008 (For Mac)
    By Mark McLean in forum OS X - Apps and Games
    Replies: 2
    Last Post: 01-11-2010, 12:51 PM
  5. Office Mac 2008 Excel Power User Question
    By Maggie's Farm in forum Switcher Hangout
    Replies: 0
    Last Post: 04-03-2008, 07:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •