Track FedEx shipments

Question

I have to track 1,000’s of shipments a month, incoming and outgoing. Before I upgraded my excel to 2016, There was something built into my excel sheet that would pull back the status info for the tracking number that was in the first column. It would track both fedex and ups. Keep in mind this was something someone before me created. Since I’ve upgraded I no longer have that. I did find a add-in for UPS that works but nothing for FedEx. All the things I’ve looked up seem to be way out of my skill set or it doesn’t take you step by step on how to do it. A lot of the information I’m finding are multiple years old and do not work or isn’t supported anymore. I simply just want to enter the tracking number in one column and it populate the delivery status in another column. Any suggestions?

lorenzo kim · Answer

Mr. Griffith&nbsp;I simply just want to enter the tracking number in one column and it populate the delivery status in another columnI hope I got you right.. pls see attached sample.hope you can work something out of it.thanks..&nbsp;&nbsp;

sergeibaklan · Answer

You may track FedEx numbers from we site using Power Query, please see the sample at the end of this&nbsp;https://www.reddit.com/r/excel/comments/75xx7h/pulling_eta_data_from_fedex_into_excel/ discussion.
For the concrete number data return looks like

Similar of you have the table with FedEx tracking numbers, you may return the table with the statuses as above for all of them.&nbsp;Sample is at the same place as well.
&nbsp;
I'm not sure, but most probably the same works if you change carrier from Fedex on UPS.

joshua griffith · Answer

Any suggestions on a place that could walk me through power query’s? I’ve never used power query’s. Where would I put that information from that post?

sergeibaklan · Answer

Good question.
First, you need to have it. If you are on Excel 2016 it's built-in, Get &amp; Transform tab in ribbon.
If on Excel 2010 or 2013 you shall download and install it as add-in from MS download site, that's straightforward procedure.
&nbsp;
As for PQ perhaps it's better to start from MS support article, entry point is introduction&nbsp;https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605 and after that step by step by references. How many steps depends on how deep you'd like/you need to be in PQ.
And you may use that resource&nbsp;https://msdn.microsoft.com/en-us/query-bi/m/power-query-m-reference as a reference.
&nbsp;
Plus google always helps, on "power query &lt;how to&gt;" usually you easy find an answer.
&nbsp;
And yes, all above takes time.

Forum Discussion

Track FedEx shipments

4 Replies

Resources