{"id":61182,"date":"2022-10-07T10:34:37","date_gmt":"2022-10-07T08:34:37","guid":{"rendered":"https:\/\/www.piigab.com\/?post_type=ufaq&p=61182"},"modified":"2022-10-07T10:35:20","modified_gmt":"2022-10-07T08:35:20","slug":"lasa-csv-i-excel","status":"publish","type":"ufaq","link":"https:\/\/www.piigab.com\/en\/faq\/lasa-csv-i-excel\/","title":{"rendered":"Reading CSV in EXCEL"},"content":{"rendered":"
\n\n\t\n\n\n\n\n\n\n\t\n\t\n\t
\n\n\t\t
\n\n\t
\n\t\n\t\n\n\t\t
\n\t\t\tA<\/span>\n\t\t<\/div>\n\n\t\t
\n\n\t\t\t

\n\t\t\t\tReading CSV in EXCEL\t\t\t<\/h4>\n\n\t\t<\/div>\n\n\t\t
<\/div>\n\n\t<\/a>\n\t\n<\/div>\n\t\n\t
\n\n\t\t\n\t\t\t\n\t\t\n\t\t\t
\n\t\n

Our configuration files and meter lists are in CSV format.<\/p>\n\n\n\n

If you want to edit these in Excel, they will look strange when you open them as all the information is in the same column.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For an easier overview, follow these steps.<\/p>\n\n\n\n

Tick column A.
Go to Data in the menu
Then select Text to column<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n


<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

When the wizard asks for the Original data type, select Delimited fields and then Next<\/strong>
Now select Comma to be a delimiter, press Next<\/strong> and then Finalise.<\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

Now the information has been split into different columns.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n<\/div>\n\t\t\n\t\t\t

\n\n\t\n<\/div>\n\t\t\n\t\t\t
\n\t\n\tKategori\n\t\n\t\t\u00d6vrigt\n\t\n<\/div>\n\t\t\n\t\t\t\n\t\t\n\t\t\t
\n\t\n\t
\n\t\tDo you think the answer helped you?\t<\/div>\n\t\n\t
\n\t\t\"Thumbs\t\t2<\/span>\n\t<\/div>\n\t\n\t
\n\t\t\"Thumbs\t\t0<\/span>\n\t<\/div>\n<\/div>\n\n
<\/div>\n\t\t\n\t\t\t\n\t\t\n\t\t\t
\n\t\n\t\n\t\t\n\t\tLink to this article\t\t\t\n\t<\/a>\n\n<\/div>\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t<\/div>\n\n<\/div>\n\t<\/div>\n\n\t\n<\/div>","protected":false},"excerpt":{"rendered":"

A L\u00e4sa CSV i EXCEL V\u00e5ra konfigurationsfiler och m\u00e4tarlistor \u00e4r i CSV format. Vill du redigera dessa i Excel kommer de se m\u00e4rkliga ut n\u00e4r du \u00f6ppnar dem d\u00e5 all information ligger i samma kolumn. F\u00f6r en enklare \u00f6verblick f\u00f6lj dessa steg. Markera kolumn A.G\u00e5 till Data i menyn V\u00e4lj sedan Text till kolumn N\u00e4r […]<\/p>","protected":false},"author":9,"comment_status":"open","ping_status":"closed","template":"","ufaq-category":[274],"ufaq-tag":[],"class_list":["post-61182","ufaq","type-ufaq","status-publish","hentry","ufaq-category-ovrigt"],"_links":{"self":[{"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/ufaq\/61182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/ufaq"}],"about":[{"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/types\/ufaq"}],"author":[{"embeddable":true,"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/comments?post=61182"}],"wp:attachment":[{"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/media?parent=61182"}],"wp:term":[{"taxonomy":"ufaq-category","embeddable":true,"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/ufaq-category?post=61182"},{"taxonomy":"ufaq-tag","embeddable":true,"href":"https:\/\/www.piigab.com\/en\/wp-json\/wp\/v2\/ufaq-tag?post=61182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}