Click Next.Īfter you click Finish on the last page of the Data Selector wizard, the External Data window appears with your imported data shown in a table. If you decide to refresh the imported data later, this unique identifier will enable Visio to find the updated row in the source, retrieve it, and then update the diagram. On the Configure Refresh Unique Identifier page, select the check box for the column that contains unique values. Click Next, and then specify the columns and rows to include. If you chose an Excel workbook, choose the sheet, select the range of cells, and specify whether your data includes column headings. On the first page of the Data Selector wizard, choose a data source, and then click Next.Ĭlick Browse, and then select the source you want to import, and then click Next. If the Quick Import option didn't work as you expect, or you have another data source to import, you can do a custom import of your data. If that happens, use the Custom Import process described in the next section below.Ĭustom import process for all data sources

If the Quick Import option doesn't succeed, you'll see a message like the illustration below, indicating that some part of the import process didn't work. If you don’t see data graphics on all the shapes, Visio wasn’t able to link some rows to some shapes. Check out the “Next steps” at the bottom of this article. If you see data graphics on each and every shape, Visio was able to automatically link rows to the shapes. Then, in the Import to Visio box, click Import, and then click Done. Make sure to include any headers above the columns. If the Import to Visio box and the Excel program appear, click the sheet tab where your data is, and then drag to select your data. Note: If you're using Visio 2010, on the Data tab, in the External Data group, click Link Data to Shapes.Ĭlick Browse, and then select the workbook you want to import.

Import synology stencile visio