Sign up for a free evaluation account
Text Download ➞
Title Subtitle Download ➞

How to Create a CSV Link

What is a CSV File?

CSV stands for Comma Separated Values — a text file format used to store tabular data such as numbers and text. It uses commas to separate values and new lines to separate records.

In NoviSign CMS, CSV files can be used as input for several widgets, such as the Calendar Widget, or simply to display a Google Spreadsheet using the Embed Widget.

A typical CSV file:

  • Represents each record as one line.

  • Uses commas to separate each field within a record.

  • Requires all records to have the same number of fields.

  • Allows fields to be enclosed in quotation marks, especially if the field contains a comma.

How to Create a Shared Link From Your CSV File in Google Sheets

You can easily create a shareable CSV link by publishing a Google Sheet. This method is useful for broadcasting event files on digital screens using the Calendar Widget.

How do I set it up?

  • Go to https://drive.google.com

  • Sign in to your Google account

  • You can either open an existing sheet or create a new one

Google Drive

Step-2-CSV-link

In the sheet, go to the top menu:
FileSharePublish to web

Step-3-CSV-link

    • In the Publish to the web window:

      • Select the Link tab

      • In the dropdown menu, choose what you want to link:

        • Entire Document

        • Sheet (a specific sheet within the document)

      • In the next field, change the format from:

        • Web pageComma Separated Values (.csv)Step-4-CSV-link

and then press Publish:

 

  • Click the Publish button

  • A public CSV link will be generated

  • Copy the generated link to use it in NoviSign

Step-5-CSV-link