The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar

Excel Import Improvement: Show Row Numbers and Column Labels in import preview

A nice enhancement to the Excel import utility would be to have the Excel row numbers and column labels displayed in the import preview.  It is easy for me to go into excel and see that headers are in rows 8,  data in rows 9-XX, and columns are A-J, but then translating that to the settings in the importer requires some arithmetic in my head.  


Tracking Number:

Defect ID: S1298376

Level II

great idea!  Not realizing this forum, I had just made this same request yesterday.  

Level VI

Visiting this again.  I think that overall, while the Excel Import Wizard is really great, it still needs improvement.  Another issue, that has been around since v13 (was that when the Excel Import Wizard was introduced?), is that if the Excel sheet has all blank rows at the top of the sheet, the import wizard ignores those rows in the count of rows.   For instance, see the screen shot of an excel sheet below.  


The excel import wizard makes you specify that the column headers start on row 2 but in the excel sheet the column headers start on row 3 .


1-29-2020 8-56-09 PM.png


This problem is described here, and this really could use some improvement to use the actual Excel cell referencing for the location of the data being imported.