{"id":749,"date":"2020-05-07T17:12:24","date_gmt":"2020-05-07T09:12:24","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=749"},"modified":"2020-05-07T17:57:15","modified_gmt":"2020-05-07T09:57:15","slug":"getting-started-with-easy-excel-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/getting-started-with-easy-excel-analysis\/","title":{"rendered":"Getting started with Easy Excel Analysis"},"content":{"rendered":"

To create an analysis table from an Excel file using Easy Excel Analysis<\/a>, here are the basic steps to follow:<\/p>\n

Importing your Excel file<\/h2>\n

Click on the Import Excel\/CSV file<\/strong> item, and select the Excel file you want to import.<\/p>\n

\"\"<\/p>\n

Select the worksheet you want to import data from.<\/p>\n

\"\"<\/p>\n

A preview of the selected worksheet is displayed on the right.\u00a0 Adjust the settings accordingly if your worksheet does not have a header, or has blank rows before the data rows.\u00a0 Click Next<\/strong>.<\/p>\n

On the next page, adjust the column types where necessary.\u00a0 Check that the date and time columns are identified correctly.\u00a0 If the columns have been formatted as date and\/or time columns in Excel, they will be identified correctly in Easy Excel Analysis<\/a>.\u00a0 Click Next<\/strong> when done.<\/p>\n

\"\"<\/p>\n

On this page, you can add additional columns that extract individual elements from date and time columns.\u00a0 In our example, we have chosen to add columns for the year, month, and quarter based on the Order Date<\/strong> column.\u00a0 Click Next <\/strong>after you have added the elements you require.<\/p>\n

\"\"<\/p>\n

On this page, you can choose to import data from additional Excel files and\/or worksheets.\u00a0 See this post<\/a> for further details.<\/p>\n

\"\"<\/p>\n

Click Next<\/strong>, and your Excel data will be imported into an analysis table<\/a>.<\/p>\n

<\/h2>\n

Importing your CSV file<\/h2>\n

The steps to Import a CSV file is similar to importing an Excel file.\u00a0 When you select a CSV file, the Import CSV File<\/strong> wizard displays a preview of the file.\u00a0 You may need to adjust the settings to import your file correctly.\u00a0 To determine if the settings are correct, click on the Preview<\/strong> button.<\/p>\n

\"\"<\/p>\n

In this example, we see a strange character next to the first column description.<\/p>\n

\"\"<\/p>\n

This is a common issue, and is fixed by selecting the Detect byte-order mark<\/strong> option.\u00a0 Easy Excel Analysis<\/a> will try to set this option automatically depending on the CSV file format.<\/p>\n

\"\"<\/p>\n

Other common settings to change include the Field separator<\/strong> symbol (default is the comma symbol), and the quote symbol<\/strong>.<\/p>\n

\"\"<\/p>\n

To check if the CSV file will be imported correctly, click on the Preview<\/strong> button to check the lines that will be imported.<\/p>\n

The rest of the steps is identical to that for importing Excel files described above.<\/p>\n

 <\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

To create an analysis table from an Excel file using Easy Excel Analysis, here are the basic steps to follow: Importing your Excel file Click on the Import Excel\/CSV file item, and select the Excel file you want to import. Select the worksheet you want to import data from. A preview of the selected worksheet […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82],"tags":[104,83],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/749"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=749"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/749\/revisions"}],"predecessor-version":[{"id":769,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/749\/revisions\/769"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}