Hey everyone. Daniel here from TwinBytes with another quick tech-torial for you
In this video I'm going to show you how to export your outlook 2019 calendar
into Excel format. I did an old video on this back in 2009
and someone commented recently that this can't be done anymore.
Well definitely not done using that same procedure.
So here I'm going to show you how to do it correctly
using the 2019 edition of Outlook.
If you find my videos helpful please Like and Subscribe. Thanks.
okay so from the Outlook program
You don't have to go into the calendar view where I'm in currently
but you could be in the mail view or any view within outlook
what you want to do is click up at the top on File
and go down to Options. In the options you want to go over to
Advanced and then scroll down a little bit until
you see Export.
click on the export button. You'll see a series of options here
and what you want is to export to a file. You can hit Next,
and you would want to have Comma Separated Values to put it in Excel.
If you were exporting it as a backup or to transfer
or import into another computer then you could choose a PST file
but here we want to have it in Excel. So Comma Separated Values will give us a
CSV file. In here it may highlight your
calendar by default but if not go find it
and highlight that and then you can hit Next.
Choose where you want to store the file and what you want to call it
and you're going to see that it's going to be a CSV format.
Hit next. You do have the option of mapping custom fields but in
this case we're just exporting it as it is, we're not preparing it to
import anywhere else. You can always make these
changes after it's in Excel format. So you can just leave this alone and hit Finish.
Choose the date range
whatever you want and in this case I want to have the same date
so I'm just going to copy and paste and hit OK and it exports, and depending on
how long of a range you selected it could take a little bit longer to run
but in this case I'm exporting a single day
and it still takes a few seconds. Now it's done so we can basically close
out of this window and then open up our excel sheet.
so once you open the Excel file, you're gonna see it looks a little bit of a mess.
Everything is squished for the columns
and the rows may be quite wide so what you would do is you
can click up in the top left corner here between
column and a row and double click on the line
that's between column A and B, so the mouse pointer turns into a double
facing arrow. Double click on that and it makes it to
the perfect width so you can read all the text, and then the same thing
here in the rows between row 1 and 2 when you get
that double facing arrow, double click and it perfectly aligns everything as
best it can. Now some of these are squished a bit and
you'll be able to see why here in a second, but there's the subject which is
the main part of the calendar, you can see
the date and time and there's additional information if
you go over you'll see where your notes are...
that's about as long as it is; and if you have these squished into multiple
lines you might not be able to do much about it but i know these should
mostly be all on one line. So even though we did that double click to make
everything the perfect width it didn't do it for all of them. So it
didn't do it for the description at least so here we'll have to grab this
and drag it and manually make it bigger and then if you double click that it
lines it back up. Now if we go back over here to highlight
everything and double click between the rows
now it lines them up a little tighter so it looks
a little bit more compact, especially if you have a lot to look at.
So that's it for exporting and a little bit on customizing it once it's exported
so I hope you found this helpful. If you want to find out any more details about
Excel or anything else for that matter, please put your comments down below
and if you like the video of course give it a thumbs up and subscribe
we'll see you in the next one. Bye for now.