{"id":4044,"date":"2017-06-29T13:44:54","date_gmt":"2017-06-29T11:44:54","guid":{"rendered":"https:\/\/www.minicrm.hu\/help\/?p=4044"},"modified":"2017-11-16T10:45:10","modified_gmt":"2017-11-16T09:45:10","slug":"how-to-structure-your-spreadsheet","status":"publish","type":"post","link":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/","title":{"rendered":"How to structure your spreadsheet"},"content":{"rendered":"<div class=\"alert alert-info\">Before reading the whole description, we recommend you to create your spreadsheet according to the <a href=\"https:\/\/d26cfm2pfnephr.cloudfront.net\/uploads\/2015\/07\/MiniCRM_Import_EN_AutoSalesV2.xlsx\">Sample<\/a><strong>.<\/strong><\/div>\n<h2 id=\"Megnevezs\">Opportunity&#8217;s name<\/h2>\n<h3>You have two options:<\/h3>\n<ul>\n<li>If you do not create a column for it, the <a href=\"..\/details-of-cards\/\">opportunity&#8217;s name<\/a>\u00a0will be the <a href=\"..\/business-and-contact-person\/\">Company name (Contact Person&#8217;s name)<\/a> by default.<\/li>\n<li>If you create a column, the opportunity card&#8217;s name will be the name that you enter into the <a href=\"..\/what-is-an-opportunity-card-good-for\/\">Opportunity<\/a>: Name columns.<\/li>\n<\/ul>\n<h2 id=\"Felels\">Owner<\/h2>\n<p>You have to choose an <a href=\"..\/details-of-cards\/\">owner<\/a><strong>\u00a0<\/strong>to every client. You can choose from those who can access your MiniCRM system.<\/p>\n<div class=\"alert alert-danger\">Make sure\u00a0you type every name correctly because it has to be equal to the name that is in the system.<\/div>\n<h2 id=\"Sttuszok\">Sales status<\/h2>\n<p>There are four options:<\/p>\n<ul>\n<li>Discovery<\/li>\n<li>In progress<\/li>\n<li>Won opportunity<\/li>\n<li>Lost opportunity<\/li>\n<\/ul>\n<p>It shows\u00a0where are your leads in the sales process.<\/p>\n<h2 id=\"Cegadatok\">Company data<\/h2>\n<div class=\"alert alert-danger\">If you would like to import company data, you have to enter a company name as well, otherwise, the data will not be imported.<\/div>\n<ul>\n<li><strong>Company: Business name<\/strong> (e.g. Example Ltd.)<\/li>\n<li><strong>Company: Email<\/strong> (e.g. info@example.com) &#8211; You can add more addresses to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.<\/li>\n<li><strong>Company: Email type<\/strong> (e.g. work)<\/li>\n<li><strong>Company: Phone<\/strong> (e.g. 087 017 001 615) &#8211; You can add more numbers to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.<\/li>\n<li><strong>Company: Bank account number<\/strong>\u00a0(e.g. 11111111-22222222-33333333)<\/li>\n<li><strong>Company: SWIFT code<\/strong>\u00a0(pl. HUHUABCD)<\/li>\n<li><strong>Company: Company registration number<\/strong>\u00a0(e.g. 01-02-1234567)<\/li>\n<li><strong>Company: Phone type<\/strong> (e.g. work<\/li>\n<li><strong>Company: Description<\/strong> (e.g. medium-sized company with 12 employees\u2026)<\/li>\n<li><strong>Company: Website<\/strong> (e.g. www.example.com)<\/li>\n<li><strong>Company: Industry<\/strong> (e.g. Consulting)<\/li>\n<li><strong>Company: Region<\/strong><\/li>\n<li><strong>Company: Number of employees\u00a0<\/strong>(e.g. 12)<\/li>\n<li><strong>Company: Yearly revenue<\/strong><\/li>\n<\/ul>\n<h2 id=\"Cmadatok42\">Address data<\/h2>\n<ul>\n<li><strong>Address1: Type<\/strong> (e.g. Headquarters)<\/li>\n<li><strong>Address1: Country<\/strong> (e.g. United States)<\/li>\n<li><strong>Address1: Postal code<\/strong> (e.g. 32826)<\/li>\n<li><strong>Address1: City<\/strong> (e.g. Orlando)<\/li>\n<li><strong>Address1: Address<\/strong> (e.g. 70 Phillips Street)<\/li>\n<\/ul>\n<p>Address data will be imported to the company. If there is no company, it will be imported to the person.<\/p>\n<p>In the case of the\u00a0<strong>Address type\u00a0<\/strong>field, you can choose from the addresses that are already in MiniCRM.<\/p>\n<h2 id=\"Kapcsolattartadatai\">Contact person&#8217;s data<\/h2>\n<div class=\"alert alert-danger\">If you would like to import a person\/contact person, you have to enter a name as well, otherwise, their data will not be imported.<\/div>\n<ul>\n<li><strong>Person1: First Name<\/strong> (e.g. John)<\/li>\n<li><strong>Person1: Last Name<\/strong> (e.g. Smith)<\/li>\n<li><strong>Person1: Email<\/strong> (e.g. johnsmith@example.com) &#8211; You can add more addresses to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.<\/li>\n<li><strong>Person1: Email type<\/strong> (e.g. work)<\/li>\n<li><strong>Person1: Phone<\/strong> (e.g. 087 017 001 615) &#8211; You can add more numbers to a contact (cell) by separating them with commas or semicolons. Keep in mind that you should only use commas OR semicolons in one cell. However, if you have used only commas in one cell, you can use only semicolons in another one.<\/li>\n<li><strong>Person1: Phone type<\/strong> (e.g. work)<\/li>\n<li><strong>Person1: Position<\/strong> (e.g. Sales)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity&#8217;s name You have two options: If you do not create a column for it, the opportunity&#8217;s name\u00a0will be the Company name (Contact Person&#8217;s name) by default. If you create a column, the opportunity card&#8217;s name will be the [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[438,450],"class_list":["post-4044","post","type-post","status-publish","format-standard","hentry","category-import-export-form","tag-field-en","tag-import-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to structure your spreadsheet - Documenta\u021bie MiniCRM<\/title>\n<meta name=\"description\" content=\"Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity&#039;s name You have two options: If you\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to structure your spreadsheet - Documenta\u021bie MiniCRM\" \/>\n<meta property=\"og:description\" content=\"Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity&#039;s name You have two options: If you\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Documenta\u021bie MiniCRM\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-29T11:44:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-16T09:45:10+00:00\" \/>\n<meta name=\"author\" content=\"L\u00edvia F\u00fcl\u00f6p\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"L\u00edvia F\u00fcl\u00f6p\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/\"},\"author\":{\"name\":\"L\u00edvia F\u00fcl\u00f6p\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/ceb677e9c50c3b41ea1539b92acfae96\"},\"headline\":\"How to structure your spreadsheet\",\"datePublished\":\"2017-06-29T11:44:54+00:00\",\"dateModified\":\"2017-11-16T09:45:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/\"},\"wordCount\":580,\"commentCount\":0,\"keywords\":[\"field-en\",\"import-en\"],\"articleSection\":[\"Import Export and Form\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/\",\"url\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/\",\"name\":\"How to structure your spreadsheet - Documenta\u021bie MiniCRM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#website\"},\"datePublished\":\"2017-06-29T11:44:54+00:00\",\"dateModified\":\"2017-11-16T09:45:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/ceb677e9c50c3b41ea1539b92acfae96\"},\"description\":\"Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity's name You have two options: If you\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-to-structure-your-spreadsheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to structure your spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/\",\"name\":\"Documenta\u021bie MiniCRM\",\"description\":\"Welcome to MiniCRM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/ceb677e9c50c3b41ea1539b92acfae96\",\"name\":\"L\u00edvia F\u00fcl\u00f6p\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g\",\"caption\":\"L\u00edvia F\u00fcl\u00f6p\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to structure your spreadsheet - Documenta\u021bie MiniCRM","description":"Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity's name You have two options: If you","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"How to structure your spreadsheet - Documenta\u021bie MiniCRM","og_description":"Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity's name You have two options: If you","og_url":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/","og_site_name":"Documenta\u021bie MiniCRM","article_published_time":"2017-06-29T11:44:54+00:00","article_modified_time":"2017-11-16T09:45:10+00:00","author":"L\u00edvia F\u00fcl\u00f6p","twitter_card":"summary_large_image","twitter_misc":{"Written by":"L\u00edvia F\u00fcl\u00f6p","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/"},"author":{"name":"L\u00edvia F\u00fcl\u00f6p","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/ceb677e9c50c3b41ea1539b92acfae96"},"headline":"How to structure your spreadsheet","datePublished":"2017-06-29T11:44:54+00:00","dateModified":"2017-11-16T09:45:10+00:00","mainEntityOfPage":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/"},"wordCount":580,"commentCount":0,"keywords":["field-en","import-en"],"articleSection":["Import Export and Form"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/","url":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/","name":"How to structure your spreadsheet - Documenta\u021bie MiniCRM","isPartOf":{"@id":"https:\/\/www.minicrm.hu\/help\/#website"},"datePublished":"2017-06-29T11:44:54+00:00","dateModified":"2017-11-16T09:45:10+00:00","author":{"@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/ceb677e9c50c3b41ea1539b92acfae96"},"description":"Before reading the whole description, we recommend you to create your spreadsheet according to the Sample. Opportunity's name You have two options: If you","breadcrumb":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/helpdev.minicrm.io\/help\/how-to-structure-your-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.minicrm.hu\/help\/"},{"@type":"ListItem","position":2,"name":"How to structure your spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/www.minicrm.hu\/help\/#website","url":"https:\/\/www.minicrm.hu\/help\/","name":"Documenta\u021bie MiniCRM","description":"Welcome to MiniCRM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.minicrm.hu\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/ceb677e9c50c3b41ea1539b92acfae96","name":"L\u00edvia F\u00fcl\u00f6p","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g","caption":"L\u00edvia F\u00fcl\u00f6p"}}]}},"_links":{"self":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts\/4044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/comments?post=4044"}],"version-history":[{"count":7,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts\/4044\/revisions"}],"predecessor-version":[{"id":6765,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts\/4044\/revisions\/6765"}],"wp:attachment":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/media?parent=4044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/categories?post=4044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/tags?post=4044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}