--- title: How to Import Data Sheets description: If you have data that you’d like to import into an app or fields you’d like to update all at once, you can use the Import from CSV/Excel feature to do so. image: https://blog.kintone.com/hubfs/1-37.png --- [![Kintone](https://blog.kintone.com/hubfs/KintoneGlobal/svg/logo_kinton_black.svg)](https://www.kintone.com/en-us/) [![Kintone](https://blog.kintone.com/hubfs/KintoneGlobal/svg/logo_kinton_black.svg)](https://www.kintone.com/en-us/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_black.svg) - Product Product![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - Product ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Intro to Kintone](https://www.kintone.com/en-us/intro/) - [Why Kintone](https://www.kintone.com/en-us/why-kintone/) - Features ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [How Kintone Works](https://www.kintone.com/en-us/how-kintone-works/) - [App Template Library](https://www.kintone.com/en-us/features/app-templates/) - [Extensions](https://www.kintone.com/en-us/features/extensions/) - [Native Kintone Plug-ins](https://www.kintone.com/en-us/features/plugins/) - [Kintone AI](https://www.kintone.com/en-us/features/ai/) - [System Administration](https://www.kintone.com/en-us/features/administration/) - [Security](https://www.kintone.com/en-us/security/) - Solutions Solutions![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Solutions by Department](https://www.kintone.com/en-us/departments/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Operations](https://www.kintone.com/en-us/departments/business-operations/) - [Sales](https://www.kintone.com/en-us/departments/sales/) - [Customer Support](https://www.kintone.com/en-us/departments/customer-support/) - [HR & Admin](https://www.kintone.com/en-us/departments/hr-admin/) - [Marketing](https://www.kintone.com/en-us/departments/marketing/) - [Manufacturing & Retail Management](https://www.kintone.com/en-us/departments/manufacturing-retail-management/) - [IT Support](https://www.kintone.com/en-us/departments/it-support/) - [Solutions by Function](https://www.kintone.com/en-us/functions/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Convert spreadsheets to databases](https://www.kintone.com/en-us/functions/convert-spreadsheets-to-databases/) - [Data Management](https://www.kintone.com/en-us/functions/data-management/) - [CRM & Sales Management](https://www.kintone.com/en-us/functions/crm-sales-management/) - [Project Management](https://www.kintone.com/en-us/functions/project-management/) - [Workflow Management](https://www.kintone.com/en-us/functions/workflow/) - [Remote Work](https://www.kintone.com/en-us/functions/remote-work/) - [Recruitment & Hiring](https://www.kintone.com/en-us/functions/recruitment-hiring/) - [Solutions by Industry](https://www.kintone.com/en-us/industries/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Manufacturing](https://www.kintone.com/en-us/industries/manufacturing/) - [Real Estate](https://www.kintone.com/en-us/industries/real-estate/) - [Retail](https://www.kintone.com/en-us/industries/retail/) - [Education](https://www.kintone.com/en-us/industries/education/) - [Hospitality](https://www.kintone.com/en-us/industries/hospitality/) - [Healthcare](https://www.kintone.com/en-us/industries/healthcare/) - [Nonprofit](https://www.kintone.com/en-us/industries/nonprofit/) - [Solutions by Problem](https://www.kintone.com/en-us/problems/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Streamline Operations and Processes](https://www.kintone.com/en-us/problems/streamline-operations-and-processes/) - [Manage and Organize Business Data](https://www.kintone.com/en-us/problems/manage-and-organize-business-data/) - [Track Project Status and Accountability](https://www.kintone.com/en-us/problems/tracking-project-status-and-accountability/) - [Customer Stories](https://www.kintone.com/en-us/customer-stories/) - [Pricing](https://www.kintone.com/en-us/pricing/) - Resources Resources![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Webinars](https://www.kintone.com/en-us/events/) - [Guidebooks & Videos](https://www.kintone.com/en-us/guidebooks-and-videos/) - [Kintone Support Overview](https://www.kintone.com/en-us/support-overview/) - [Developers](https://kintone.dev/en/) - [Customer Resource](https://www.kintone.com/en-us/for-customers/) - [Blog](https://blog.kintone.com/business-with-heart?__hstc=181257784.34e49544339714832378568b4e02ab6c.1679463564667.1686561291068.1686624267650.55&__hssc=181257784.2.1686624267650&__hsfp=904488742) - Company Company![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - - [About Us](https://www.kintone.com/en-us/company/) - [Careers](https://www.kintone.com/en-us/company/careers/) - [Press Center](https://www.kintone.com/en-us/press-center/) - [Contact Us](https://www.kintone.com/en-us/contact/) - ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_black.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_red.svg) Search Kintone ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_gray.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_login.svg)Log In [Get a Free Trial](https://www.kintone.com/en-us/trial/) [Get a Demo](https://resources.kintone.com/meetings/miri/kintonespecialist?__hstc=181257784.34e49544339714832378568b4e02ab6c.1679463564667.1686561291068.1686624267650.55&__hssc=181257784.2.1686624267650&__hsfp=904488742) - [![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-white.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-grey.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-red.png) Business with Heart <3](https://blog.kintone.com/business-with-heart) - [![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-white.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-grey.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-red.png) Company + Product](https://blog.kintone.com/company-news) - Company + ProductLatest News from Kintone - [Company + ProductLatest News from Kintone](https://blog.kintone.com/company-news) - [Business with Heart <3Operations for the Digital First Team](https://blog.kintone.com/business-with-heart) ![](https://blog.kintone.com/hubfs/1-37.png) [Tips and Tricks,](https://blog.kintone.com/company-news/tag/tips-and-tricks) # How to Import Data Sheets Jun 1, 2020   |   by [Kevin Veloira](https://blog.kintone.com/company-news/author/kevin-veloira) [Tweet](https://twitter.com/share) If you have data that you’d like to import into an app, or if you have a field or fields you’d like to update all at once, you can use the **Import from CSV/Excel** feature to do so. Let’s take a look at how to use this feature! Before beginning, you'll need to prepare the Excel or CSV File for import. See **[Supported Formats for Importing](https://get.kintone.help/k/en/user/using_app/import_records/create_csv.html)**. *TIP: If you’re unsure if your spreadsheet will be imported correctly due to the format, you can export a spreadsheet from your app, fill out the data, and use that for your import.* **How to Import Data Sheets** Within an app, click the **Ellipses** icon on the right. 1.  Select **Import from File**. 2. Click **Browse** to select your file. 3. Select if your **first row is header** or **first row is data**. 4. Selecting an option will open the **Preview** section, displaying a sample of the first five rows of data. 5. Under **Column in File**, select the column from the imported file that matches the fields in the app. For each field on the left, use the drop-down to select a column, or select **None** to not import data into that field. 6. To update existing records in the app with the imported data, select **Key to Bulk Update** on the right of the desired field to use as the key identifier. Text, Number, Date, Date and Time, and Link fields can also be used as keys. To use a field other than Record number as the key field, the field in the app settings must be set to **Prohibit duplicate values**. 7. Click **Import** 8. Click **OK**. 9. The top of the page shows a message stating either the file import was successful or unsuccessful. Check out the video below for more details! Have further questions? Please email [support@kintone.com](mailto:support@kintone.com). [![Kintone Free Trial CTA](https://no-cache.hubspot.com/cta/default/1857320/a0c9f62e-cc45-42e5-ade0-913fa2ddcd53.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/a0c9f62e-cc45-42e5-ade0-913fa2ddcd53) [![](https://blog.kintone.com/hubfs/Kevin.png)](https://blog.kintone.com/company-news/author/kevin-veloira) About the Author [Kevin Veloira](https://blog.kintone.com/company-news/author/kevin-veloira) Customer Success Specialist at Kintone. Kevin is the primary contact for Kintone users with account-based inquiries and native feature questions. Prior to joining Kintone, he worked as a public elementary and junior high school english teacher for three years in Kyoto, Japan. His hobbies include playing badminton, golf, listening to music, and checking out cool cafes and restaurants. Recommended Posts Up Next [A Letter from our CEO on Making Teamwork Better in Society](https://blog.kintone.com/company-news/make-teamwork-better-in-society) Previous [June 2020 Product Updates](https://blog.kintone.com/company-news/june-2020-product-update) [Back to Company + Product Blog Page](https://blog.kintone.com/company-news) ### Subscribe to Blog #### Recommended Posts [![](https://blog.kintone.com/hubfs/AdobeStock_1035261718.png)](https://blog.kintone.com/company-news/build-your-ai-assistant-in-kintone) Digital Transformation ##### Build Your AI Assistant In Kintone Wouldn’t it be convenient to have an AI-powered chatbot that could answer questions about your app data in Kintone? For this use case, ChatGPT and other LLMs are promising, but not sufficient on their own. For consistently relevant results, retrieval of contex... [Read More »](https://blog.kintone.com/company-news/build-your-ai-assistant-in-kintone) [![](https://blog.kintone.com/hubfs/Zapier%20and%20Kintone%20integration.jpg)](https://blog.kintone.com/company-news/email-automation-kintone-zapier-1) Digital Transformation ##### Send Daily Emails to Closed Deals in Kintone via Zapier Often, we want to perform a series of actions on a set of business records. Our CRM database contains emails and other data we might need to process regularly. Whatever these records are (Deals, Leads, or Loans), we can use Zapier to perform a series of steps ... [Read More »](https://blog.kintone.com/company-news/email-automation-kintone-zapier-1) [![](https://blog.kintone.com/hubfs/Zapier%20and%20Kintone%20integration.jpg)](https://blog.kintone.com/company-news/email-automation-kintone-zapier) Digital Transformation ##### Email Automation in Kintone using Zapier Often, after an event in your CRM, it would be helpful to send an email automatically to a contact’s email address. This article will explain how to send an email to a customer’s Gmail or Outlook address when a record is created or when the Process Management ... [Read More »](https://blog.kintone.com/company-news/email-automation-kintone-zapier) [![](https://blog.kintone.com/hubfs/PSD%20app%20template%20thumbnail-Recovered.png)](https://blog.kintone.com/company-news/the-complete-guide-to-using-kintones-app-templates) Tips and Tricks ##### The complete guide to using Kintone's app templates If you’ve dabbled in Kintone’s free trial or even looked around our website, you’ve probably heard about the app templates. Kintone app templates are pre-built applications you can use to quickly get started building custom apps. Think of it like the framing o... [Read More »](https://blog.kintone.com/company-news/the-complete-guide-to-using-kintones-app-templates) ### Try Kintone For Free! Our clients have built and deployed over 340,000 Kintone applications. Join them by signing up for a free trial–no credit card required–or scheduling a customized product demo. [![Try Kintone for free](https://no-cache.hubspot.com/cta/default/1857320/38781637-01ae-4d81-a227-bf6704b72577.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/38781637-01ae-4d81-a227-bf6704b72577)[![Schedule a Live Demo](https://no-cache.hubspot.com/cta/default/1857320/97cabdc7-d654-44b7-bf14-68222b115553.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/97cabdc7-d654-44b7-bf14-68222b115553) [![Kintone](https://blog.kintone.com/hubfs/KintoneGlobal/svg/logo_kinton_black.svg)](https://www.kintone.com/en-us/) U.S. Cambodia China(中文) Hong Kong India Indonesia Korea Laos Malaysia Myanmar Philippines Singapore Taiwan(繁体字) Thailand Viet Nam Japan(日本語) Australia Fiji Kiribati New Zealand Papua New Guinea Samoa Solomon Islands Tonga Tuvalu Vanuatu - [![facebook](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_facebook.svg) ![facebook](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_facebook_color.svg)](https://www.facebook.com/kintoneusa) - [![twitter](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_x.svg) ![twitter](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_x_color.svg)](https://x.com/kintone) - [![LinkedIn](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_linkedin.svg) ![LinkedIn](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_linkedin_color.svg)](https://www.linkedin.com/company/kintoneusa/) - [![Instagram](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_instagram.svg) ![Instagram](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_instagram_color.svg)](https://www.instagram.com/kintoneusa/) - [Terms of Use](https://www.kintone.com/en-us/terms-of-use/) - [Security](https://www.kintone.com/en-us/security/) - [Contact Us](https://www.kintone.com/en-us/contact/) - [Privacy Policy](https://www.kintone.com/en-us/privacy-policy/) - [Partners](https://www.kintone.com/en-us/partners/) Do Not Sell or Share My Personal Information - [Solutions by Department](https://www.kintone.com/en-us/departments/) - [Operations](https://www.kintone.com/en-us/departments/business-operations/) - [Sales](https://www.kintone.com/en-us/departments/sales/) - [Customer Support](https://www.kintone.com/en-us/departments/customer-support/) - [HR & Admin](https://www.kintone.com/en-us/departments/hr-admin/) - [Marketing](https://www.kintone.com/en-us/departments/marketing/) - [Manufacturing & Retail Management](https://www.kintone.com/en-us/departments/manufacturing-retail-management/) - [IT Support](https://www.kintone.com/en-us/departments/it-support/) - [Solutions by Function](https://www.kintone.com/en-us/functions/) - [Convert spreadsheets to databases](https://www.kintone.com/en-us/functions/convert-spreadsheets-to-databases/) - [Data Management](https://www.kintone.com/en-us/functions/data-management/) - [CRM & Sales Management](https://www.kintone.com/en-us/functions/crm-sales-management/) - [Project Management](https://www.kintone.com/en-us/functions/project-management/) - [Workflow Management](https://www.kintone.com/en-us/functions/workflow/) - [Remote Work](https://www.kintone.com/en-us/functions/remote-work/) - [Recruitment & Hiring](https://www.kintone.com/en-us/functions/recruitment-hiring/) - [Solutions by Industry](https://www.kintone.com/en-us/industries/) - [Manufacturing](https://www.kintone.com/en-us/industries/manufacturing/) - [Real Estate](https://www.kintone.com/en-us/industries/real-estate/) - [Retail](https://www.kintone.com/en-us/industries/retail/) - [Education](https://www.kintone.com/en-us/industries/education/) - [Hospitality](https://www.kintone.com/en-us/industries/hospitality/) - [Healthcare](https://www.kintone.com/en-us/industries/healthcare/) - [Nonprofit](https://www.kintone.com/en-us/industries/nonprofit/) - [Solutions by Problem](https://www.kintone.com/en-us/problems/) - [Streamline Operations and Processes](https://www.kintone.com/en-us/problems/streamline-operations-and-processes/) - [Manage and Organize Business Data](https://www.kintone.com/en-us/problems/manage-and-organize-business-data/) - [Track Project Status and Accountability](https://www.kintone.com/en-us/problems/tracking-project-status-and-accountability/) - [Customer Stories](https://www.kintone.com/en-us/customer-stories/) - [Pricing](https://www.kintone.com/en-us/pricing/) - [Native Kintone Plug-ins](https://www.kintone.com/en-us/features/plugins/) - [Intro to Kintone](https://www.kintone.com/en-us/intro/) - [Why Kintone](https://www.kintone.com/en-us/why-kintone/) - [Customer Stories](https://www.kintone.com/en-us/customer-stories/) - [Pricing](https://www.kintone.com/en-us/pricing/) - [How Kintone Works](https://www.kintone.com/en-us/how-kintone-works/) - [App Template Library](https://www.kintone.com/en-us/features/app-templates/) - [Extensions](https://www.kintone.com/en-us/features/extensions/) - [Native Kintone Plug-ins](https://www.kintone.com/en-us/features/plugins/) - [Kintone AI](https://www.kintone.com/en-us/features/ai/) - [System Administration](https://www.kintone.com/en-us/features/administration/) - [Security](https://www.kintone.com/en-us/security/) - [Webinars](https://www.kintone.com/en-us/events/) - [Guidebooks & Videos](https://www.kintone.com/en-us/guidebooks-and-videos/) - [Kintone Support Overview](https://www.kintone.com/en-us/support-overview/) - [Developers](https://kintone.dev/en/) - [Customer Resource](https://www.kintone.com/en-us/for-customers/) - [Blog](https://blog.kintone.com/business-with-heart) - [About Us](https://www.kintone.com/en-us/company/) - [Careers](https://www.kintone.com/en-us/company/careers/) - [Press Center](https://www.kintone.com/en-us/press-center/) - [Terms of Use](https://www.kintone.com/en-us/terms-of-use/) - [Privacy Policy](https://www.kintone.com/en-us/privacy-policy/) - [Partners](https://www.kintone.com/en-us/partners/) - [Contact Us](https://www.kintone.com/en-us/contact/) - Do Not Sell or Share My Personal Information © 2022 Kintone © 2022 Kintone