Getting Header row is null error while trying to load data

[dartx21]

Hello All,

Last week I was loading data fine and importing it. Now when I try to load data I get the error saying header row is null. Any ideas how to fix it?

[nick_2586]

Use ' save as' to save your data load sheet with a different name and try again.

[Subhajit1]

Hi Dartx21,

The spreadsheet which you are Uploading might not have Column names(Name, Assignment Group, Code etc) and might have Data from the first row (Row 1 of spreadsheet) itself. Still, when you are uploading the Spreadsheet, you are ticking on the field 'My Data has Headers' on the Load Data page. You are getting this error due to that.

Add Column names to your Data or Unclick the 'My Data has Headers' field and then check.

Thanks,

Subhajit

[Subhajit1]

If this solution helped solve your issue, would you mind marking my answer as correct.

Thanks,

Subhajit

[harikrish_v]

If you are using 'Load Data' option to attach and import the excel, make sure that the value for 'Header row number' is 1 and that the excel you attach has the first row populated.

Thanks & Regards,

Hari