Easy Populate won't work with Excel text file, only Text Edit file.

[anduril3019]

I am downloading extended store data in easy populate, opening that file in Excel, making minor edits, saving file as tab delimited text file. When I upload and import, I get an error for about half of my product rows, not all.

If I go through the same process using Text Edit (Mac) instead of Excel, everything works fine.

The problem is the limitations of Text Edit. I have also tried saving the Excel file then opening it in Text Edit and doing a Save As, doesn't work.

I have also made sure there are no extra tabs anywhere, because the error message in Easy Populate says there is a column count error. But since it doesn't happen in Text Edit, it must be something Excel is doint to the file.

Any Ideas?

Thanks

[kobra]

Best asked in the ezpopulate contributions thread