{"id":6431,"date":"2013-07-15T15:10:52","date_gmt":"2013-07-15T20:10:52","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=6431"},"modified":"2024-11-15T15:11:08","modified_gmt":"2024-11-15T21:11:08","slug":"struggling-with-spreadsheets-turn-them-into-web-apps","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2013\/07\/struggling-with-spreadsheets-turn-them-into-web-apps\/","title":{"rendered":"Struggling with spreadsheets? Turn them into web apps"},"content":{"rendered":"

\"Education\"<\/a>How many business users in your company rely on spreadsheets on a regular basis? How many users access and edit a single spreadsheet? I know what you\u2019re thinking: \u201cHow should I know?\u201d<\/p>\n

That\u2019s the point.<\/strong> There\u2019s no way to know. If your employees use spreadsheets to create reports, maintain business data, or even share data with other employees, it\u2019s out of the IT department\u2019s control. They could accidentally email spreadsheets full of critical business data to their friends, and you\u2019d never know. Ten different employees could alter the same spreadsheet (often incorrectly), and you\u2019d never know.<\/p>\n

How do you regain control over your company’s data?<\/p>\n

The ideal solution: Put all of that spreadsheet data into a secure database, and let employees create web applications over the top of it. The benefits of this approach are obvious:<\/p>\n

    \n
  1. It\u2019s safer:<\/strong> The IT department secures the data and controls user access.<\/li>\n
  2. It\u2019s more accessible:<\/strong> Rather than mailing spreadsheets to each other, users can access their data via the web.<\/li>\n
  3. It opens up new options:<\/strong> Once data is in a database, users can create all types of applications over that data, like reports, BI apps, mobile apps, and more.<\/li>\n<\/ol>\n

    The question: How can users easily convert their spreadsheet data into a database, AND build web applications over that data? Believe it or not, it\u2019s actually simple. Rather than try to explain it, this video walks you through the whole process (in under 3 minutes).<\/p>\n

    https:\/\/youtu.be\/P6ZdmApFRXA<\/a>
    \n    <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    How many business users in your company rely on spreadsheets on a regular basis? How many users access and edit a single spreadsheet? I know what you\u2019re thinking: \u201cHow should I know?\u201d That\u2019s the point. There\u2019s no way to know. If your employees use spreadsheets to create reports, maintain business data, or even share data …<\/p>\n

    Struggling with spreadsheets? Turn them into web apps<\/span> Read More »<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"Struggling with spreadsheets? Turn them into web apps - mrc's Cup of Joe Blog","description":"How many business users in your company rely on spreadsheets on a regular basis? How many users access and edit a single spreadsheet? I know what you\u2019re thinkin"},"footnotes":""},"categories":[8],"tags":[44],"class_list":["post-6431","post","type-post","status-publish","format-standard","hentry","category-education","tag-spreadsheets"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/6431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=6431"}],"version-history":[{"count":9,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/6431\/revisions"}],"predecessor-version":[{"id":15280,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/6431\/revisions\/15280"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=6431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=6431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=6431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}