Formatting web imported data and refresh

Hi all,
I am creating an Excel database. I would like to import names, emails and job positions of all employees of a private company from the firm website.
I chose Data->From Web and selected the whole page, as only one yellow icon to select data was available. In fact no table for the above data is present: just a quite big webpage with photos of employees and names, emails, job positions next to them.

I imported the data into my Excel spreadsheet and I began to change their format, by moving email accounts in the "email" column and similarly for job positions and names. I deleted the photos.

I would like to refresh data keeping this new format. Unfortunately, every time I refresh the imported data using the "refresh all" button, they return to the original format, which is quite bad.

How can I keep the new format for my imported data and refresh them without returning to the original one?

I thank you all for your support!

Kr,
Infogeo

Almir's picture

Change properties of imported data

Right-mouse click on your imported dataset, choose "Data Ranga Properties", check box "Preserve Cell Formatting".