In Anaplan Add-on for Google Sheets, you can clone an Anaplan connection to duplicate the connection and copy cell data into a new worksheet. If you edit the data in the new worksheet, the data in the original worksheet remains unchanged.

You must sign in to the add-on to clone a connection.

If you clone a read-write connection, the new connection is also read-write. You can use the cloned read-write connection to update Anaplan. To create a read-only connection with the same connection details, create a new connection in another worksheet.

To copy the Anaplan connection and cell data into a new sheet, on the Anaplan sidebar, select Clone connection. The new sheet has the same name as the original sheet, with a number at the end. For example, Sheet name (1). You can rename the cloned worksheet at any time without affecting the connection.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.