These are newly updated guides for working with your Prolific Submission History CSV file now that they have introduced the new multi-currency payment system for Excel and Google Sheets.

Excel

1)	Open a new blank workbook.
2)	Go to the Data Tab, click From Text/CSV, select your Prolific CSV file and click Load on the next screen.
3)	On the View Tab click Freeze Top Row under Freeze Panes
4)	Select Column F, right-click and insert a new blank column F will be created.
5)	Select Column F again and change it to Time in the Home Tab under Number then Rename Column F header to Time Taken.
6)	Select both Columns D & E and change them to Short Date (This is more for easier visuals as we are going to calculate the time taken for each study next)
7)	Select the top Cell in Column F, under Time Taken, then copy and paste this formula into the formula bar and hit enter: =IF(AND(ISNUMBER(E2), ISNUMBER(D2)),E2-D2," ")

You should see a small fx icon in the cell below cell F2, click on the dropdown arrow and click Overwrite all cells in this column with this formula. What this formula does is calculate the time taken for each study but it will ignore any study you returned but did not submit any type of completion code as Prolific does not include stop times and dates for these in the CSV file.

8)	Select Column C and insert a new column then select Column E and insert a new column.
9)	On the dropdown arrow next to Started At, select Newest to Oldest (This is more for easy viewing the new $ payments)
10)	Select Column B, go to Data Tab and click Text to Columns on the wizard popup make sure Delimited is selected and click Next, uncheck Tab, check the Other box and add a $ then Next and Finish, you will get a data warning just ignore it and click OK.
11)	This will then move all $ Rewards over then repeat those same steps for Column D for $ bonuses.
12)	Select the Home Tab and then select column C, click the dropdown arrow on the currency icon and select $ and do the same for Column E.
13)	At this point I tend to rename these two column headers to Reward $ and Bonus $ as it makes some calculations a bit easier in the future but you can give them any names you wish.
14)	 Select Cell B2 and copy £ from the formula bar, then press ctrl + H, to bring up the Find and Replace box. In the Find what box paste £ and leave the Replace with box empty and click Replace all, Select Column B and choose £ from the currency option above Number on the home tab and do the same for Column D.

From this point on you can calculate the amounts you’ve received over yearly, monthly, and weekly periods, how many hours, minutes and seconds you’ve taken over a period—your approval rating and whatever else you wish to make, like pivot tables and graphs.

One word of caution when working out your income don’t forget to include your returned study bonus payments, I tend to put these on a separate sheet in the workbook as with approved studies, if you need help doing that just let me know.

Google Sheets

1)	New blank spreadsheet, File Import and upload your Prolific CSV file, on the Import file window leave everything as default and Import data, you may have to wait for a little while depending on how large your CSV file is.
2)	Right-click on Study and select Create filter.
3)	Select row 1, go to view and select Freeze 1 row.
4)	Select Column F and right-click and insert 1 column to the left, go to Format, Number and select Time. Then add the header Title as Time Taken
5)	Select both Columns D & E then go to Format, Number and select Date
6)	Select the top Cell in Column F, under Time Taken, then copy and paste this formula into the formula bar and hit enter: =IF(AND(ISNUMBER(E2), ISNUMBER(D2)),E2-D2," ")
7)	You should get a Suggested auto-fill window just click the tick option, which will then add the same formula calculation to the rest of the table.
8)	Select Z to A on the filter for Started At, so you’ll see the new $ payments.
9)	Select column C and right-click and insert a 1 column to the left and then again select column E but 1 column to the right.
10)	Select column B, click Data and select Split text to columns, in the Separator box choose custom and put in $ in the box.
11)	Select column C, go to Format, Number and US Dollar (You may have to use custom to search for US Dollar if it is not in your list)
12)	Repeat the same steps for columns D and E.
13)	Add title headers for Columns C & E

That is it you can now sort and filter and calculate whatever you need.

Please note these are not definitive guides on how to use Excel or Google Sheets as there are plenty of tutorials out there for that online, these should be classed as quick and easy to follow guides more than anything else.