Importing Facebook ads problem into power editor... help appreciated please!

[Ara_Mawaty]

I know this is shopify, and not facebook. However I can not find help for this anywhere.

I can not bulk import these ads into the power editor that I need for a store asap! I have wasted days trying to solve this solve this and I can't find anything online.

The ads I am trying to import into the power editor are exported from a mac. Once exported they are in a 'numbers' file. I have converted them to the correct excel spreadsheet files e.g. , and even every other type of file available however, possibly because they were exported from a mac and I am using windows, the ad file looks like this when open and is in the incorrect format. In a spreadsheet (I have tried both excel and google spreadsheets),

-all the headers are together in one line

Whereas I know the correct format to import them should actually have all the headers in separate rows.


Also, just to put it out there, it says Warning - Header label isn't correct when I import it. Maybe this will fix when it goes into the correct format.

But why is the format like this and how can I correct this, either from the exporters mac or from my own windows device?

I would appreciate help so much as I need these ads asap for a project and I can't find anything on this anywhere. Thanks in advance.

[Ara_Mawaty]

What the ad file looks like in a spreadsheet:

[Ara_Mawaty]

What it should actually look like: (all the headers should be in seperate rows)

So how do I fix?