↑↓ selectEnter openEsc close

    1. Elbuz

    How to build a customer price list in XLSX or CSV

    4 min readUpdated

    Elbuz builds a price list for customers and dealers in XLSX or CSV from current catalog prices and delivers it by link, FTP, or email. Set up columns once; the file refreshes on schedule.

    When you need this:

    • Wholesale buyers need fresh prices daily — the schedule rebuilds and emails the file as an attachment to everyone.
    • Each buyer gets their own columns — your headers, values from the catalog or a formula.
    • Supplier prices next to yours — a consolidated price list shows one column per supplier.
    • Import into the customer's accounting software — UTF-8 CSV with the delimiter they need.

    Where to start: your first customer price list.

    What a customer price list can do

    • Columns, formulas, prices, and currency — what the file is made of and what the customer sees in each cell.
    • Consolidated price list — supplier prices in rows or columns, price colors, the category tree.
    • XLSX or CSV — a formatted Excel workbook or a text file for the customer's accounting software.
    • Scheduled delivery — a permanent link, , or an email to every newsletter recipient.
    • Fixing a mistake — what to do when a wrong file has already reached the customer.

    Which format to choose: XLSX or CSV

    You choose the format with the radio buttons on the “Select Format” card: , XLS, or CSV. XLSX is the default and the right choice in the vast majority of cases; XLS remains for those who need the old format. The formats are mutually exclusive: pick another one and the previous one is cleared automatically.

    The difference isn't cosmetic: XLSX and XLS are written by one library and CSV by a completely different one, which explains all the differences.

    Settings tab of the price list template: the format choice card and the CSV settings card
    1Selected format: XLSX
    2Column delimiter
    1. XLSX is the selected format; XLS and CSV are the other two options.
    2. The column delimiter field is empty by default, which is the default state for CSV.
    XLSX / XLSCSV
    Sheet in the workbookone, named JumperSheet1no concept of sheets
    HeaderCalibri 10, bold, green; the first row is frozen and stays in place when you scrollan ordinary first row
    Column widthfrom the “Width” columnnot applied
    Price colors and hyperlinksyesno, plain text
    Empty columns in the headeron a server without an activated license for the Excel library — 256 cellsexactly as many as there are columns
    Cell length limit32,767 charactersnone
    File extensionas set in the name.xlsx in the name changes to .csv — but only in the link. A file sent over FTP or as an email attachment keeps the extension from the “File name” field, so for these routes type .csv yourself

    The row about 256 cells needs its own explanation, because it isn't the app's behavior. The library that writes XLSX is commercial, and without an activated license it runs in trial mode: it takes the first row for itself and stretches it across the full width of the old format, up to column IV.

    As a result, Ctrl+End jumps somewhere near the end of the sheet, and “Format as Table” grabs some 250 empty columns. Your data isn't affected. The demo account has this; if your own file has such a header, contact support — it isn't a template setting. The only workaround for now: send CSV.

    CSV settings

    The “CSV Configuration” card is always visible, even when XLSX is selected — with XLSX these two fields simply have no effect.

    An empty “Column Delimiter” field means tab — and that's the worst option for the customer: double-clicking such a file opens it in Excel as a single column. Set a comma or a semicolon explicitly. If you type the word TAB in the field, the app replaces it with a real tab character.

    Also, the delimiter must be exactly one character. The field lets you enter more, but only the first character goes into the file, and the log gets a warning: “Column separator “‹what you entered›” is not allowed: a single character is required. Used “‹what was taken›””.

    When the “Enclosure character” field is empty, a double quote is used. Values are enclosed only where needed: when a value contains the delimiter, a quote, or a line break.

    The card has two fields — “Column Delimiter” and “Enclosure character”. There is no way to set the line ending, and no need to: CSV lines always end with a line feed.

    CSV is written in with a . That's exactly what Excel on Windows expects: the customer double-clicks the file and sees Cyrillic text, not random characters. You no longer need to walk the buyer through “Data → From Text”.

    Scenarios

    Your first price list for a customer: from template to schedule

    Before you give the file to a customer

    The customer loads the price list into their accounting software as CSV

    • What to set up: CSV on the “Select Format” card; in “Column Delimiter”, exactly one character — the one the customer's software expects; if the file goes over FTP or by email, the .csv extension in “File name”.
    • What you get: a text file in UTF-8 with a BOM — Excel on Windows opens Cyrillic correctly on double-click. Columns are separated by your character, and values are enclosed with the “Enclosure character” (empty field — a double quote).
    • What you won't get: an empty “Column Delimiter” doesn't give you a comma — it means tab. If the delimiter has several characters, only the first goes into the file, and a warning goes into the log. The app changes .xlsx to .csv only in the link.

    What to do when a customer can't open the file

    Common problems
    What you seeWhyWhat to do
    The customer opened the CSV and sees random characters instead of Cyrillic The file was opened not in Excel but in a program that doesn't read the BOM: the file itself is UTF-8 with a BOM, and Excel on Windows reads it correctly Open it by double-clicking in Excel, or set the to UTF-8 in your importer (about CSV)
    The customer opened the CSV and the whole file is in one column The “Column Delimiter” field is empty, which means tab Set a comma or a semicolon (about CSV)
    In the XLSX, Ctrl+End jumps to column IV, and the header has hundreds of empty columns The library that writes XLSX runs in trial mode: without an activated license, it stretches the first row to 256 cells Your data isn't affected. Contact support — this is a server state, not a template setting; meanwhile, you can send CSV (about formats)
    “Could not read the generated file for preview.” The file was built, but it couldn't be read back Check the format and that the file was actually built: the run log should have a line about the file upload (CSV settings)
    “Could not create the Excel file on the server. The file was not generated — contact support.” The extension for writing Excel didn't load. The file isn't built, and the link keeps the previous one Temporarily switch the template to CSV and contact support
    “Save failed” in the card's bottom bar Autosave on the “Settings” tab didn't go through Repeat the change and make sure “All changes saved” appears
    “No access to data export” The user's group doesn't have access to the export window Ask the account owner to grant access (who has access)

    FAQ

    A customer complains that the prices in the file are out of date. Why?

    The file is rebuilt only during a run. Without a schedule, the link holds whatever was last built manually. Turn on the schedule.

    Can I email the price list to customers automatically?

    Yes, and only this export type can do it: pick a “Newsletter template” on the “Email newsletter” card, and the file goes out as an attachment on every run (about the newsletter).

    How many columns can I add to the price list?

    As many as you like — there is no limit. A typical customer price list has five to eight columns (about columns).

    Why does the XLSX header have hundreds of empty columns?

    It's a trace of the trial mode of the library that writes XLSX, not a template setting. Your data isn't affected. Contact support; meanwhile, send CSV (about formats).

    Can I make a price list with supplier prices?

    Yes: turn on “Create rows per contact” or the “Show values per supplier” column — you get a consolidated price list (how to build one).

    Where to find it and who has access

    Menu
    Directories → Operations → Data export
    Desktop
    the “Export” shortcut, unless it was removed from the desktop — shortcuts are per user
    Template card
    select a row in the list → pencil button in the toolbar; or the pencil button that appears on the row when you hover over it. The window title is “Advanced settings ‹template name›”
    New price list
    “Add” button → “Price list file (XLSX, CSV)” group → “Price list (XLSX, CSV)”
    Access right
    the “Data export” window — one right covers the list, the card, and “Check”
    Prepare
    categories with names in the export language — otherwise their products drop out of the file

    The “Price list file (XLSX, CSV)” group comes first in the “Add” menu. Besides “Price list (XLSX, CSV)”, it holds the OpenAI (ChatGPT Ads) feed, built on the same engine, and a prom.ua feed in XLS format.

    In a new template, the “File name” field already contains export_price_summary.xlsx — change it to something your customer will understand. You can also clear the field completely: the app then uses the same default name, and the file at the permanent link keeps its name.

    The price list card has three tabs:

    • “Select fields” — the file's column builder;
    • “Settings” — format, , the “What to export” checkboxes, delimiters, the newsletter;
    • “Export limit (filter)” — filtering conditions. It has two inner tabs: “Base Catalog Items” and “Products from price lists”. The second one exists only in this template type.

    The “Settings” tab uses : there is no “Save” button, and the bottom bar shows “Saving…” and then “All changes saved”. Every checkbox click goes to the database right away.

    The “Export” button in the card header starts a live run. Before it starts, it asks for confirmation and states the scale: “Start the export. Products going into the file: N. The new file replaces the current one at the permanent link.”

    • Once you confirm, the new file goes to the template's folder in the cloud, the link is updated, and all other files in the folder are deleted. A customer who picks up the price list by link gets whatever you have just done.
    • To simply see the result of an edit, use the flask button next to it, “Check”: it writes to a separate file and sends it nowhere.
    • The same dialog with numbers also opens when you start a run from a row in the template list — unless it has been turned off for the whole account in the “Export stop rules” window (about starting and the summary).

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free