I have a large Excel spreadsheet (sheet/workbook) that I need to import into an RH table. I have tried saving it as an HTML webpage and importing it, I have tried XML, and many other methods.
When I tried importing as an HTML, the file would never appear in my Project Manager but would be in the project folder on my computer. Even if I tried to use the "Find Topic" feature, I could not locate the file in the Project Manager. (Background info-I exported the spreadsheet to HTML/Webpage file)
When I tried to import an Word/Text file, the file did appear in the Project Manager-however, it was all a big "blob" of text-it did not have everything laid out into columns. (Background info-I exported the spreadsheet to a text file).
When I tried to import an XML file, the file did not appear as a single file in the Project Manager. Instead, the file broke out into NUMEROUS files-one for every single line item in the spreadsheet (just under 1,000).