cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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.  

Picture1.png

3 Comments
dowutyalyk
Level II

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

MathStatChem
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.  

MathStatChem_0-1580398251408.png

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 http://www.jmp.com/support/notes/60/026.html, and this really could use some improvement to use the actual Excel cell referencing for the location of the data being imported.

 

Status changed to: Not Planned For Now

@MathStatChem - We appreciate you submitting this request, but unfortunately we do not plan to implement this at the moment.