Catalog generator
What Catalog generator actually does
Every catalog builder that takes a spreadsheet has to answer one question first: which of your columns is the product name. Most of them answer it silently. They look for a header called name or product, and when your export says Product Name or Article or Bezeichnung they either guess something else or refuse, and either way you find out at the end. This page asks the question out loud. Once a file is read, every catalog field gets a select listing the real headers in your file, pre-set to the column its name matched and free to change, so a spreadsheet that came out of an old system is a two-click job rather than a re-export. The second thing most tools get wrong is the encoding. A CSV saved from Excel on Windows is usually not UTF-8, and a reader that decodes it as UTF-8 anyway does not fail: it substitutes a replacement character for every byte it cannot read and hands you a catalog full of black diamonds that looks like it worked. This page decodes strictly, refuses the file when the bytes do not match the encoding, says which encoding is likely, shows you what that decoder makes of the first line, and lets you accept it. Then it shows you the catalog. Not a flipbook of it and not the HTML source, the actual document, rendered in an isolated frame with remote images held back until you ask for them, so looking at your own price list does not call out to anyone.
How to use it
- Drop a CSV. It is read in this tab and no part of it is sent anywhere.
- Check the mapping. Each catalog field starts on the column its header matched, and every one of them is a select over the real headers in the file. The four optional fields can be set to not used.
- Set the title, the currency symbol, how many columns a printed page gets and how many items go on each page. Zero items per page keeps everything on one.
- Look at the catalog in the frame. Switch to HTML to read the source that will be written.
- Download it. The file is one self-contained HTML document with its styles inside it and no link back here.
Useful for
- Turn a wholesale price list into something a customer can be sent or a rep can print, without laying it out by hand again every time the prices move.
- Produce a line sheet from an export whose column headers are nothing like the words a catalog tool expects.
- Rebuild the same sheet after the spreadsheet changes and get exactly the same document, because the data is the only source of truth.
- Read a supplier CSV that arrived from a Windows machine and came out full of replacement characters everywhere else.
Limits worth knowing
- The output is a single HTML file. Printing to PDF is the browser's own print dialog, where the print columns and the items-per-page setting take effect.
- The catalog on screen stops at 300 items for speed. The downloaded file always has every row.
- Remote images are held back in the preview until the control is turned on. The downloaded file always carries the URLs the CSV supplied, whichever way that control was set.
- A row with no product name is skipped, and a file where every row is missing one is refused rather than written empty.
- A price the tool cannot read as a number is printed as it was written, so call for a quote stays call for a quote.
Questions people ask
undefined
undefined
undefined
undefined
undefined
undefined
undefined
undefined