How to bulk edit all the cells in a column in a CSV


Latest update: - Sam Pallesen

Setup

  • Mac
  • OpenOffice

Steps

  1. Click on the first cell in the column which you want to fill
  2. Type in the desired value
  3. Click Edit up the top of the screen
  4. Click Fill
  5. Select Down
  6. The cells will now fill down

Additional Information

Bulk editing cells is useful for when you want to change the same thing for a large number of products. For instance, you can use this method to bulk inactivate products.