Import a CSV File and Pivot tables

%3CLINGO-SUB%20id%3D%22lingo-sub-941822%22%20slang%3D%22en-US%22%3EImport%20a%20CSV%20File%20and%20Pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-941822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20940px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F145828i2498994B1C70F97E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-10-23%20at%208.17.03%20PM.png%22%20title%3D%22Screen%20Shot%202019-10-23%20at%208.17.03%20PM.png%22%20%2F%3E%3C%2FSPAN%3EHi%2C%20I%20have%20to%20do%20this%20assignment%20that%20is%20due%20October%2025%20at%2012pm%20PST%20but%20I%20have%20been%20really%20struggling%20because%20I%20dont%20know%20how%20to%20%26nbsp%3Bimport%20the%20file%20they%20gave%20me%20into%20a%20csv.file%20let%20alone%20create%20a%20pivot%20table%20or%20a%20%22stab%22%20someone%20please%20help%20me!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-941822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecsv%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-942214%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20a%20CSV%20File%20and%20Pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-942214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F432313%22%20target%3D%22_blank%22%3E%40gabriellerocha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20open%20the%20%22.csv%22%20file%20with%20Excel.%20CSV%20stands%20for%20%22comma%20separated%20values%22.%20The%20file%20probably%20contains%20plain%20text%20(words%2C%20numbers%2C%20time%20periods%20etc.)%20separated%20by%20commas.%20When%20you%20open%20it%20in%20Excel%2C%20it%20will%20automatically%20create%20columns%20of%20data%20that%20you%20are%20asked%20to%20examine.%20And%20I%20guess%20that%20he%20references%20to%20%22stabb%22%20and%20%22styear%22%20are%20some%20of%20the%20column%20headers.%20Once%20%22imported%22%2C%20save%20the%20file%20as%20a%20regular%20.xlsx%20file%20and%20continue%20with%20your%20assignment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20exactly%20what%20the%20instruction%20says%20on%20how%20to%20create%20a%20Pivot%20Table.%20Once%20you%20have%20come%20to%20the%20%22Create%20Pivot%20Table%22%20dialogue%20box%2C%20it's%20all%20quite%20intuitive.%20Read%20everything%20carefully%2C%20press%20OK%20and%20see%20what%20happens.%20If%20it%20goes%20wrong%2C%20start%20all%20over%20again%20until%20you%20got%20it%20right.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-946624%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20a%20CSV%20File%20and%20Pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-946624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20okay%20I%20know%20what%20you%20mean%20but%20the%20thing%20is%20there%20are%20two%20parts%20to%20it%20and%20I%20dont%20know%20if%20I%20put%20it%20together%20in%20one%20or%20separate.%20I%20am%20really%20confused%20on%20what%20to%20do%20in%20general.%20I%20have%20absolutely%20no%20experience%20with%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BDo%20you%20think%20you%20could%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F147268iE1865FDB4F7C1395%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-10-24%20at%2011.04.19%20AM.png%22%20title%3D%22Screen%20Shot%202019-10-24%20at%2011.04.19%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-946770%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20a%20CSV%20File%20and%20Pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-946770%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F432313%22%20target%3D%22_blank%22%3E%40gabriellerocha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20a%20historian%20and%20have%20no%20clue%20about%20what%20you%20are%20supposed%20to%20analyse.%20I%20can't%20make%20the%20table(s)%20for%20you.%20But%2C%3CSPAN%3E%26nbsp%3Byou%20managed%20to%20%22import%22%20the%20data%20into%20Excel.%20Creating%20the%20Pivot%20Table%20is%20no%20more%20than%20following%20the%20instructions%20in%20your%20assignment%20paper.%20Just%20select%20a%20cell%20anywhere%20inside%20the%20data%20and%20press%20DATA%20(in%20the%20menu%20at%20the%20top)%20and%20then%20%22Summarise%20with%20Pivot%20Table%22%20and%20see%20what%20happens.%20Follow%20the%20instructions%20a%20try.%20Don't%20be%20scared%20to%20do%20wrong.%20If%20you%20do%2C%20discard%20and%20start%20from%20the%20beginning.%20You'll%20figure%20it%20out.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPS%3A%20Don't%20really%20understand%20that%20you%20are%20asked%20to%20do%20this%20without%20having%20been%20told%20about%20the%20basics%20of%20pivot%20tables%20in%20Excel.%20Good%20Luck!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Screen Shot 2019-10-23 at 8.17.03 PM.pngHi, I have to do this assignment that is due October 25 at 12pm PST but I have been really struggling because I dont know how to  import the file they gave me into a csv.file let alone create a pivot table or a "stab" someone please help me!!

3 Replies
Highlighted

@gabriellerocha 

 

Just open the ".csv" file with Excel. CSV stands for "comma separated values". The file probably contains plain text (words, numbers, time periods etc.) separated by commas. When you open it in Excel, it will automatically create columns of data that you are asked to examine. And I guess that he references to "stabb" and "styear" are some of the column headers. Once "imported", save the file as a regular .xlsx file and continue with your assignment.

 

Do exactly what the instruction says on how to create a Pivot Table. Once you have come to the "Create Pivot Table" dialogue box, it's all quite intuitive. Read everything carefully, press OK and see what happens. If it goes wrong, start all over again until you got it right.

 

Good luck!

 

Highlighted

@Riny_van_Eekelen  okay I know what you mean but the thing is there are two parts to it and I dont know if I put it together in one or separate. I am really confused on what to do in general. I have absolutely no experience with excel.

 

 Do you think you could help me?

 

Screen Shot 2019-10-24 at 11.04.19 AM.png

Highlighted

@gabriellerocha 

I'm not a historian and have no clue about what you are supposed to analyse. I can't make the table(s) for you. But, you managed to "import" the data into Excel. Creating the Pivot Table is no more than following the instructions in your assignment paper. Just select a cell anywhere inside the data and press DATA (in the menu at the top) and then "Summarise with Pivot Table" and see what happens. Follow the instructions a try. Don't be scared to do wrong. If you do, discard and start from the beginning. You'll figure it out.

 

PS: Don't really understand that you are asked to do this without having been told about the basics of pivot tables in Excel. Good Luck!