Exporting Price Change Data and Organizing It for Excel or Automation

Hi Distill.io Support Team,

I’m currently using Distill.io to monitor product prices (e.g., Nike.com), and I’d appreciate some clarification on how to best manage the data.

  1. When exporting data as a CSV, does the file clearly show when prices have changed — including the previous value, new value, and timestamp? Or would I need to do manual cleanup in Excel to make that information clear and organized?
  2. Is there a recommended way to structure the data neatly in Excel — with clear columns like “URL,” “Previous Price,” “New Price,” and “Change Time”? If not, do you have any tips on formatting exported CSVs efficiently?
  3. Lastly, is there a better alternative to exporting manually — such as using Zapier or another automation tool — to send change data (like price updates) directly into a spreadsheet in real time?

I’m aiming to automate this process as much as possible and would love to know the best approach for clean data tracking.

1 Like

hi @jcobteam1034 - one of the automated ways to save data is using a webhook to write them to a spreadsheet. here is a blog discussing how to do that using distill:

  1. the manually exported csv data only contains the current value.
  2. structuring data can be be done in two ways:
    • managed scraper: distill offers scrapers for popular sites that help get structured data
    • ai summary: it can extract structured data from any webpage using a prompt. this is the easiest option.
  3. webhook to spreadsheet is the way to go. tools like zapier can help too.

let me know if you have any other questions or need help with anything.