The profile export does not interact directly with Excel; in fact you may have noticed that, when you export to an Excel file, PCensus actually creates an html file that can be opened as a spreadsheet in Excel (this is a feature of Excel). Once the file is opened in Excel, you can, if you wish, save it as an xls file.
This export process cannot link directly to Excel templates.
Several users have been able to overcome this limitation as follows:
- Create a multi-sheet xls workbook, with the first work-sheet set up with your desired content and formatting.
- Export a profile page from PCensus to Excel
- Select the entire worksheet from your export file, and copy and paste it to the second worksheet of your formatted workbook.
- Populate the data fields in your formatted sheet using references to the pasted data in the second worksheet.
Because the profile worksheet exported from PCensus always has the same layout, you can refresh the data in your worksheet by pasting new exported files into the second sheet.
The attached worksheet gives a simple example of the process descibed above.
