User Profile
davidbump
Copper Contributor
Joined Mar 25, 2019
User Widgets
Recent Discussions
Re: Import excel into existing list (with data already in it)
Username635 I just used this technique earlier today with several rows of text columns (including one multiple lines of text column), and it worked fine. It is tricky selecting the first empty cell after enabling edit in grid view, without getting the active cursor element there (which will result in the paste filling just that single cell with all of the data, as you're seeing). Since the recent changes to bring the Lists App visual improvements over to SPO lists, that seems less predictable than it used to be, where you could click on a very subtle, tiny square in the lower left corner, to the left of the select row icon. Actually, it looks like the select icon is gone entirely for the Add new item row, but there is a similar tiny square in the lower _right_ corner instead that appears to work reliably. My emphasis in green circles:
