Import excel spreadsheet from sharepoint

Question & Answer
, ,
1

We have a bunch of excel spreadsheets stored in sharepoint that will need to be somehow ingested into quicksight.

Can anyone describe a good method for getting the data from these shared spreadsheets?

Cheers,
D

2

Hi @jones_possibly
How frequently do you have to do it?
BR

3

Hello @jones_possibly, are you still seeking support on ingesting the excel spreadsheets into QuickSight? If so, can you respond to @ErikG’s question so we can try to assist you in finding a solution? If we do not receive a response in 3 days I will go ahead and unlist this question.

Otherwise, if you already figured this out on your own, let us know what solution you used to make this work. Thank you!

1 Like
4

My apologies - I totally forgot about this with other work commitments.
We would need to import the data every day.,

5

Hi @jones_possibly,
i guess there are many way, depending on the direction you are looking at it (push/pull).
I would bring the data into S3 and connect with QS.

Push: “SharePoint Files to AWS S3 via Power Automate” looks promising

Pull:

BR

1 Like
6

Cheers @ErikG, seems like a plausable solution. I come from the power BI world, so importing stuff like this is just point and click.

1 Like