Data Exports and Reports are really the same thing. They use the same syntax and tags. The only difference is that a Report shows on-screen (an/or can be printed), while a Data Export saves it’s output to a file.
So get the Report working to show the data you want, then worry about the formatting. As @JTRTech mentions, you need to apply a filter for the Entity Type. This comes after the first colon. This should work:
(ET=Customers)
The formatting is the part after the final colon where you choose your fields and delimiters, and is the easy part - you use commas (,
) or semi-colons (;
) to separate the fields instead of pipes (|
).
Export CSV
Customer Details
Name,Address,Phone Number,e-mail address
{REPORT ENTITY DETAILS:E.Name.asc,EC.Address,EC.Phone Number,EC.e-mail address:(ET=Customers):{0},{1},{2},{3}}
Export CSV in Excel
Report