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

# Import data from Google Sheet or Microsoft Excel to Locker

> Follow the below steps to import passwords from a Google Sheet or Microsoft Excel file into Locker.

If you are managing your passwords in Google Sheet or in a Microsoft Excel Sheet, you can import the file to Locker using the Google Password Manager template.

## Organize data with Google Password Manager template

First, you need to organize all your passwords with a given template. This ensures that the password details are accurately placed in the respective fields when imported into Locker.

Arrange your passwords as in the template below. You can also make a copy of the template by clicking **File** > **Make a copy**.

| name           | url                                                  | username                                      | password          | note               |
| -------------- | ---------------------------------------------------- | --------------------------------------------- | ----------------- | ------------------ |
| Github account | [https://github.com/login](https://github.com/login) | [example@gmail.com](mailto:example@gmail.com) | DVRegef32t5rfsacd | This is an example |

## Save your file as CSV format

After organizing your passwords in the correct template, save your Google Sheet file or Excel Sheet file as a CSV file.

### Google Sheet file

<Steps>
  <Step title="Open the Google Sheet file">
    Open the Google Sheet file containing your passwords.
  </Step>

  <Step title="Download as CSV">
    Click **File** > **Download** > **Comma Separated Values (.csv)**.

    <img src="https://mintcdn.com/locker/QUgTEfHYF1luiq3D/images/en/locker-password-manager/get-started/import-and-export/google-sheets-download-csv.png?fit=max&auto=format&n=QUgTEfHYF1luiq3D&q=85&s=7b7deb8b8d0edb10dbe6e68e795bef83" alt="Download as CSV from Google Sheets" style={{display: 'block', margin: '0 auto'}} width="820" height="617" data-path="images/en/locker-password-manager/get-started/import-and-export/google-sheets-download-csv.png" />
  </Step>
</Steps>

### Excel Sheet file

<Steps>
  <Step title="Open the Excel Sheet file">
    Open the Excel Sheet file containing your passwords, then click **File** at the top left corner.
  </Step>

  <Step title="Save as CSV">
    Click **Save as** > click **Browse** to choose where you want to save your file.

    <img src="https://mintcdn.com/locker/DGmCYM1Opanpr-4x/images/en/locker-password-manager/get-started/import-and-export/excel-save-as-browse.png?fit=max&auto=format&n=DGmCYM1Opanpr-4x&q=85&s=03310e0ee89a627dc13294c5a1ab9a6c" alt="Excel Save As" style={{display: 'block', margin: '0 auto'}} width="729" height="413" data-path="images/en/locker-password-manager/get-started/import-and-export/excel-save-as-browse.png" />

    Select **CSV** from the **Save as type** drop-down menu, then click **Save**.

    <img src="https://mintcdn.com/locker/DGmCYM1Opanpr-4x/images/en/locker-password-manager/get-started/import-and-export/excel-save-as-csv.png?fit=max&auto=format&n=DGmCYM1Opanpr-4x&q=85&s=ab9f3c13caf45d11fc7c33275cbc0ce8" alt="Select CSV format in Excel" style={{display: 'block', margin: '0 auto'}} width="273" height="69" data-path="images/en/locker-password-manager/get-started/import-and-export/excel-save-as-csv.png" />
  </Step>
</Steps>

## Import to Locker

Use the Locker web vault to import your data.

<Steps>
  <Step title="Open Locker">
    Open Locker on your browser.
  </Step>

  <Step title="Navigate to Import/Export">
    Select **Settings** > **Import/Export**.
  </Step>

  <Step title="Scroll to Import section">
    Scroll down to the **Import** section.
  </Step>

  <Step title="Select format">
    Select **Chrome (csv)** as the format from the drop-down menu.

    <img src="https://mintcdn.com/locker/QUgTEfHYF1luiq3D/images/en/locker-password-manager/get-started/import-and-export/locker-import-format-dropdown.png?fit=max&auto=format&n=QUgTEfHYF1luiq3D&q=85&s=da37d367d5bd5f1fecb6f7392717a015" alt="Select import format in Locker" style={{display: 'block', margin: '0 auto'}} width="509" height="441" data-path="images/en/locker-password-manager/get-started/import-and-export/locker-import-format-dropdown.png" />
  </Step>

  <Step title="Upload the file">
    Click **Choose File** and upload the import file on your device.
  </Step>

  <Step title="Import">
    Click **Import**.
  </Step>
</Steps>

Your login credentials have been successfully imported from the CSV file to the Locker vault.