How do I replace a worksheet with new data?

Modified on Tue, 07 Feb 2023 at 04:31 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 Conference App Builder 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 Conference App Builder. Simply wait 5 minutes and try again.