Free tool · Datanorm viewer
Open Datanorm files and convert them to Excel.
View Datanorm 4 and 5 deliveries from your wholesaler or manufacturer in the browser: articles, prices, product groups and discount groups. Check the data with the quality report and export it to Excel or CSV, with no software to install and no upload.
Drop Datanorm files here
orDatanorm 4/5 · several files or a ZIP · BMEcat 1.2/2005 (XML) · up to 2 GBNo catalogue at hand?Your files stay in your browser. Nothing is uploaded.Why this viewer
Made for the Datanorm deliveries wholesalers send.
01
Your prices stay on your device
The viewer reads the files in your browser. Nothing is uploaded, so price lists and discount groups stay with you.
02
Datanorm 4 and 5, every file
Articles from DATANORM.001, prices from DATPREIS.001, product groups from DATANORM.WRG and discount groups from DATANORM.RAB, picked together or as the supplier’s ZIP.
03
Quality report and Excel export
Missing prices, duplicate article numbers, invalid EANs and product groups missing from the WRG file at a glance. Every article with its prices as one row in Excel or CSV.
Datanorm explained
Datanorm 4, Datanorm 5 and the files of a delivery.
What is Datanorm?
Datanorm is the data format wholesalers and manufacturers in plumbing, heating, electrical and building supplies use to send article data and prices to installers and their software. Almost every installer software reads it.
Each line of a file is one record, and its first character says what it holds, for example V for the header, A for an article, P for prices and T for long texts. Manufacturers often send BMEcat with ETIM features instead; those files open in the BMEcat viewer. More about the format at datanorm.de.
Datanorm 4 or Datanorm 5?
Datanorm 4 starts with a header line (V) in fixed columns: date, three info texts, version 04 and currency. All other lines are separated by semicolons. The article data is split across two records: A with texts, unit, price and groups, B with matchcode, EAN and further data.
Datanorm 5 separates every line with semicolons, including the header (V;050), and its article record also carries the manufacturer, the manufacturer’s article number and the EAN. The viewer recognises the version itself. Datanorm 3, with fixed records of 128 characters, is not supported.
The files of a Datanorm delivery
DATANORM.001 holds the articles with short and long texts, units, prices and groups. DATPREIS.001 holds list or net prices that update the prices of the article file. DATANORM.WRG names the main and sub product groups, DATANORM.RAB the discount groups.
Wholesalers usually send the files together as a ZIP. Drop the ZIP or select all files at once, and the viewer links prices, product groups and discount groups to the articles.
Code page 850 and broken umlauts
Datanorm files are usually written in the DOS code page 850, not in Windows-1252 or UTF-8. Opened in Excel or a text editor, the umlauts come out wrong, for example Größe as Gr”áe.
The viewer recognises code page 850, Windows-1252 and UTF-8 from the content and shows the texts correctly. The Excel and CSV exports are written in UTF-8, so the umlauts stay intact.
Prices, price units and discount groups
Datanorm writes prices in cents without a decimal point: 8900 means 89.00. The price unit says how many units the price is for, in Datanorm 4 as a code (0 = 1, 1 = 10, 2 = 100, 3 = 1,000 units), in Datanorm 5 as the quantity itself.
The discount group links an article to the discount your wholesaler grants you, and the price file marks each price as a list or a net price. The viewer shows both, with the group names from the WRG and RAB files.
What the quality report checks
Article numbers (present, not duplicated), short text, unit and price, the check digit of every EAN, a product group for every article, and whether product and discount groups appear in the WRG and RAB files. Missing long texts are listed too.
File notes point to prices for unknown articles, unreadable lines, a line count that does not match the end record and files that end early. The report shows gaps; it does not certify a file.
Datanorm in Mercura
Mercura takes your article data from Datanorm, BMEcat, Excel or straight from your ERP and suggests matching articles from it to your inside sales team for every enquiry, tender and order. Read more for distributors, plumbing and HVAC and electrical and lighting, about quotes and tenders and order processing, about ERP integration, AI for plumbing and HVAC wholesale and software for electrical wholesale.
FAQ
Questions about Datanorm.
Datanorm is a text format with which wholesalers and manufacturers send article data and prices to installers and their software, mainly in plumbing, heating and electrical. A delivery consists of several files such as DATANORM.001 (articles) and DATPREIS.001 (prices); versions 4 and 5 are in use.
Drop the files or the supplier’s ZIP into the viewer above. You see the header, every article with texts, unit, prices, product and discount group, and a quality report. The files are read in your browser and not uploaded.
Open the files and choose Excel or CSV. You get one row per article with number, short texts, unit, price and price unit, net price, product and discount groups with their names, EAN, manufacturer and long text. With filters set, only the articles shown are exported.
In Datanorm 4 the header line has fixed columns and the article data is split into an A and a B record. In Datanorm 5 every line is separated by semicolons and the article record also carries the manufacturer, the manufacturer’s article number and the EAN. The viewer opens both and recognises the version itself.
DATANORM.001 with the articles, DATPREIS.001 with prices, DATANORM.WRG with the product groups and DATANORM.RAB with the discount groups. Select all files at once or drop the ZIP; the viewer links prices and groups to the articles. Datanorm 3 is not supported.
Datanorm files are usually written in the DOS code page 850, which Excel and most editors do not expect, so Größe turns into Gr”áe. The viewer recognises code page 850, Windows-1252 and UTF-8 and exports in UTF-8, so the umlauts stay correct.
No. The viewer reads your files in the browser and sends nothing from them to Mercura or anyone else. Even deliveries with hundreds of thousands of articles are processed on your computer.
Mercura reads incoming enquiries, tenders and orders and suggests the matching articles from your catalogue for every item. It takes the article data from Datanorm, BMEcat, Excel or straight from your ERP.