Import from Excel

Forums vLooup for SharePoint Import from Excel

Viewing 3 reply threads
  • Author
    Posts
    • #21524
      Patrice
      Participant

      I thought I saw a similar post but couldn’t find it so am starting a new thread. Do you have any plans for an enhancement to allow the user to do a mass import into vLookup from an Excel file? My users have requested this functionality but I know it is not possible now.

    • #21531
      Alexander Bautz
      Keymaster

      Hi,
      The vLookup child items are stored in a list so you can use datasheet view and copy and paste from your excel file. Just ensure you set the correct value in the column you use to connect your “parent” list item with your vLookup children.

      Alexander

    • #21544
      Patrice
      Participant

      Just so I understand – from one of the forms I would need to figure out how to direct the user to a datasheet list view of the child list, then they would need to know the correct _vLookup[parent]id and correct fields to copy/paste from a spreadsheet? I’ll look into this but don’t be surprised if I need assistance! Thank you.

      • This reply was modified 5 years, 8 months ago by Patrice.
    • #21547
      Alexander Bautz
      Keymaster

      What kind of data are your users planning to move from Excel? – is it a one time import, or something they plan to do regularly?

      Alexander

Viewing 3 reply threads
  • You must be logged in to reply to this topic.