AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
2.5K members online now
2.5K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Can I upload via excel and not through google sheets? (excel or .csv file via excel)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I've been using google sheets to upload my items (before it was content api where my platform had a pretty easy way to upload items (but they stopped running that now).  Google sheets worked pretty good but I use special formula and vba on excel to prune items that are not performing or ads that get disapproved. I then copy this back to the google sheets.


Google sheets lags quite a bit compare to excel and was wondering if I'm able to upload via excel . I think I saw there was ftp or direct upload but is the format similar as google sheets?

 

I do like that when I do a fetch in google sheets it shows errors quite quickly and can fix the issue on the spot and reupload. If I'm able to upload the excel file (direct or ftp),  it won't show errors quickly like the google sheets right?

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
June

Can I upload via excel and not through google sheets? (excel or .csv file via excel)

[ Edited ]
Top Contributor
# 2
Top Contributor

yes -- simply re-save the excel-sheet as .txt, text, tab-delimited.

 

csv and raw-excel files are not supported and should not be submitted.

the feed must be registered as a regular
(.txt file) upload -- not a google-sheet; e.g.

us-product-inventory.txt

typically, the .txt tab-delimited file may be submitted to google using either
(a) a manual-upload, via the upload-input-file, under the feed-processing-tab;
or (b) a scheduled-fetch, if the .txt tab-delimited file is accessible to google,
someplace on a public-server; or (c) ftp, entirely server-side; ftp may also be
scheduled server-side, using a server's scheduling mechanism, in most cases.

the updated excel-sheet must always be re-saved as a tab-delimited, .txt, file,
then re-submitted to google, using the same registered primary-feed, regardless
of the submit method -- manually, scheduled-fetch, or ftp.

processing-time is about equal to a google-sheet, and mainly depends on the
number of items -- however, there is no google-sheet-plugin equivalent; the
processed results must be manually reviewed, by carefully inspecting the feed's
processing-tab, by clicking on the feed's name, under the products-feeds-tab,
each time the .txt file is re-submitted to google.

 

the .txt tab-delimited feed-file must be resubmitted to google

at least monthly -- typically 5-days before the feed's expiration --

or immediately, whenever a critical change to the website, or

physically inventory, occurs.

 

normally, only one, single, registered primary-feed

should ever exist within the merchant-center -- for

a target-country, for up to 100,000 inventory items.


csv and raw-excel are not supported formats for the merchant-center.

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
June

Can I upload via excel and not through google sheets? (excel or .csv file via excel)

[ Edited ]
Top Contributor
# 2
Top Contributor

yes -- simply re-save the excel-sheet as .txt, text, tab-delimited.

 

csv and raw-excel files are not supported and should not be submitted.

the feed must be registered as a regular
(.txt file) upload -- not a google-sheet; e.g.

us-product-inventory.txt

typically, the .txt tab-delimited file may be submitted to google using either
(a) a manual-upload, via the upload-input-file, under the feed-processing-tab;
or (b) a scheduled-fetch, if the .txt tab-delimited file is accessible to google,
someplace on a public-server; or (c) ftp, entirely server-side; ftp may also be
scheduled server-side, using a server's scheduling mechanism, in most cases.

the updated excel-sheet must always be re-saved as a tab-delimited, .txt, file,
then re-submitted to google, using the same registered primary-feed, regardless
of the submit method -- manually, scheduled-fetch, or ftp.

processing-time is about equal to a google-sheet, and mainly depends on the
number of items -- however, there is no google-sheet-plugin equivalent; the
processed results must be manually reviewed, by carefully inspecting the feed's
processing-tab, by clicking on the feed's name, under the products-feeds-tab,
each time the .txt file is re-submitted to google.

 

the .txt tab-delimited feed-file must be resubmitted to google

at least monthly -- typically 5-days before the feed's expiration --

or immediately, whenever a critical change to the website, or

physically inventory, occurs.

 

normally, only one, single, registered primary-feed

should ever exist within the merchant-center -- for

a target-country, for up to 100,000 inventory items.


csv and raw-excel are not supported formats for the merchant-center.