Spreadsheets and databases

CSV from a link

A spreadsheet you publish as a CSV link fills a collection, and refreshes when you sync.

On every plan

What CSV from a link puts on your site

Keep a price list, menu, event schedule or staff directory in a spreadsheet. Publish it as a CSV link, paste the link into a collection, and your site shows the rows. Change the spreadsheet, sync, and the site follows.

How to set it up

1

In your spreadsheet, publish the sheet as a CSV and copy the link.

2

In your PageHub dashboard, open Collections and pick the collection to fill, or make one.

3

Set its source to CSV (URL) and paste the link.

4

Make sure each row has an id or externalId column, so a changed row updates instead of doubling up.

5

Pick a sync mode: Mirror removes rows that are gone from the sheet, Additive only adds and updates.

6

Save, then choose Sync now. Do the same after you edit the sheet.

Try PageHub on your own domain

The free plan includes 1 published site on your own domain. No credit card.