I'd like to import an Excel spreadsheet consisting of 1,900 rows and 7 columns.  I've spent a couple of hours reading the help page, looking at old threads, and trying different methods.  So far, I haven't come up with anything that looks reasonably simple and effective.

 

Importing looks like a time sink, which seems confirmed by several threads complaining about not being able to get it to work.

 

The ultimate solution would be the ability to simply open an Excel file in Infoqube, with all items automatically assigned to the appropriate fields.  This was discussed in a thread 5 years ago but I don't know of any progress on this idea.

 

A simple copy/paste would be fine with me but I can't get that to work either.  Ideally, if you had a spreadsheet with 20 rows and 5 columns, you could directly copy/paste it into a grid made of up 20 blank items and 4 fields.  I know that can't be done.

 

I'd settle for just the ability to copy/paste multiple items in a single column, but I can't even get that to work.  For example, here are three, single line items:

 

 

If I copy/paste them one at a time, it works fine.  But if I try to copy all three and paste them into three selected cells in InfoQube, it creates a mess.  For some reason, it seems each cell as being multi-line text, plus it adds several empty items, so I end up with 13 new items in InfoQube:

 

 

Any ideas would be appreciated.

 

Wayne

9.106c, Win 7, 64 bit