What does the error "File has no line endings" for a lookup table means?

[ddrillic]

I'm trying to upload a file to be a new lookup table and I get the following error -

What can it be?

[jaustenfan]

When converting/saving the excel file to csv in Excel, I chose the Windows csv option (something to do with extra characters being added otherwise). This solved the issue for me.

[DalJeanis · Accepted solution]

Is this a plain csv file? Is it UTF-8 encoded? Take the file into something like notepad++ and turn on the "show invisible characters". see if there are cr/LFs at the end of the lines, or only CRs or LFs.

[ddrillic]

-- see if there are cr/LFs at the end of the lines, or only CRs or LFs

That was the thing - thank you @DalJeanis

[ddrillic]

The format of the line ending was off ; -)

[gcarson_splunk]

There are also some edge cases where if the csv column names have more than 4094 bytes characters Splunk will throw this error.

The solution in my case was to pre-process the csv and truncate the column names.