cleaning up pricelist for CSV

[GeneralProf]

HI everyone, this is my first time posting on this form.
Please note i am new to excel

Background
Currently we have 5 suppliers and out of the 5 only 2 can give us there pricelist in CSV, now my problem is with the other 3, they have a lot of styling on there pricelist so that it makes it for attractive for the general shop owner to browser there selection but we are a online store that need to update price everyday so my problem is they have to much styling for me to just convert the .xlsx to CSV.

The Setup
For this example i will use one of our suppliers
The file has: 5109 rows,A big header that follows you when you scroll with a drop down list for selecting the category you what to go to and two buttons.

table structure:

Barcodes	Prices	Unit code	Description
Product series (this row is merged)
Bar1	123	G123	desc
Bar2	213	G124	desc
Bar3	321	G125	desc
Product series (this row is merged)
Bar4	152	Q12	desc
Bar5	351	Q13	desc
Bar6	251	Q14	desc

<tbody>
</tbody>

Needed result:

I need to have a simple CSV that has the following setup -> barcode,price <- that all, i am crating a php function that will update everything on the server side but i first need to get the CSV ready for upload.

What i have tried before

I have tried:
1.selecting all
2.then clearing the formats and also removed the merges
3.Saving the file as CSV
4.Open the new CSV in excel
5.Selecting column B and hitting F5 then special then selecting blank
6.Now once all the blank fields are selected i remove the empty rows

I select B because if there is a product it has a price in B so that way all the unwanted rows are deleted.
Then this should work then right. No for some reason note all the rows are saved when first saving the CSV (step 3 above)

Does anyone have a idea to what i can do?
Any help will be much appreciated

 

[Sayre]

Hi GeneralProf, welcome to the board!

For your first goal (removing the formatting, merges, etc...) you can skip steps 1 & 2 and go straight to #3. Saving as a CSV automatically gets rid of any fancy excel formatting. Then close and reopen in excel and all formatting will be gone.
For the second goal (removing rows with no data in column B). Sounds like you are using special selection method to get all the blank rows. It worked for me on your sample data not sure why it is not working for you. Have you thought about using auto-filter? Select column B, click on the Data ribbon and click auto-filter button. Filter delete blank rows from there.

 

[GeneralProf]

Hi Sayre,

Thanks for the help it worked for me!!!

Have a great day.