Convert CSV to Web Catalog?

I need help automating the construction of simple catalog web pages from data in CSV format. I don't even know if KM/Applescript are the best tools for this job.

Let's start by saying that I don't know a thing about HTML code, let alone CSS. But I need to solve this problem.

For the next few months, I'm going to be receiving daily catalog reports in CSV format. They will be formatted like this:

Gladiator(2000),"Ridley Scott & Russell Crowe",,,,,,,,,
John Wick 3(2019), Keanu Reeves,,,,,,,,,

Each item can have up to eight photos in addition to name and a notes field. The photo URLs link to full-res photos.

I need an automated method to convert this CSV data into a web catalog. That is, a top-sheet web page that makes a table using the Name, Notes and Photo1 fields. The Photo will be a reduced version taken from the full-size image linked in the Photo1 field URL.


Clicking on any of the table items will take you to a linked page where the Photo1-8 fields are shown at their full resolution along with the Name and Notes fields.

Conceptually, it seems like something that one should be able to automate.
I'd appreciate any assistance I can get.

Thanks in advance for your help.

Hey @anamorph,

Can it be done? Sure.

Here's a very rudimentary proof-of-concept for the basic table on the face page:

Crude Example of Making a Contact Sheet from Source Text.kmmacros (4.9 KB)

My HTML is old and rusty, so it's crude indeed.

Not the simplest of tasks though. Expect to spend several hours.


Thanks very much for this. Very helpful.

1 Like

Hey @anamorph,

Here's a version that uses only Keyboard Maestro actions.


Crude Example of Making a Contact Sheet from Source Text (KM-Only).kmmacros (7.1 KB)


Very cool. So instructive. Thanks!

1 Like