I have an excel 2007 sheet I am using as my product database. It has various columns and rows with data as below:

Code    Company  Image Code   Picture Page
UV001   UV Gear  uv001.jpg    http://www.uvgear.co.uk/product/images/fs_uv001.jpg   

I want to export certain columns and certain rows to a csv file for uploading to google adwords.

The problem I have is that I do not want all the rows or all the columns to export. I have 450 product rows but only want to export approx 250 active/In stock lines. I guess I need some sort of True or False rule at the head of each row and column?

Please treat me as a complete excel novice!, thank you Nick

  • What is the criteria of selection? – jcbermu Mar 22 '16 at 14:47
  • Thanks jcbermu Sorry do you mean which columns are required? if so they vary as to what is in stock at the time of the upload. I dont want to waste money loading old pages or non stock items. – Nick Mar 22 '16 at 14:54
  • I do have a 'stock' column so could label as 'In stock' or 'old' if that helps differentiate – Nick Mar 22 '16 at 14:55

Since you have an stock column then based on the values on that column you can filter to see only the desired rows:

  1. On the Data tab, click on Filter.

enter image description here

  1. Now you have little triangles on top of each column, you can click on any of them to filter rows of the worksheet using as criteria the values of that column.

  2. When you have visible only the information you want then go to Home Tab and click on Find & Select. In the menu select the option Go To Special enter image description here

  3. Now in the multiple choice dialog select "Visible Cells Only". enter image description here

  4. Only the visible cells are selected, so you can copy and paste them on another worksheet that you can save as csv.

  • Tada! perfect and easy when you know how ha ha. – Nick Mar 22 '16 at 15:16
  • Sorry one more question! Thats great for achieving the rows but is they also a way of only exporting select certain columns via a similar method. thanks again! – Nick Mar 22 '16 at 15:40
  • The only way I know is, before step 3, right-click on the non-desired column and select Hide. Do that for each non-desired column and then continue with step 3. – jcbermu Mar 22 '16 at 15:55

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.