10 Replies Latest reply: Oct 29, 2013 11:13 PM by Migintosh RSS

    Data Merge and the new Pages

    Huskerfan29 Community Member

      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?

       

      Thanks.

        • 1. Re: Data Merge and the new Pages
          Migintosh Community Member

          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?

          • 2. Re: Data Merge and the new Pages
            Huskerfan29 Community Member

            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.

            • 3. Re: Data Merge and the new Pages
              Laubender MVP

              @Don't know if that will work; just something you could do:

               

              Open the tab-delimited text file in TextEdit and resave it as txt file with Unicode (UTF-16).

               

              Uwe

              • 4. Re: Data Merge and the new Pages
                Peter Spier ACP/MVPs

                I recall some previous thread about this, and the problem was the encoding...

                • 5. Re: Data Merge and the new Pages
                  Rik Ramsay Community Member

                  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.

                  http://www.openoffice.org/

                  • 6. Re: Data Merge and the new Pages
                    Huskerfan29 Community Member

                    Rik,

                     

                    Thanks for that resource.  I wonder since I can save a Numbers file as a .csv file, why can't I get it to work with my data merge?

                    • 7. Re: Data Merge and the new Pages
                      Huskerfan29 Community Member

                      Peter,

                       

                      Thanks, I know this is going to show my lack of general computer knowledge but I don't even know what encoding is.

                      • 8. Re: Data Merge and the new Pages
                        Peter Spier ACP/MVPs

                        Encoding is how the file is structured. There are a number of different encodings possible for .csv files, and my recollection is that Numbers uses one that ID cannot read.

                        • 9. Re: Data Merge and the new Pages
                          Huskerfan29 Community Member

                          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.

                          • 10. Re: Data Merge and the new Pages
                            Migintosh Community Member

                            Huskerfan29 wrote:

                            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.