I need to copy a table from a webpage and paste it in either google sheets or excel without loosing formatting. If I copy entire text and paste in excel then the data will appear in a single column one after one. Link to webpage : https://restaurant.store/product/all-purpose-handling-basket-11-ss/

enter image description here

Please help

  • In some cases, holding down the Alt key while dragging with the mouse will let you select both columns and rows. There are also add-ins for browsers, such as Print Edit WE for Firefox, that make it easier to select text. Jun 30, 2022 at 21:31
  • Thank you for your reply Sir. But its not working as I needed. Jul 1, 2022 at 5:00

1 Answer 1


There is a web page data scraping feature in excel that you can use.

enter image description here

  • The table is in div class format so can't copy paste in table format. I got this info from one of my friends. Jul 3, 2022 at 3:31
  • Excel file is attached. Anybody can try to solve this problem through VBA programming?? Jul 10, 2022 at 14:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .