+5 votes
by (200 points)
Just adding products to a Google Sheet in Google Merchant Center is overwhelming! There has GOT to be an easier way. I've searched Google - hoping for some videos to turn the light on for me :( Any one have guidance? I have 61 products to add. I do have an XML file and a CVS file supplied by my website - Big Cartel. I tried the XML by doing "fetch" and, of course, Google returned it all in errors. I have no idea what to do with the CVS file provided (yeah I am THAT bad). Any guidance would greatly be appreciated!  
Just adding products to a Google Sheet in Google Merchant Center is overwhelming!

4 Answers

+2 votes
by (670 points)
Go to Google sheets -> file -> import -> upload -> choose your csv
by (200 points)
@feriga4592, that’s it! It will walk me through the rest?  
by (200 points)
Thank you Dmitrl!  
by (670 points)
YW, good luck with your feed
by (200 points)
Dmitri, didn't work error. Uggh. Looks like it's one by one by one. AND I have a feeling there will be errors. Not my forte'!  
by (670 points)
@bag925 are you using woocommerce or shopify?  
by (200 points)
Dmitri, Big Cartel. They sent me the CVS and XML file and both were rejected.  
by (670 points)
I havent worked with them before! But if there are like the other systems, you should be able to use a plug in or app to connect your feed to MC
by (200 points)
Dmitri, ty I’ll look into that!  
+2 votes
by (5k points)
Datafeedwatch can help you
+2 votes
by (1.2k points)
There are loads of super easy ways to do it. What platform is your site built on? WordPress? Magento? Shopify?  
by (200 points)
Farooq, Big Cartel
0 votes
by (8.8k points)
DataFeedWatch, Channable, these kind of Paid tools are exactly for that: making your raw data feed management a lot easier. You do need to spend a bit of time to set up some smart rules to make your feed better readable for Google, but it's worth the investment!  
The Google AdWords Group is where you can always find questions, answers, advice, reviews & recommendations from other community members about successful search engine marketing (SEM) ads through Google AdWords.
...