Share
ReportHi! How can I seperate data to another Excel's columns using Query method SaveAsCsv?
I need to get each 'field' in another column.
You’re offline. This is a read only version of the page.
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.
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).
Why not use the ExcelBuffer an create an Excel file instead if that is what you really need?
#1
André Arnaud de Cal...
292,886
Super User 2025 Season 1
#2
Martin Dráb
231,768
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
