Create or Import a spreadsheet

    To seamlessly integrate your data with your documents, begin by creating or importing a spreadsheet. Please follow the steps outlined below to complete this process.

`      1. Choose the required entity and the document in the document process screen.  Subsequently, click on the "Spreadsheet Layer" icon and you will redirected to the Homepage of Spreadsheet layer.

      2. Click the "Create New" button at the top right corner of the spreadsheet layer.

      3. Select the "Folder" option to create a directory for organizing your spreadsheets. This step helps keep your data neatly organized. If you prefer, you can skip this and directly create or import a spreadsheet within the spreadsheet layer.

You can move or duplicate the created folder to better organize your files.

Create a new spreadsheet:

To get started with a new spreadsheet within a document, follow these steps:

1. Select the "Spreadsheet" option to create an online spreadsheet.
   
2. This allows you to manually enter data and access essential spreadsheet features directly within the platform.
   

Import an Existing Spreadsheet:

If you already have a spreadsheet saved on your device and want to work with it in Rainbow for the document, follow these steps:

1. Choose "Import Spreadsheet" and choose the required spreadsheet from your device. 
2. Click "OK" and the spreadsheet will be imported into the Spreadsheet layer.
   
3. Once imported, your file will be fully accessible within Rainbow. This enables you to seamlessly continue working on your spreadsheet with all the features and tools application offers.
   

Spreadsheets can be moved, replicated, or replaced, providing flexibility in managing your data.

• Related Articles

• Spreadsheet Layer

  The Spreadsheet feature in Rainbow enables effortless integration of your source data residing in spreadsheets with the document in the application. Any modifications made to the integrated spreadsheet can be synchronized with the corresponding ...

• Modify values in the spreadsheet offline and reupload

  Keeping your spreadsheet data up-to-date is crucial for ensuring accurate and reliable information in your documents. Whether you need to make major or minor changes, the application provides a seamless way to modify and update your spreadsheet data. ...

• Create document

  To populate or modify content in your report followed by XBRL tagging, a dedicated workspace is required, which is created through document creation. To do this, please follow the steps provided below. Navigate to the Documents menu at the top-right ...

• Link spreadsheet data with the document

  Once data is imported into the application either by uploading a spreadsheet or creating a new spreadsheet, it can then be linked to the document available in the content layer. Follow the steps outlined below to effectively link data: To begin, ...

• Create user

  A "User" refers to a specifically identified individual who plays a role in preparing, reviewing, and filing documents. Follow the provided steps below to create a user. Admin >> User >> Add >> Submit Hover the mouse over the “Admin” menu at the top ...

• Popular Articles

• Sign in to the Rainbow application

  You can log in to the Rainbow application with the credentials (registered email address and password) shared by us. To access the login page, use the following URL: rainbow.datatracks.com Enter your registered email address and password. Click on ...

• Create entity

  An "Entity" is a term used to describe a company that's required to create and submit periodic reports to regulatory authorities in iXBRL format. It's important to note that a single firm can have multiple entities under its umbrella. To uniquely ...

• Create user

  A "User" refers to a specifically identified individual who plays a role in preparing, reviewing, and filing documents. Follow the provided steps below to create a user. Admin >> User >> Add >> Submit Hover the mouse over the “Admin” menu at the top ...

• Edit user

  In case you would like to modify the user details, you can change them by following the provided steps below. Admin >> User >> Edit >> Submit. 1. Hover the mouse over the “Admin” menu at the top right of your screen then select "User" to access and ...

• Create user role

  A "user role" is a defined set of permissions and privileges assigned to a user within the application. These roles are created to determine what actions a user can perform, what information they can access, and what functions they can execute within ...

• Recent Articles

• Direct Filing

  Direct Filing Option is available that simplifies the submission process of Edgar HTML and XBRL/iXBRL for various form types. Below are the outlined steps required to initiate and complete the Direct Filing process seamlessly. First step is to choose ...

• Unable to create return

  The error you are experiencing may be due to the expiration of HMRC’s Authorization (OAuth token). By following the steps outlined below, you will be able to reauthorize and continue with your submission. Steps to Revoke Authorization and Reauthorize ...

• Download document for offline review

  Once document is ready, you have the flexibility to download it offline in multiple formats such as HTML, PDF, or Word, depending on your needs. Follow the provided steps below. 1. In the Document Process screen, begin by choosing the required entity ...

• Create or Extend dimension

  Dimensions are applied in combination with an element to add a precise description to the value tagged in financial reporting. By using dimensions, you can specify various attributes of a financial fact, such as the product type, geographic region, ...

• Build calculation

  In the Presentation Tree Role, constructing and managing calculations is crucial for maintaining the accuracy of your financial data. This guide will lead you through the steps to create, update, and manage these calculations, ensuring that your data ...