Tutorial: Publish CSV online from Google Sheets

Introduction

In this guide, we explain how to publish a Google Sheets CSV file online so you can use it as a source in Instant Search.

Preparation

Make sure you have a Google Spreadsheet with at least the following three columns: URL, Title, and Description. These are the mandatory fields you need when setting up the CSV file as a source.

Remove any unnecessary columns from the CSV file by selecting them and right-clicking on the selected columns and choosing 'Delete columns'.

You will see that the selected columns have disappeared from the file.

Step-by-step

To give the CSV file a URL that you can use in Instant Search, go to 'File' > 'Share' > 'Publish to the web'.

In the pop-up window that appears, select the tab with your data instead of 'Entire document'.

Next, choose the option 'Comma-separated values (.CSV)' and click 'Publish'.

Copy the link that now appears on your screen. Use this link as the URL for your source in Instant Search.

With these steps, you have published a Google Sheets CSV file online, and you can use the generated URL as a source in Instant Search. If you need assistance or have questions, please contact support@afosto.com.