Would this work for Sharepoint on premises as well

Any progress on this? Going through the same issue.

I am also having same error for blank values in csv any idea?

Hi,
I have few rows where some of the columns are blank and it should be like that.
My columns in the list are as well not of required type. But still the item does not get created due to a single blank column in my row. What can be a solution for this.
The error comes that Item cannot be created if its value is null.

I had this error. I formatted the .csv date columns to represent the US standard datetime as opposed to UK standard. Which worked for me.

I know this is way late, however it may help someone else down the line. If you are importing empty rows, check your csv file and make sure there aren’t a bunch of empty rows being added by Excel. To do this, simply open your csv with a text editor like notepad. Scroll to the bottom of the document and see if there are rows of just commas with no data. If there is, just delete those rows and try again. If you want to do it programatically, pipe the following code to your import-csv line:
| Where-Object { $_.PSObject.Properties.Value -ne ” }

I am also really after importing records with lookup columns, any luck with it?

I have many Lookup-columns that are collected from another list and it seems not to work even if the value is exactly the same. Do I need to do something more logical in the script to solve that? For example pick up the value from the lookup-list and enter it to the current list to import to?