Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Google Spreadsheet merupakan bagian dari rangkaian aplikasi produktivitas Google Dokumen. Google Spreadsheet memungkinkan Anda membuat dan memformat spreadsheet secara online, serta menggunakannya dengan orang lain secara bersamaan. Anda dapat membuat laporan Looker Studio langsung dari Google Spreadsheet.
Membuat laporan
Untuk membuat laporan baru dari Google Spreadsheet, ikuti langkah-langkah berikut:
Buka Google Spreadsheet tempat Anda ingin membuat laporan.
Di toolbar Google Spreadsheet, klik Ekstensi.
Di bagian Looker Studio pada menu Extensions, pilih Buat laporan baru. Google Spreadsheet akan menampilkan panel Pembuatan laporan Looker Studio.
(Opsional) Konfigurasi opsi laporan di Google Spreadsheet.
Klik Buat. Looker Studio akan terbuka di tab baru dan membuat laporan dari spreadsheet.
Jika tidak memiliki akun Looker Studio, Anda akan diminta untuk membuat akun. Masukkan negara dan nama perusahaan Anda.
Untuk menyimpan laporan, klik Simpan dan bagikan.
Jika Anda tidak mengklik Simpan dan bagikan, laporan akan dihapus setelah 24 jam.
Opsi Gunakan baris pertama sebagai header menyebabkan sumber data menggunakan konten dari baris pertama di lembar kerja sebagai nama kolom di sumber data. Jika opsi ini tidak dipilih, nama kolom akan menggunakan indeks kolom (A, B, C, dst.).
Opsi Sertakan sel yang disembunyikan dan difilter memungkinkan Anda menyertakan atau mengecualikan data ini dari sumber data. Nilai default-nya adalah menyertakan sel tersebut. Opsi ini hanya berlaku untuk filter, bukan untuk tampilan yang difilter. Pelajari filter lebih lanjut di Pusat Bantuan Spreadsheet.
Opsi Sertakan rentang yang dipilih memungkinkan Anda menentukan rentang sel di lembar kerja yang dipilih. Gunakan sintaksis kolom-baris standar untuk menentukan rentang: misalnya, A1:Z26.
Memperbarui sumber data
Saat Anda membuat laporan dari Google Spreadsheet, Looker Studio akan membuat sumber data baru untuk Spreadsheet.
Untuk memperbarui sumber data, ikuti langkah-langkah berikut:
Saat membuat laporan dari Google Spreadsheet, perhatikan pertimbangan berikut:
Secara default, nama laporan akan menjadi Looker Studio Reporting - <timestamp>, dengan <timestamp> adalah tanggal dan waktu laporan Looker Studio dibuat.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-07-31 UTC."],[],[],null,["# Create a report from Google Sheets\n\nGoogle Sheets is part of the Google Docs suite of productivity apps. Google Sheets lets you create and format online spreadsheets and work on them simultaneously with others. You can create a Looker Studio report directly from Google Sheets.\n\nCreate a report\n---------------\n\nTo create a new report from Google Sheets, follow these steps:\n\n1. Navigate to the Google Sheet from which you would like to create a report.\n2. In the Google Sheets toolbar, click **Extensions**.\n3. In the **Looker Studio** section of the **Extensions** menu, select **Create a new report** . Google Sheets displays the **Looker Studio report creation** panel.\n4. Optionally, configure report options in Google Sheets.\n5. Click **Create**. Looker Studio opens in a new tab and creates a report from the sheet.\n6. If you don't have a Looker Studio account, you will be prompted to create an account. Enter your country and your company name.\n7. To save the report, click **Save and share** .\n - If you don't click **Save and share**, the report will be deleted after 24 hours.\n\nAfter you save the report, you can [edit the report](/looker/docs/studio/edit-a-report) and [share the report](/looker/docs/studio/ways-to-share-your-reports).\n\n### Options\n\n- **Use first row as headers** causes the data source to use the contents of the first row in your worksheet as the field names in the data source. If this option is not selected, the field names will use the column index (A, B, C, etc.).\n- **Include hidden and filtered cells** lets you include or exclude this data from the data source. The default value is to include them. This option applies only to filters, not to filtered views. Learn more about filters in the [Sheets Help Center](https://support.google.com/docs/answer/3540681).\n- **Include selected range** lets you define a range of cells in the selected worksheet. Use standard column-row syntax to define the range: for example, A1:Z26.\n\nUpdate the data source\n----------------------\n\nWhen you create a report from Google Sheets, Looker Studio creates a new data source for the Sheet.\n\nTo update the data source, follow these steps:\n\n- If the data in the Sheet has changed, [manually refresh your report data](/looker/docs/studio/manage-data-freshness).\n- If columns have been added or edited in the Sheet, [refresh the data source fields](/looker/docs/studio/refresh-data-source-fields).\n\nThings to consider\n------------------\n\nWhile creating reports from Google Sheets, keep the following considerations in mind:\n\n- By default, the name of the report will be `Looker Studio Reporting - \u003ctimestamp\u003e`, where `\u003ctimestamp\u003e` is the date and time that the Looker Studio report was created.\n- Your data must be in a tabular format. Learn more about [how to prepare your Google Sheets to work with Looker Studio](/looker/docs/studio/tutorial-create-a-google-sheets-data-source).\n- Merged cells are not supported. Unmerge all cells before creating a report.\n- The header row must be a single row.\n- All cells within a column should be of the same type.\n- Make sure that your date fields are formatted using the `Date` data type, so that Looker Studio can correctly interpret them as dates for the report.\n\nRelated resources\n-----------------\n\n- [About Google Sheets](https://www.google.com/sheets/about/)\n- [Connect to Google Sheets](/looker/docs/studio/connect-to-google-sheets)\n- [Tutorial: Create a Google Sheets data source](/looker/docs/studio/tutorial-create-a-google-sheets-data-source)"]]