I recently bought a new computer. With the purchase of my new computer I no longer have Microsoft Office for Mac on my computer. All I have to use is Pages, Numbers and Keynote. I learned how to create an Excel file and save it as a tab delimited doc and then use if as a data source for a data merge. I tried the same steps using Numbers but it doesn't work so nicely. Can you use Numbers instead of Excel or am i just up a creek without a paddle since I no longer have the Microsoft software?
It could be that Pages is saving extra data along with what you assume is a normal tab-delimited text file. Try opening one up in a text editor and comparing it to a sample from Word (if you have one from before, that is).
I don't know anything about Pages, but there are other programs you could try that wouldn't cost as much as Office, if that's the issue. A Google search will turn up some options there. By the way, is there a reason your copy of Office won't work on the new computer?
I will have to look into other text editors I guess. No reason my copy of Office won't work on my new computer...I just gave my old computer to someone else and let them have Office and I only had one license for it. I thought since Pages, Numbers and Keynote were free with the new OS for mac then I would just try to use them, but if it turns out that I need Office I may just have to buy it.
You should be able to use Open Office without issue for this - it's an open source application very similar to Microsoft Office. This is what I use all the time for data merging and opening Excel files. Just be sure to save the file as either .txt or .csv.
Bummer, so we are kind of forced to use word and excel documents. I just tried to place a pages document into a text frame into ID and couldn't do that either. Seems the Apple productivity apps don't work at all with Adobe. or as Rik mentioned open office. Thanks for all your help.
I just tried to place a pages document into a text frame into ID and couldn't do that either.
Although it should be expected that if a program can output something like a text file, that text file should work with other programs that use text files, I don't think you should expect the same for native formatted files. For example, I used to do music typesetting, and both of the top programs (think of them as the InDesign and Quark of music typesetting) could save or export as several graphic formats that could be placed into a page layout program. That's great, but you can't place the type of files that either music program can read natively. The fact that you can place a Word file directly, without having to save it as .txt, .rtf or other formats is great, but I expect that it has everything to do with how common Word is. Maybe there will be an Adobe or third-party solution to placing native Pages files in the future, but I wouldn't let it bother me today.
By the way, have you tried opening the tab-delimited files that Pages exports in a text editor and saving them as plain text? If you have a Mac, you can use TextEdit. Just open the file and choose Make Plain Text from the Format window and save-as with another name. I'd be more than a little surprised if Windows doesn't have something similar.