> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect your Chargebee to Spreadsheets

> Effortlessly connect Chargebee to Google Sheets or Microsoft Excel in a few clicks using Superjoin

<Tabs>
  <Tab id="gsheets" title="Google Sheets">
    ### Why use Superjoin's Google Sheets-Chargebee Integration?

    <CardGroup cols={2}>
      <Card title="Quick and Easy Integration" icon="plug" iconType="duotone">
        We've meticulously organized the data points to ensure easy accessibility in a format you're already familiar with.
      </Card>

      <Card title="Preview your imports visually" icon="magnifying-glass" iconType="duotone">
        Get a sneak peek of your data. Select columns, apply filters & limits as per
        your need before importing.
      </Card>

      <Card title="Automatic Refreshes" icon="rotate" iconType="duotone">
        Enjoy one-click refreshes or schedule regular updates to ensure your sheets
        are always up to date.
      </Card>

      <Card title="Power of Google Sheets" icon="table-cells" iconType="duotone">
        Benefit from Google Sheets' collaborative data analysis & other powerful
        capabilities.
      </Card>
    </CardGroup>

    ## Step-by-step walkthrough: How to connect Chargebee to Google Sheets

    <iframe width="560" height="415" src="https://www.youtube.com/embed/4agoTSBWgMI?si=b9o0AFTsZexz_HAX" title="Pull data from Chargebee to Google Sheets" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowFullScreen style={{ width: "100%", borderRadius: "0.5rem" }} />

    <Steps titleSize="h3">
      <Step title="Get Add-ons">
        Head over to `Extensions` , select `Add-ons` and choose `Get Add-ons`. This action will redirect you to the Google Workspace Marketplace.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/getaddons.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=ba23d07d1410cd3afb25454c5581cc85" width="1361" height="648" data-path="images/getaddons.png" />
        </Frame>
      </Step>

      <Step title="Search Superjoin">
        In the Google Workspace Marketplace pop-up window, search for "Superjoin".
      </Step>

      <Step title="Click on Install">
        Click on the `Install` button to install Superjoin.
        <Note>**Note:** For the best experience, install Superjoin where there's only a single account is logged in the Chrome profile.</Note>

        <Frame>
          <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/marketplace.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=8b32a5ed819c10448985a7e3df6f7731" width="966" height="884" data-path="images/marketplace.png" />
        </Frame>
      </Step>

      <Step title="Launch Superjoin">
        Once installed, navigate back to the `Extensions` menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.

        <Frame>
          <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/launchstackit.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=14e2ecb541402cb914b79951a8faff16" width="1347" height="543" data-path="images/launchstackit.png" />
        </Frame>
      </Step>

      <Step title="Navigate to Queries">
        To begin, you can navigate to `Queries` , choose to  `Create new query`.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/homepage(1).png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=1c17e01007e88a018f54ce4c4fa0c8f5" width="1314" height="1426" data-path="images/chargebee/homepage(1).png" />
        </Frame>
      </Step>

      <Step title="Connect a New Source">
        Navigate to `Sources`, select `Connect to a new source` and search for `Chargebee`.

        <Frame>
          <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/microsftsql/newconnection.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=b7baa8c21b7f30c69bdc5d8a4ac1bde1" width="1314" height="1426" data-path="images/microsftsql/newconnection.png" />
        </Frame>
      </Step>

      <Step title="Link Account">
        Click on the `Connect` button and follow the on-screen instructions to link your account. Your site name should be the part of the URL before `.chargebee.com`.

        <CardGroup cols={1}>
          <Card title="Create new API key in Chargebee" icon="key" iconType="duotone" href="../chargebee/create-key">
            Step-by-step guide to obtain or generate Chargebee API key
          </Card>
        </CardGroup>

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/link:connectstep7.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=7d935a087f2854f742cc701ec0f348a0" width="1320" height="1440" data-path="images/chargebee/link:connectstep7.png" />
        </Frame>
      </Step>

      <Step title="Preview Data">
        After connecting your account, a data preview window will appear, allowing you to modify your `Objects` and apply various `Filters` to refine your data. You can also select a `Drilldown` if needed.

        <Info>
          Drilldown allows you to fetch more granular data contained within each of the selected object.
        </Info>

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/previewdata-step8.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=91ad5a0c8e2c78d96074176e5b2b5f73" width="2430" height="1414" data-path="images/chargebee/previewdata-step8.png" />
        </Frame>
      </Step>

      <Step title="Add/Modify columns">
        Add/modify the data fields you want to import, the `Fields` you selected should start showing up in the data preview section.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/Add:modifydata-step9.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=3c225ffa4bffe8adccf6e23c6383d42e" width="2310" height="1204" data-path="images/chargebee/Add:modifydata-step9.png" />
        </Frame>
      </Step>

      <Step title="Import Data">
        After previewing the data, click on `Import` and wait for a few seconds. This action transfers all data from your Chargebee account into Google Sheets.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/Import-step10.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=b32468b9e6025915cfbd5bab1e6b106e" width="2879" height="1623" data-path="images/chargebee/Import-step10.png" />
        </Frame>
      </Step>

      <Step title="Setup Auto-Refresh">
        You can schedule a `Refresh` to automatically update your data daily, weekly, or monthly at a specific time.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/Auto-step11.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=000089efd856317b62135a64dfbe7990" width="2879" height="1622" data-path="images/chargebee/Auto-step11.png" />
        </Frame>
      </Step>
    </Steps>
  </Tab>

  <Tab id="excel" title="Microsoft Excel">
    ### Why use Superjoin's Excel-Chargebee Integration?

    <CardGroup cols={2}>
      <Card title="Quick and Easy Integration" icon="plug" iconType="duotone">
        We've meticulously organized the data points to ensure easy accessibility in a format you're already familiar
        with.
      </Card>

      <Card title="Preview your imports visually" icon="magnifying-glass" iconType="duotone">
        Get a sneak peek of your data. Select columns, apply filters & limits as per
        your need before importing.
      </Card>

      <Card title="One-Click Refreshes" icon="rotate" iconType="duotone">
        Enjoy one-click refreshes to ensure your sheets are always up to date.
      </Card>

      <Card title="Power of Microsoft Excel" icon="table-cells" iconType="duotone">
        Benefit from Microsoft Excel's powerful data analysis & visualization capabilities.
      </Card>
    </CardGroup>

    ## Step-by-step walkthrough: How to connect Chargebee to Microsoft Excel

    <Steps titleSize="h3">
      <Step title="Launch Add-ins">
        Click on `Add-ins` on the right side of the Excel toolbar.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/get-addins.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=9a602917c1d56ab7f30977dc0f467293" width="2880" height="1800" data-path="images/get-addins.png" />
        </Frame>
      </Step>

      <Step title="Get Add-in">
        Click on the searchbar and type "Superjoin". The results would show our add-in under the `More search results` section.

        <Frame>
          <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/excel-addin.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=2eaebe9dbede327814e129893f551325" width="491" height="665" data-path="images/excel-addin.png" />
        </Frame>
      </Step>

      <Step title="Authenticate with your Microsoft Account">
        Once Superjoin launches as a side panel, just click on `Sign in with Microsoft` and follow the steps to authenticate your Microsoft Office account with Superjoin.

        <Frame>
          <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/excel-auth.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=052b68df7e66f275c750ff01d446ac50" width="2560" height="1440" data-path="images/excel-auth.png" />
        </Frame>
      </Step>

      <Step title="Launch Superjoin">
        You should now see Superjoin running as a side panel on the right side of your screen.

        <Frame>
          <img src="https://mintcdn.com/superjoin/Fj1m3rGY5-lshl-N/images/excel-superjoin.png?fit=max&auto=format&n=Fj1m3rGY5-lshl-N&q=85&s=ec2d8be38abd9d4fa3fcb9b4fca35788" width="2560" height="1440" data-path="images/excel-superjoin.png" />
        </Frame>
      </Step>

      <Step title="Navigate to Queries">
        To begin, you can navigate to `Queries`, choose to `Create new query`.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/homepage(1).png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=1c17e01007e88a018f54ce4c4fa0c8f5" alt="Navigate to Queries" width="1314" height="1426" data-path="images/chargebee/homepage(1).png" />
        </Frame>
      </Step>

      <Step title="Connect a New Source">
        Navigate to `Sources`, select `Connect to a new source` and search for `Chargebee`.

        <Frame>
          <img src="https://mintcdn.com/superjoin/gjRFjFkthepgDSdX/images/microsftsql/newconnection.png?fit=max&auto=format&n=gjRFjFkthepgDSdX&q=85&s=b7baa8c21b7f30c69bdc5d8a4ac1bde1" alt="Connect a New Source" width="1314" height="1426" data-path="images/microsftsql/newconnection.png" />
        </Frame>
      </Step>

      <Step title="Link Account">
        Click on the `Connect` button and follow the on-screen instructions to link your account. Your site name should be the part of the URL before `.chargebee.com`.

        <CardGroup cols={1}>
          <Card title="Create new API key in Chargebee" icon="key" iconType="duotone" href="../chargebee/create-key">
            Step-by-step guide to obtain or generate Chargebee API key
          </Card>
        </CardGroup>

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/link:connectstep7.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=7d935a087f2854f742cc701ec0f348a0" alt="Link Account" width="1320" height="1440" data-path="images/chargebee/link:connectstep7.png" />
        </Frame>
      </Step>

      <Step title="Preview Data">
        After connecting your account, a data preview window will appear, allowing you to modify your `Objects` and apply various `Filters` to refine your data. You can also select a `Drilldown` if needed.

        <Info>
          Drilldown allows you to fetch more granular data contained within each of the selected object.
        </Info>

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/previewdata-step8.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=91ad5a0c8e2c78d96074176e5b2b5f73" alt="Preview Data" width="2430" height="1414" data-path="images/chargebee/previewdata-step8.png" />
        </Frame>
      </Step>

      <Step title="Add/Modify columns">
        Add/modify the data fields you want to import, the `Fields` you selected should start showing up in the data preview section.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/Add:modifydata-step9.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=3c225ffa4bffe8adccf6e23c6383d42e" alt="Add/Modify columns" width="2310" height="1204" data-path="images/chargebee/Add:modifydata-step9.png" />
        </Frame>
      </Step>

      <Step title="Import Data">
        After previewing the data, click on `Import` and wait for a few seconds. This action transfers all data from your Chargebee account into Microsoft Excel.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/Import-step10.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=b32468b9e6025915cfbd5bab1e6b106e" alt="Import Data" width="2879" height="1623" data-path="images/chargebee/Import-step10.png" />
        </Frame>
      </Step>

      <Step title="Refresh Your Data">
        Your data has been imported successfully! You can refresh your data at any time by clicking the refresh button in the Superjoin panel.

        <Frame>
          <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/Auto-step11.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=000089efd856317b62135a64dfbe7990" alt="Refresh Data" width="2879" height="1622" data-path="images/chargebee/Auto-step11.png" />
        </Frame>
      </Step>
    </Steps>
  </Tab>
</Tabs>

##### Hope this guide helped you connect Chargebee to your spreadsheet using Superjoin.

##### If you have any questions or need further assistance, please don't hesitate to reach out to our support team at [support@superjoin.ai](mailto:support@superjoin.ai). Thank you!