Wish Tally Conversion v1.81

	A	D	G	M	Q	V	Z	AE	AI	AN	AR	AW
1	51871811
2	Wish Tally	Introduction		1) Making a copy of the spreadsheet		2) Authorising Wish Tally Script		3) Upload your export file		4a) Using Auto Import		4b) Copying your wish history to Wish Tally manually
3	Wish Tally
4	README
15	Contents

16	Introduction	This sheet is a tool to help convert exported files from:		You will need to have a Google account first before you can access the spreadsheet. Make a copy of this spreadsheet into your Google Drive. Be sure to have a copy of Wish Tally - Personal sheet ready.		This section explains how to activate the script to allow you to use all the buttons functionality in the spreadsheet.		Add the export file (xlsx or csv) to your google drive and get the link of the file. Restricted is fine since you are transfering data into your own file.		Automated way of transfering your export data directly to Wish Tally Personal		For those who want to copy and paste from the spreadsheet directly, this is for you.
17	1) Making a copy of the spreadsheet	Genshin Wish Export - XLSX file
18	2) Authorising Wish Tally Script	https://github.com/biuuu/genshin-wish-export
19	3) Upload your export file	Genshin Wishes - CSV file		Step 1		Step 1		Step 1		Step 1		Step 1
20	4a) Using Auto Import	https://genshin-wishes.com/		In the [File] menu toolbar, click [Make a copy]. This will create a copy of the spreadsheet into your Google Drive, which you can then modify to store your own wish history.		You must first authorise the built-in script of this document, otherwise the buttons will not work as intended. Begin the process by clicking on any button within this sheet		https://drive.google.com/drive/my-drive		Use the dropdown and select the export type. Genshin Gacha Export genshin-gacha-export xlsx file genshin-gacha-export xlsx converted to Google Sheet file Genshin Wishes genshin wishes export csv file		Step 1 - Ctrl A, Ctrl C, Ctrl V
21	4b) Copying your wish history to Wish Tally manually							To make updating easier, you should named your files the same when you update/overwrite. That way the script will continue to use the same URL, without having to do this step again for each file				Open the Takagg/Biuuu xlsx export and copy column A to F
22			#REF!
23			#REF!
24	#REF!								Step 2		Step 2
25	#REF!						Step 2		Right click on the uploaded file, click on 'Get Link'.		Enter the URL link of the export xlsx file for the source, from step "3) Upload your export file" Then the link to your personal Wish Tally spreadsheet, make sure the file type setting is correct, and select banner to import (usually All).
26	Wish Tally Google Sheet by Yippym				Step 2		You will see the following pop-up, click [Continue].
27	© All rights reserved by miHoYo. Other properties belong to their respective owners.				An "Copy document" popup will appear, you can rename the document within the "Name" section, clicking on [OK] will save a copy of Wish Tally Conversion into your Google Drive
28												Step 2 - Adjust and Convert
29						Step 3						Then paste into the top-left-most cell in the genshin-gacha-export convertor. Delete the top row if it's extra, and click ADJUST + SORT.
30						Click on your email account that you wish for the script to run on.
31								Step 3		Step 3
32								Copy link, this will be used for the script to grab the wishes from the document.		Pressing 'IMPORT' will begin transfering wishes to Wish Tally Personal, you will get a status for each banner. Please be patience when importing, it will only extract what is missing to help minimise the time of importing
33
34
35
36
37							Step 4					Step 3 - Copy
38							Click on [Advanced] to show more options, and click on [Go to Script for Wish Tally (unsafe)]					Copy the last 2 columns (Paste Value & Override)
39
40
41
42
43
44												Step 4 - Paste values
45												Paste that into your personal Wish Tally spreadsheet. Repeat Steps 1-4 for each banner, clear the converter in between each one.
46
47						Step 5
48						Click on [Allow], this will enable the script for this document. You will only need to do this once. When making a new copy of the Document you'll need to approve the script again.
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110