web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
Posted on by greex 104

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

pastedimage1665494537355v1.png

pastedimage1665494445845v2.png

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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,153 Moderator on at

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

    www.kauffmann.nl/.../

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,682 Moderator on at

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,170 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,283 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,104 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans