Exporting, editing the mysql table and importing it back to database - With Excel

First go to mysql and select your table for example I am using uc_products table. that is used in Drupal Ubercart site. 

You just click on export and select 

Then you open the file in excel, and edit the data, remember, don't change how the rows are sorted, if you do that, put everything back like it was. 

I usually do that to change some prices, or mass change weight, dimensions for my products. 

ok so that is done. Now you export it as CVS comma delimited from Excel. 

my Excel is kind of weird. Exported file does not use ; to separate cells. It uses , for god sake. 

So first you need to do is to open your excel CVS file in notepad, and see how the file is structured

My first row looks like this

vid,nid,model,list_price,cost,sell_price,weight,weight_units,length,width,height,

As you can see there are no " " and no semicolons. 

The cells are separated by commas.

Then you open the table in your mysql, empty the table and click on import. 

Select import from 

CSV using LOAD DATA

and for me, this works

CSV drupal

As you can see I only filled the Fields terminated by with  ,  

That is it, this is the trick

Add new comment

The content of this field is kept private and will not be shown publicly.

Plain text

  • No HTML tags allowed.
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.