How do I replace a worksheet with new data?

Modified on Tue, 17 May 2016 at 02:01 PM

  1. Open your Google Spreadsheet and open the worksheet which you would like to update.
    For example:

  2. From the Google Spreadsheet File menu, select Import ...

  3. Choose the Upload tab and Select a file from your computer

  4. Select your csv file that contains the information For example Speakers-01252015.csv

  5. The Import dialog appears after upload. In the Import Action section select Replace Current Sheet Leave Separator Character to be Automatic


  6. Press the Import button to replace all content of your current sheet. If you have very large data sets over 10,000 records, it may take a moment for the visible worksheet to replace all the rows.


Note: If you do a data import in the CMS immediately after replacing the worksheet, you may not yet see your new dataset being imported. It may take a few minutes before Google updates the associated published CSV file that is being imported into the CMS. Simply wait 5 minutes and try again.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article