web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Query - SaveAsCsv - ho...

Small and medium business | Business Central, N...

Suggested Answer

Query - SaveAsCsv - how to seperate data?

(0) Share

Report

Report

Posted on by greex

104

Hi! How can I seperate data to another Excel's columns using Query method SaveAsCsv?

I need to get each 'field' in another column.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Why not use the ExcelBuffer an create an Excel file instead if that is what you really need?

www.kauffmann.nl/.../

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

The Query exports a csv file, that is not an Excel file.

If you first open Excel, then in Excel open the csv file, you can import the data and using the delimiter spread it in different columns.

Another solution is indeed using excelbuffer to create the Excel file.

Another solution is to use Excel to import the Query, after you publish the query as a web service (or API).

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,664

#2

YUN ZHU 960 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans