csv import trouble

Help!

I am very much a PHP novice, but highly familiar with the workings of WordPress and i’m having a bit of bother.

Building a site for a lettings agent and utilising a data feed that comes in the form of a .BLM file. Basically this is a csv file with the information for the properties listed. I have managed to get the site up and running by manually importing the file into Excel and exporting and uploading as a csv before utilising WP All Import to covert the data as required on site. However, I am not at the end stages of the build and the file type change needs to be automated. I have read some information about fgetcsv – would this help me? Or do I need to add some PHP within wordpress to tell it how to deal with the file before it reaches WP All Import?

To top it off, the file itself has line breaks that I can’t fix via excel. Basically the line break is seen as a new row rather than continuing the previous line.

I am at a bit of a loss. Can anyone help me?

Thanks,

Steph