--- title: How to Solve Your Spreadsheet Problems With Kintone description: One study found that 88% of spreadsheets contain errors that affect a business’ bottom line. Learn how to ditch spreadsheets for a better alternative. image: https://blog.kintone.com/hubfs/How%20to%20solve%20your%20spreadsheet%20problems%20with%20Kintone.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/How%20to%20solve%20your%20spreadsheet%20problems%20with%20Kintone.png) [Tips and Tricks,](https://blog.kintone.com/company-news/tag/tips-and-tricks) # How to Solve Your Spreadsheet Problems With Kintone Feb 1, 2022   |   by [Kristy Griggs](https://blog.kintone.com/company-news/author/kristy-griggs) [Tweet](https://twitter.com/share) ## The problem(s) with spreadsheets The management of JP Morgan Chase would likely agree that spreadsheets aren’t always the most loved office tool based on what happened to their company in 2012 when [a spreadsheet error partially led to losing 6.2 billion](https://www.bloomberg.com/quicktake/the-london-whale). That is 6 billion with a “b”, but the bank still made a record profit of $21.3 billion that year so it may have been more embarrassing than financially devastating.  What they may not know is that they’re in good company; a study published in the *Journal of End User’s Computing* found [**88% of spreadsheets contain errors**](http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm) that affect a business’ bottom line. Still, there is no denying their customizability or that they enable you to organize information clearly, concisely, and efficiently. So, beyond errors that lead to compromised data, what else is dinging the reputation of spreadsheets? - They’re often overused for tasks they're not ideally suited for - Version control can become an issue - It’s tough to have both accessibility and security (one is often sacrificed for the other) - Data is usually siloed and scattered  - Communication about the data happens elsewhere, like chat or email And spreadsheets aren’t the only office tool that hurts workers productivity; in general, [employees are using too many software applications](https://resources.kintone.com/too-much-software), which also increases inefficiency.  ## **Turn your inefficient spreadsheets into performers**    But what if you could use your spreadsheets to create customizable apps that manage your team’s data and processes, reducing the need for so many software applications? You’ll not only spend less time reorganizing your data, you and your team will learn from it.  Kintone brings data and communication all into one visible place by: - Making database app building accessible - Centralizing data and operations - Unifying team communication  ### **So, what is Kintone?** Kintone is a no-code/low-code cloud platform for teams to easily and efficiently share and collaborate on their data. Essentially, Kintone allows anyone on your team to create database apps that solve organizational inefficiencies in minutes. ### **How Kintone works** You’ll start by creating a “space” which is a digital workspace dedicated to a specific department or project. By creating threads, you can house your team’s communication alongside your data all in one place (for everyone to view). And the app section is where you can keep all the applications you and your team design to perform an operation, including the spreadsheets you can turn into high-performing database apps. Here's an example of a space: ![space](https://blog.kintone.com/hs-fs/hubfs/space.png?width=1920&name=space.png) ## **A Demo: Transforming your spreadsheets into Kintone database apps** Now we'll walk you through the process of converting your spreadsheets into customizable and dynamic database apps that you can use to track every aspect of your work.  ## ![spreadsheet import 1](https://blog.kintone.com/hs-fs/hubfs/spreadsheet%20import%201.png?width=800&name=spreadsheet%20import%201.png) 1. To get started, choose an Excel spreadsheet to convert into a Kintone database app. Today, we'll be using a spreadsheet of customer names and contact info to create a customer database. Next, you’ll need to format the Excel spreadsheet so it can be imported to Kintone. To make sure your spreadsheet will be converted properly, you'll need to check off a few boxes. Here's what that looks like. You'll need to make sure the first row includes the column names, such as Customer Name, Phone Number, and whatever else is stored in the spreadsheet.  ![spreadsheet import 2](https://blog.kintone.com/hs-fs/hubfs/spreadsheet%20import%202.png?width=800&name=spreadsheet%20import%202.png) 2. Once you've ensured your spreadsheet is formatted correctly, check the preview (see image below). If it looks good, you’re almost ready to convert it. You'll also need to select what types of data fields you need for each column. For example, for Customer Name, you'll need a text field, but for Email Address, you'll want a link field. Once you're done with that, go ahead and convert your spreadsheet into a database. Now, each of those line items in your spreadsheet have become data records in your database. ![spreadsheet import 6](https://blog.kintone.com/hs-fs/hubfs/spreadsheet%20import%206.png?width=1090&name=spreadsheet%20import%206.png) 3. Now you’ll be able to customize your new database! Just click on the settings icon. By dragging and dropping the icons on the left (see image below) according to what you want in your database you can add things like a timestamp, a new table, add a field that labels who created the database and much more.  ![spreadsheet import 11](https://blog.kintone.com/hs-fs/hubfs/spreadsheet%20import%2011.png?width=2082&name=spreadsheet%20import%2011.png) 4. After you’ve added all the fields that will make your database perfect for you and your team, click on the “update app” button and you’ll be automatically redirected to a view of your database with all the changes applied. ![spreadsheet import 12](https://blog.kintone.com/hs-fs/hubfs/spreadsheet%20import%2012.png?width=2088&name=spreadsheet%20import%2012.png) 5. Congrats! Your new customer database app is set up. You can now do a few different things to make your new app even more useful and efficient, whether it's adding new fields like Customer Status or setting up filters like active versus inactive customers, customers sorted by company size, customers assigned to you, and more. You can also create charts and graphs of your data with just a few clicks and save them for easy access later on or set up a workflow to manage different steps in your sales process.   Want to try Kintone's spreadsheet to database converter yourself? [Learn more about how it works here and sign up for a free 30-day trial, no strings attached. ](https://www.kintone.com/solutions/spreadsheet-conversion/) [![Kintone 1-on-1 personalized demo](https://no-cache.hubspot.com/cta/default/1857320/ce2afddf-f7b9-49ab-8e9c-69f6dda9d766.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/ce2afddf-f7b9-49ab-8e9c-69f6dda9d766) [![](https://blog.kintone.com/hubfs/Kristy.png)](https://blog.kintone.com/company-news/author/kristy-griggs) About the Author [Kristy Griggs](https://blog.kintone.com/company-news/author/kristy-griggs) Kristy is a writer living in Atlanta, Georgia where she works, plays and explores life. When it comes to writing, she’s pretty much dabbled in nearly every form—she penned her first published piece, a poem titled “What’s in a Name,” when she was in grade school—she finds it ironic that she has forgotten peoples’ names all her life. When she isn’t moving her fingers on a keyboard, she’s likely enjoying time with friends, playing tennis or spoiling her 10-year-old Scottish Fold cat, Cash. Recommended Posts Up Next [February 2022 Product Updates](https://blog.kintone.com/company-news/february-2022-product-update) Previous [A Step-by-Step Guide for New Kintone Administrators](https://blog.kintone.com/company-news/getting-started-as-a-kintone-administrator) [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