A newbie needs help!!! Importing data from excel sheet but not visible on the ServiceNow Table.

[SyedKhalilAhmed]

Hi SNowDev's

I am learning ServiceNow Developer, And I've run into a very newbie issue but a big one.

I uploaded my excel sheet called Vendor Report.xlsx to ServiceNow, select all the required permissions, Checked the Import Sheet Data and yet I get an empty table in ServiceNow. When I tried the same import method using the data ServiceNow provided (Safety-Issues.xlsx) it worked fine, but for this report it doesn't seem to. Why is this? 

Please Help, Thanks

P.S: the data in the excel sheet is a dummy data!!

[Dr Atul G- LNG]

Hi @SyedKhalilAhmed 

Seems something wrong with table in AES, create only 2 fields and then try to upload it.

[SyedKhalilAhmed]

So I have worked on this solution as well, ServiceNow provided an excel sheet called Safety Issues as part of ServiceNow Learning, I don't know why but using that excel I am able to create the table, also If I use 2 of its(safety-issues.xlsx) columns additionally in my sheet only those 2 columns are populated in the table and no other columns which were already present are visible. 

If we observe it is creating empty rows, I'm not sure what the issue is.

Thank you

[Dr Atul G- LNG]

Hi @SyedKhalilAhmed 

Try to do this again, seems while doing excel upload something wrong you are doing. 

[SyedKhalilAhmed]

I was thinking the same but I've tried now for 3 times with my excel sheet and 2 times with the one provided by ServiceNow, And It doesn't work for my excel sheet but works smoothly for the sheet provided by the platform

- The format is .xlsx(Required)

- The headers populate as well

- Only issue is data is not visible after export in the servicenow tables

- But for the safety-issues excel provided by ServiceNow it populated the data.

Thank you for your continuous response in helping me solve this❤️✨