Olá,
When I started learning Portuguese, I couldn’t find a good application to help me study. So, since I like to use spreadsheets, I created something to help me learn the conjugations. Now that I cleaned it up a bit and made some videos on how to use it, I thought it would be useful for other learners. Of course I remembered Rui and Joel’s site with all of their videos. This is not a commercial product, just something that might help you. You’ll need a Google account to use it.
First, watch the introduction
If you might think it could be useful, go to the Google Sheet. Further help is available on the help tab. You’ll need to take ownership of the spreadsheet before you can use it.
Hi James This is really helpful - thank you! At the moment though, I can only view it and not fill it in…any help on how to change this would be much appreciated! Thank you again. Fiona
Hi Fiona,
As far as I know, you might be the only one that has downloaded the file. If you have any suggestions for the help file on the original or making it more useful, let me know. Happy learning!
Hi James! I think it is brilliant! A really helpful tool - thank you! Nothing to add as yet, but I’ll let you know if I think of anything. Kind regards Fiona
Thank you James. I have managed to download this, and I know it will be an extremely useful resource (when I fill it in!). One question, can you explain how to add accents to letters please? I looked for how to do this on YouTube but with no success.
Tenney
I know on the mac:
option-e and then a for á, option-e and e for é, option-e and i for í, option-e and o for ó
option-i and i for î, option-i and o for ô.
option-n and a for ã, option-n and o for õ.
option-` and a for à
I haven’t used a PC operating system in a while. I’ll see if I can find out. If your using a PC tell me if there are any other problems. Like I said, this is not a commercial product and I didn’t do a test of it on other platforms.
The comment the Francois Lagrange below the Practice Portuguese article seemed like a good option for PC users. For me typing on a phone is not the easiest. Good luck and have fun.
How to Type Foreign Characters, Accents, and Diacritics (Windows). There is a way to type or insert accent marks, tildes, umlauts, and a few other international characters and diacritics by changing your Windows keyboard input language to English US-International. Here is the youtube video.
I just modified my Google spreadsheet for the studying and testing of the conjugation of verbs. I know it is not for everyone, but I like to improve it for myself if not anyone else. I cleaned up the macros that creates a Verb Selection page adding more verbs and also made a macro to take conjugations from the Priberam dictionary to create code to add to the macros (with a boring but detailed Youtube video on how to modify the code. The link to the spreadsheet is the same. It incudes a link to the video. If you made a copy before you’ll need to make another one to take advantage of the new feature.
You are welcom Weiyu Yuan. I made this for myself because I need a bit of repetitivity to remember things. I know it isn’t for everyone. If you any problem with it, let e know.
James, your spreadsheet is awesome and a labour of love, I’m sure!
As an additional tool, I came across this website which is really handy: https://www.verbugata.com/.
You can choose on which tenses you want to test yourself.
