{"id":18013,"date":"2023-08-12T17:45:45","date_gmt":"2023-08-12T14:15:45","guid":{"rendered":"https:\/\/www.tehranserver.ir\/blog\/?p=18013"},"modified":"2025-05-11T09:33:43","modified_gmt":"2025-05-11T06:03:43","slug":"5-%d8%b1%d8%a7%d9%87-%d8%b3%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-csv","status":"publish","type":"post","link":"https:\/\/www.tehranserver.ir\/blog\/5-%d8%b1%d8%a7%d9%87-%d8%b3%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d8%a8%d8%af%db%8c%d9%84-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d9%87-csv\/","title":{"rendered":"5 \u0631\u0627\u0647 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV"},"content":{"rendered":"<h1>5 \u0631\u0627\u0647 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV<\/h1>\n<p><a href=\"https:\/\/www.tehranserver.ir\/blog\/%d8%b3%d8%a7%d8%ae%d8%aa-%d9%84%db%8c%d8%b3%d8%aa-%d8%a7%d8%b3%d8%a7%d9%85%db%8c-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%d8%a7%d9%86-csv-%d8%ac%d9%87%d8%aa-%d8%a7%db%8c%d9%85%d9%be%d9%88%d8%b1%d8%aa\/\">CSV<\/a> \u06cc\u06a9\u06cc \u0627\u0632 \u0641\u0631\u0645\u062a \u0647\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0633\u0627\u062f\u06af\u06cc \u0648 \u06a9\u0645 \u062d\u062c\u0645\u06cc \u062f\u0631 \u0633\u0627\u0644 \u0647\u0627\u06cc \u0627\u062e\u06cc\u0631 \u0628\u0633\u06cc\u0627\u0631 \u0645\u062d\u0628\u0648\u0628 \u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0633\u062a. \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u0641\u0631\u0645\u062a \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0631\u062f \u0648 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0631\u0627 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0627\u0632 \u0648\u0628\u0644\u0627\u06af <a href=\"https:\/\/www.aparat.com\/tehranserver.ir\/tehranserver.ir\">\u062a\u0647\u0631\u0627\u0646 \u0633\u0631\u0648\u0631<\/a> \u0633\u0639\u06cc \u062f\u0627\u0631\u06cc\u0645 \u062a\u0627 \u0628\u0647 \u0634\u0645\u0627 5 \u0631\u0627\u0647 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0631\u0627 \u0622\u0645\u0648\u0632\u0634 \u062f\u0647\u06cc\u0645. \u0627\u06af\u0631 \u0634\u0645\u0627 \u0647\u0645 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0631\u0627\u0647\u06cc \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0647\u0633\u062a\u06cc\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0647\u0645\u0631\u0627\u0647 \u0645\u0627 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n<h2>1. \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0627\u0632 \u0637\u0631\u06cc\u0642 Save As Command<\/h2>\n<p>\u0633\u0627\u062f\u0647 \u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062f\u0633\u062a\u0648\u0631 Excel File Save As \u0627\u0633\u062a. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<ul>\n<li>\u0627\u0628\u062a\u062f\u0627 workbook \u0627\u06a9\u0633\u0644 \u0648 \u0628\u0631\u06af\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0633\u067e\u0633 \u0631\u0648\u06cc File \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u067e\u0646\u062c\u0631\u0647 File \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f. \u062f\u0631 \u0633\u0645\u062a \u0686\u067e\u060c Save As \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<figure id=\"attachment_18014\" aria-describedby=\"caption-attachment-18014\" style=\"width: 139px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-18014 size-full\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-2.png\" alt=\"\u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0627\u0632 \u0637\u0631\u06cc\u0642 Save As Command\" width=\"139\" height=\"319\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-2.png 139w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-2-65x150.png 65w\" sizes=\"(max-width: 139px) 100vw, 139px\" \/><figcaption id=\"caption-attachment-18014\" class=\"wp-caption-text\">\u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV\u060c\u0627\u06a9\u0633\u0644 \u060c \u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u060c\u062e\u0631\u0648\u062c\u06cc \u0627\u06a9\u0633\u0644<\/figcaption><\/figure>\n<ul>\n<li>\u062f\u0631 \u067e\u0646\u062c\u0631\u0647 Save As\u060c \u0645\u0637\u0627\u0628\u0642 \u0634\u06a9\u0644 \u0631\u0648\u06cc \u0646\u0645\u0627\u062f \u06a9\u0634\u0648\u06cc\u06cc \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u0648 \u06af\u0632\u06cc\u0646\u0647 CSV (Comma delimited) \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-18015 size-full\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-3.png\" alt=\"\u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0628\u0627 \u06a9\u0627\u0645\u0646\u062f\" width=\"681\" height=\"540\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-3.png 681w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-3-150x119.png 150w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/p>\n<ul>\n<li>\u067e\u0633 \u0627\u0632 \u0622\u0646 \u0646\u06cc\u0632 \u0628\u0631 \u0631\u0648\u06cc \u06af\u0632\u06cc\u0646\u0647 Save \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f\u0646 \u0641\u0627\u06cc\u0644 \u062e\u0648\u062f \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p>\u0646\u06a9\u062a\u0647: \u067e\u0633 \u0627\u0632 \u0641\u0634\u0627\u0631 \u062f\u0627\u062f\u0646 Save\u060c \u06cc\u06a9 \u067e\u06cc\u0627\u0645 \u0647\u0634\u062f\u0627\u0631 \u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u067e\u06cc\u0627\u0645 \u0628\u0647 \u0634\u0645\u0627 \u06cc\u0627\u062f\u0622\u0648\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0641\u0642\u0637 \u06a9\u0627\u0631\u0628\u0631\u06af \u0641\u0639\u0627\u0644 \u0628\u0647 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc \u0634\u0648\u062f. \u0648 \u0628\u0631\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u062a\u0645\u0627\u0645 \u0628\u0631\u06af\u0647 \u0647\u0627 \u062f\u0631 \u0641\u0631\u0645\u062a CSV\u060c \u0628\u0627\u06cc\u062f \u0645\u0631\u0627\u062d\u0644 \u0628\u0627\u0644\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u06a9\u0627\u0631\u0628\u0631\u06af \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/p>\n<h2>2. \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV UTF-8 \u0628\u062f\u0648\u0646 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0631\u062f\u0646 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635<\/h2>\n<p>\u0631\u0648\u0634 \u0634\u0645\u0627\u0631\u0647 1 \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a \u0627\u0645\u0627 \u06cc\u06a9 \u0627\u0634\u06a9\u0627\u0644 \u0627\u0633\u0627\u0633\u06cc \u062f\u0627\u0631\u062f. \u0631\u0648\u0634 \u0642\u0628\u0644\u06cc \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 (\u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u063a\u06cc\u0631 ASCII) \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 Excel \u0628\u0647 CSV UTF-8 \u0628\u062f\u0648\u0646 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0631\u062f\u0646 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/p>\n<ul>\n<li>\u0627\u0628\u062a\u062f\u0627 \u0628\u0647 File \u0628\u0631\u0648\u06cc\u062f.<\/li>\n<li>\u0633\u067e\u0633 \u06af\u0632\u06cc\u0646\u0647 Save As \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u067e\u0646\u062c\u0631\u0647 Save As\u060c CSV UTF-8 \u0631\u0627 \u0627\u0632 \u06af\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u06a9\u0634\u0648\u06cc\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-18016 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-6.png\" alt=\"\u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV UTF-8 \u0628\u062f\u0648\u0646 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0631\u062f\u0646 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635\" width=\"683\" height=\"538\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-6.png 683w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-6-150x118.png 150w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<ul>\n<li>\u0633\u067e\u0633\u060c \u0630\u062e\u06cc\u0631\u0647 \u0631\u0627 \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u0646\u062a\u06cc\u062c\u0647\u060c \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u0628\u0631\u06af\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0634\u0645\u0627 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u0648\u06cc\u0698\u0647 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0641\u0627\u06cc\u0644 CSV \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u06cc\u062f.<\/li>\n<\/ul>\n<h2>3. \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV UTF-16<\/h2>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0641\u0631\u0622\u06cc\u0646\u062f \u0645\u062a\u0641\u0627\u0648\u062a\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0627 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u0645. \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u060c \u0641\u0631\u0622\u06cc\u0646\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645.<\/p>\n<ul>\n<li>\u0627\u0628\u062a\u062f\u0627 \u06a9\u0627\u0631\u0628\u0631\u06af \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>Save As \u0631\u0627 \u062f\u0631 \u067e\u0646\u062c\u0631\u0647 File \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u067e\u0633 \u0627\u0632 \u0622\u0646\u060c Unicode Text \u0631\u0627 \u0627\u0632 \u0644\u06cc\u0633\u062a \u06a9\u0634\u0648\u06cc\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18017 size-full aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-8.png\" alt=\"\u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV UTF-16\" width=\"682\" height=\"535\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-8.png 682w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-8-150x118.png 150w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<ul>\n<li>\u0633\u067e\u0633\u060c \u06af\u0632\u06cc\u0646\u0647 Save \u0631\u0627 \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f. \u067e\u0633 \u0627\u0632 \u0622\u0646\u060c \u06cc\u06a9 \u0641\u0627\u06cc\u0644 txt. \u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/li>\n<li>\u0627\u06a9\u0646\u0648\u0646 \u0641\u0627\u06cc\u0644 \u0645\u062a\u0646\u06cc \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0631\u062f\u0647 \u0648 \u0631\u0648\u06cc Save As \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0628\u0627 \u06cc\u06a9 \u067e\u06cc\u063a\u0627\u0645 \u0647\u0634\u062f\u0627\u0631 \u0631\u0648 \u0628\u0647 \u0631\u0648 \u0645\u06cc \u0634\u0648\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c .csv \u0631\u0627 \u062f\u0631 \u0627\u0646\u062a\u0647\u0627\u06cc \u0646\u0627\u0645 \u0641\u0627\u06cc\u0644 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f \u0648 All Files \u0631\u0627 \u062f\u0631 \u0646\u0648\u0639 Save as \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>UTF-16 LE \u0631\u0627 \u062f\u0631 \u0642\u0633\u0645\u062a Encoding \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0648 Save \u0631\u0627 \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18018 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-9.png\" alt=\"\u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV UTF-16\" width=\"667\" height=\"466\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-9.png 667w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-9-150x105.png 150w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/p>\n<ul>\n<li>\u062f\u0631 \u0646\u062a\u06cc\u062c\u0647\u060c \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u06a9\u0647 \u062d\u0627\u0648\u06cc \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0633\u062a \u0631\u0627 \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<\/ul>\n<h2>4. \u0627\u0632 Google Spreadsheets \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/h2>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 Google Spreadsheets \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u0627\u06a9\u0646\u0648\u0646 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u060c \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<ul>\n<li>\u0627\u0628\u062a\u062f\u0627 \u06cc\u06a9 \u0635\u0641\u062d\u0647 \u062e\u0627\u0644\u06cc \u062f\u0631 Google Spreadsheets \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0627\u0632 \u06af\u0632\u06cc\u0646\u0647 File \u06af\u0632\u06cc\u0646\u0647 Import \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18019 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-11.png\" alt=\"\u0627\u0632 Google Spreadsheets \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\" width=\"323\" height=\"317\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-11.png 323w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-11-150x147.png 150w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/p>\n<ul>\n<li>\u0633\u067e\u0633\u060c workbook \u0627\u06a9\u0633\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0648 Import data \u0631\u0627 \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18020 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-12.png\" alt=\"\u0627\u0632 Google Spreadsheets \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\" width=\"516\" height=\"267\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-12.png 516w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-12-150x78.png 150w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/p>\n<ul>\n<li>\u062f\u0631 \u0646\u062a\u06cc\u062c\u0647\u060c \u0641\u0627\u06cc\u0644 \u0631\u0627 \u062f\u0631 Spreadsheets \u0628\u0627\u0632 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\u0627\u06a9\u0646\u0648\u0646 File \u27a4 Download \u27a4 Comma Separated Values \u200b\u200b(csv.) \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18021 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-13.png\" alt=\"\u0627\u0632 Google Spreadsheets \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\" width=\"638\" height=\"469\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-13.png 638w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-13-150x110.png 150w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<ul>\n<li>\u0633\u067e\u0633 \u0641\u0627\u06cc\u0644 \u062f\u0627\u0646\u0644\u0648\u062f \u0634\u062f\u0647 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u062c\u062f\u06cc\u062f\u00a0\u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/li>\n<\/ul>\n<h2>5. VBA \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0628\u0631\u06af\u0647 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f<\/h2>\n<p>\u062a\u0627\u06a9\u0646\u0648\u0646\u060c \u062a\u0628\u062f\u06cc\u0644 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631\u06af \u0648\u0627\u062d\u062f \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u0631\u0627 \u067e\u0648\u0634\u0634 \u062f\u0627\u062f\u0647\u200c \u0627\u06cc\u0645. \u0627\u0645\u0627\u060c \u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u062a\u0645\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06af \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0648\u0627\u062d\u062f \u0627\u06a9\u0633\u0644 \u0631\u0627 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u0645. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u0628\u0627\u06cc\u062f \u0627\u0632 Excel VBA \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u062f\u0631 \u0622\u062e\u0631\u06cc\u0646 \u0631\u0648\u0634 \u062e\u0648\u062f\u060c \u0645\u0631\u0627\u062d\u0644 \u0627\u0646\u062c\u0627\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a \u0631\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0646\u0634\u0627\u0646 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0631\u0648\u0646\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/p>\n<ul>\n<li>\u062f\u0631 \u0627\u0628\u062a\u062f\u0627\u060c \u0647\u0631 \u0628\u0631\u06af\u0647 \u0627\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u0648 \u06a9\u0644\u06cc\u06a9 \u0631\u0627\u0633\u062a \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0633\u067e\u0633\u060c View Code \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18022 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-15.png\" alt=\"VBA \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0628\u0631\u06af\u0647 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f\" width=\"537\" height=\"530\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-15.png 537w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-15-150x148.png 150w\" sizes=\"(max-width: 537px) 100vw, 537px\" \/><\/p>\n<ul>\n<li>\u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u067e\u0646\u062c\u0631\u0647 VBA \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f \u0648 \u067e\u06cc\u0627\u0645\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<li>\u062d\u0627\u0644\u0627 \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062f\u0631 \u06a9\u0627\u062f\u0631 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<\/ul>\n<pre class=\"language-visual-basic\"><code class=\"language-visual-basic\">Sub MultipleSheetsCSV()\r\nDim st As Worksheet\r\nDim path As String\r\nApplication.ScreenUpdating = False\r\npath = ActiveWorkbook.path &amp; \"\\\" &amp; Left(ActiveWorkbook.Name, InStr(ActiveWorkbook.Name, \".\") - 1)\r\nFor Each st In Worksheets\r\nst.Copy\r\nActiveWorkbook.SaveAs Filename:=path &amp; \"_\" &amp; st.Name &amp; \".csv\", FileFormat:=xlCSV, CreateBackup:=False\r\nActiveWorkbook.Close False\r\nNext\r\nApplication.ScreenUpdating = True\r\nEnd Sub<\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18023 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-16.png\" alt=\"VBA \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0628\u0631\u06af\u0647 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f\" width=\"700\" height=\"241\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-16.png 700w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-16-150x52.png 150w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/p>\n<ul>\n<li>\u0628\u0639\u062f \u0627\u0632 \u0630\u062e\u06cc\u0631\u0647 \u0641\u0627\u06cc\u0644\u060c F5 \u0631\u0627 \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u062f\u0631 \u067e\u0627\u06cc\u0627\u0646\u060c \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc CSV \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0628\u0631\u0627\u06cc \u0647\u0631 \u06a9\u0627\u0631\u0628\u0631\u06af \u062f\u0631 \u0641\u0627\u06cc\u0644 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c \u06a9\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644\u060c \u0645\u0627 5 \u0628\u0631\u06af\u0647 \u062f\u0627\u0631\u06cc\u0645\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c 5 \u0641\u0627\u06cc\u0644 CSV \u0631\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18024 aligncenter\" src=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-17.png\" alt=\"VBA \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0628\u0631\u06af\u0647 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f\" width=\"567\" height=\"169\" srcset=\"https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-17.png 567w, https:\/\/www.tehranserver.ir\/blog\/wp-content\/uploads\/2023\/08\/convert-excel-to-csv-format-17-150x45.png 150w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/p>\n<h3>\u062c\u0645\u0639 \u0628\u0646\u062f\u06cc<\/h3>\n<p>\u0627\u0632 \u0627\u06cc\u0646 \u067e\u0633\u060c \u0645\u06cc\u200c \u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0647 \u0641\u0631\u0645\u062a CSV \u0628\u0627 \u0631\u0648\u0634\u200c \u0647\u0627\u06cc \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0628\u0627\u0644\u0627 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0647\u0627 \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u06cc\u062f \u0648 \u0627\u06af\u0631 \u0631\u0627\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u062f\u0627\u0631\u06cc\u062f \u0628\u0647 \u0645\u0627 \u0627\u0637\u0644\u0627\u0639 \u062f\u0647\u06cc\u062f. \u0648 \u062f\u0631 \u0628\u062e\u0634 \u0646\u0638\u0631\u0627\u062a \u0622\u0646 \u0647\u0627 \u0631\u0627 \u0628\u0647 \u0645\u0627 \u0645\u0639\u0631\u0641\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>5 \u0631\u0627\u0647 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0647 CSV CSV \u06cc\u06a9\u06cc \u0627\u0632 \u0641\u0631\u0645\u062a \u0647\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0633\u0627\u062f\u06af\u06cc \u0648 \u06a9\u0645 \u062d\u062c\u0645\u06cc \u062f\u0631 \u0633\u0627\u0644 \u0647\u0627\u06cc \u0627\u062e\u06cc\u0631 \u0628\u0633\u06cc\u0627\u0631 \u0645\u062d\u0628\u0648\u0628 \u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0633\u062a. \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u0641\u0631\u0645\u062a \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0631\u062f \u0648 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0631\u0627 \u0627\u0639\u0645\u0627\u0644 \u06a9\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":18025,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,49],"tags":[3954,3956,3955,3953],"class_list":["post-18013","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-41","category-49","tag-----csv","tag---csv","tag-3955","tag----csv"],"_links":{"self":[{"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/posts\/18013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/comments?post=18013"}],"version-history":[{"count":0,"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/posts\/18013\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/media\/18025"}],"wp:attachment":[{"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/media?parent=18013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/categories?post=18013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tehranserver.ir\/blog\/wp-json\/wp\/v2\/tags?post=18013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}