Converting old XLS Form into new XLS Form template

AlainChouinard

The new XLS Form template coming with newest versions of Survey123 Connect is very valuable, with new features and a clearer presentation of the various parameters. But it seems that the columns are no longer in the same order as in the old template. Is there an easy way to import an old XLS Form file into the new template, to update an existing survey? I could copy and paste the columns one by one, but this operation is clumsy and there's a high risk of error.

Thanks for your help !

Jim Moore

Hi @AlainChouinard 

The suggestion from @Anonymous User is a good one - if you get the column order set up in another workbook first, you can then copy/paste the whole lot into the new template (at cell A2). Should be significantly quicker than copying each column one-by-one. It is recommended to always use the paste values option when copying and pasting any content (cells, rows, ranges) in the survey worksheet, as this will ensure the data validation is preserved and erroneous links to other workbooks are not created.

Please see this blog post for a few best practices that might be of use.

Best,

Jim