This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 80%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
I'm wondering if there is a way to create a Visio diagram from a CSV file created from within a UWP application.
I can create the CSV file, but I cannot find any way to turn that CSV file into a data visualizer template and then use that template to create the Visio diagram.
I am able to do it by hand from the programmatically created CSV file, but it's labour intensive and not something I can put into a user's hand because it's too complicated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In all Data Visualizer description we can read that it get data from Excel!
Try convert csv to xls(x) file format.
Yes, I understand that it requires an Excel workbook to create.
What I am trying to do is to go from a CSV file, to a Workbook, to a Visio document all through code in a UWP application.
Part of the challenge to this is that the Workbook needs to a specific type of workbook (which I haven't been able to figure out how it's different than any other workbook).
My thinking was something like this:
How to accomplish that is the challenge.
You can open csv-file with Excel application and save it as Excel's native format (but it workbook must have table headers).
After this step you can import this data with special Data Visualizer's wizard.
You may use Excel's Get & Transform (Power Query) to import CSV data into Excel, I would update my previous reply.
Perhaps I'm being unclear. I am able to create the CSV file from my application data, copy it into an Excel Data Visualizer template, and then export it to a Visio diagram.
The problem is, I'm trying to do that programmatically from a UWP application, such that the user simply clicks the "Export to Visio" button and these steps are all handled in code to produce the diagram without the user ever having to manually go through the steps I mentioned above.
Sorry, your request involves application development, it is out of my supported scope as we are responsible for general issues of Office desktop applications.
Maybe you could ask this question in Office developer community. Thanks for your understanding.
Hi Paul,
On my test environment with Visio Plan 2, when using a Data Visualizer template to create a Visio diagram, it needs a Excel workbook, the supported formats are .xlsx, .xlsm, .xlsb, .xls, .xlw, and there is no .csv.
Could you please transfer the CSV file to one of the supported formats above?
--------Update--------
In addition to the function of Save As, you could also connect CSV file in Excel via Power Query, then save it as a Excel workbooks with those formats above. If you are importing data from a CSV file, Power Query will automatically detect column delimiters including column names and types.
More information, please refer to "Import data from external data sources (Power Query)".