Skip to main content
Jun 18, 2020 12:48 PM UTC

Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.

Originally posted by Michael Malandra

6/18/2018

Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.

1 reply

Jun 25, 2020 11:48 AM UTC
Originally posted by Chul Smith

It's the easiest data source - don't need to define any of the dimensions, just ensure that the Allow Dynamic Excel Load is TRUE and put in your xfd ranges in each tab. If you want each tab to be listed as a source, use the Excel formula to pull in the tab name for Source ID.