Import Excel Spreadsheet into Google Sheets

[robsandersppc]

Hey all

I have been given an Excel sheet of products, sorted by supplier.

It has the supplier brand in the first column, with a (+) next to it to highlight the products from this brand.

From the unexpanded original sheet, when I import to Google Sheets, it drops all the products from each brand.

If I expand every cell, I am able to copy it into Google Sheets.

Is there a way around this without having to expand every cell each time to display it in Google Sheets?

Thank you.

 

[RoryA]

How exactly are you "importing" it to Google Sheets?

BTW, if you have grouped rows, there should be numbers at the top of the area where the grouping buttons are and clicking the highest number will expand all rows for you.