[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間：2025-09-05 (世界標準時間)。"],[],[],null,["# Upload CSV files to Looker reports\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This product or feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA products and features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n| **Note:** For information about uploading CSV files to Looker Studio, see [Upload CSV files to Looker Studio](/looker/docs/studio/upload-csv-files-to-looker-studio).\n\nYou can bring data into Looker reports from any source that provides CSV (comma-separated values) files. You can upload CSV files directly from your computer.\n| **Note:** Uploading data to Looker reports using CSV file upload is free.\n\nCreate a CSV file data source\n-----------------------------\n\nLooker reports store uploaded CSV files in data sets. A data set can contain one or more CSV files with the same column headers. A CSV file data source can contain one or more data sets.\n\nTo create a new CSV file data source, follow these steps:\n\n1. Open a Looker report.\n2. Click the **Create** button and then select **Data source**.\n3. Select the **CSV file upload** Google connector.\n4. Create a new data set by clicking the **Add data set** button.\n - You can also drag one or more CSV files to the **Available data sets** section, and the Looker report will create a new data set that contains the uploaded files.\n5. When you have finished uploading files, click the **Connect** button.\n\nYour uploaded data is stored in Cloud Storage. There are many benefits to this storage setup, including both the ability to access and download your data from the cloud and the ability to use other Google Cloud services with your data.\n\n[Learn more about Cloud Storage](/storage/docs).\n\nAdd CSV files to a data set\n---------------------------\n\nYou can upload multiple files to a data set, as long as the column headers match. When you add new files, that data gets appended to the data set. This lets you update your data as time goes on.\n\nTo add CSV files to a data set, follow these steps:\n\n1. Open a Looker report.\n2. Click the **Data sources** tab.\n3. Select the data source that contains your CSV files.\n4. Click **Edit Connection**.\n5. From the **Available data sets** section, select the data set from which you'd like to add files.\n6. Click the **Add file** button.\n - You can also drag one or more CSV files to the **Files in the data set** section.\n7. Once you have finished uploading files, click the **Reconnect** button.\n\n| **Note:** Uploaded data is appended (added) to existing data, not merged with it. The Looker report does not remove duplicate records that may be shared across your CSV files.\n\nSharing data sets\n-----------------\n\nThe data sets that you create belong to you and are not shareable. However, once you create a data source that is based on your data set, you can [share that data source](/looker/docs/studio/share-reusable-data-sources) with other users. This means that your data sets can be used in shared data sources and reports, but only you can access the data set itself.\n\nUpload file format\n------------------\n\nConfirm that the files you upload are correctly formatted. Otherwise, errors might occur during the upload, or your data may not look right in your reports.\n\nA common cause of content errors is the improper use of separators, quotation marks, and line break characters in the uploaded data. Understanding how CSV file upload handles these can save you trouble in the future.\n\n### UTF-8 encoding\n\nYour upload file should be in UTF-8 encoding. This is a standard encoding for most applications on the web.\n\nHowever, if you are exporting data from certain desktop products, such as Microsoft Excel™, you may need to convert your file to UTF-8 before you upload it to a Looker report. Otherwise, the Looker report may return an error message such as `File is Invalid.`\n\n### Only tabular data\n\nCSV file upload can only import files of tabular data. This means that your files must have a regular structure of rows and columns. Each row must have the same number of columns, even if data is missing for a particular cell in the table. Trying to upload a file with merged cells, or an inconsistent structure, will fail with an upload error.\n| **Important:** Every file you upload to a given data set must have exactly the same structure, with the same fields in the same order.\n|\n| If you need to add or delete fields in an existing data set, you must delete all the previously uploaded files before uploading files with the new structure. (Or create a new data set using the new file structure.)\n\n### Separators\n\nAll the fields in your data must be separated from each other by commas.\n\nIf there are commas within the actual data in a field you want to upload, that field must be surrounded by quotes. If your data includes double quotes, you can use a single quote character to surround the field.\n\n### Header row\n\nThe first line in your file must be a header row. This row will tell the Looker report how to name your fields. Field names must be unique, so you can't have duplicate values in your header row.\n\nColumn names must:\n\n- Contain only letters, numbers, or underscores. Other punctuation or special characters are not allowed.\n- Start with a letter or underscore\n- Be at most 128 characters long\n\nThe header row must also follow the [rules for separators](#separators).\n\n### Line breaks\n\nEach line in the file must end with a line break. CSV file upload does not support line breaks in your data even if these are escaped by quotes.\n\nTroubleshooting\n---------------\n\nThe following sections describe common errors that you may see while uploading CSV files.\n\n### Error: File is Invalid\n\nIf Looker displays the error `File is Invalid` after attempting to upload a CSV file, check for the following possible causes:\n\n- The file contains [invalid UTF-8 characters](#utf8).\n- The file is not actually a CSV file. For example, if you rename a PDF file to use the \".csv\" extension, then the Looker report won't be able to properly parse the file.\n\nLimits of CSV file upload\n-------------------------\n\nCSV file upload is subject to the following limits:\n\n- 1000 data sets per user\n- 2GB total storage per user\n- 100 uploads per data set per day\n- 100MB file size limit per data set\n\nRelated resources\n-----------------\n\n[About data sources](/looker/docs/studio/about-data-sources)"]]
